Create one scatter plot of the data

Reference no: EM132035652

Question: Use the data from the nursing scenario from the file I uploaded.

Create at least two visuals using your data from the data you chose in Week 2.

1. Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value, and prediction value on the visual.

2. Create one scatter plot of the data, and apply an exponential model in Excel®. Include the equation, R2 value, and prediction value on the visual.

3. Determine whether the linear or the exponential model is a better representation of your data to base your prediction on. Explain why the model you chose is a better representation of your data.

Hints for Making an Effective Chart:

• Decide why you are making a chart from this data.

• Title each chart so that it aligns with the data and selected model.

• Create descriptive labels for both the x- and y axes.

• Resize the chart as needed so it can be viewed easily.

Information related to above question is enclosed below:

Attachment:- Scenarios_and_Data.rar

Reference no: EM132035652

Questions Cloud

Job aptitude scores and job success ratings : Which of the following is the best guess as to the value for r had all, rather than just the best qualified, applicants been hired?

What is the probability that a randomly selected tree : What is the probability that a randomly selected tree will be at least 12 in. in diameter?

Average commute time exceeds : The lengths of time Al's commute are normally distributed with mean 36 minutes and standard deviation 4.5 minutes

Confidence interval for the proportion of nb residents : 48 our of a random sample of 208 residents in NB township said they want a new park for a 90% confidence interval for the proportion of NB residents

Create one scatter plot of the data : Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value.

Test your claim of a lower standard deviation : Test your claim of a lower standard deviation at a 5% significance level this is all there is to add about the question

Find the critical value the company officials : One of the biggest issues facing e-retailers is the ability to turn browsers into buyers. This is measured by the conversion rate

Are they independent or dependent : Just looking at the numbers in the table, what is your best guess about the relationship between reason for continuing education and job type?

Explain the effects of prescribed drugs : Select one of the following factors: genetics, gender, ethnicity, age, or behavior. Reflect on how this factor might impact the effects of prescribed drugs.

User Account

All Pages