[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 |
Deliverable: Word Document 