[Steps Shown] Perform the following steps for the problems (please use Excel and send me a copy) - Draw a scatter plot - Compute the value of the correlation


Question:

Perform the following steps for the problems (please use Excel and send me a copy)

- Draw a scatter plot

- Compute the value of the correlation coefficient

- Test the significance of the correlation coefficient at α= 0.01, using Table I

- Determine the regression line equation

- Plot the regression line on the scatter plot

- Predict y’ for a specific value of x.

Day Care Centers A researcher wishes to determine if there is a relationship between the number of day care centers and the number of group day care homes for counties in Pennsylvania. If there is a significant relationship, predict the number of group care homes a county has if the county has 20 day care centers

Day care centers x 5 28 37 16 16 48
Group day care homes y 2 7 4 10 6 9

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in