You are a member of a group of researchers who studythe reading ability of children. You would like to know if any ofthe following factors have an effect on the reading ability of achild: age, memory span, and IQ. You conduct a pilot study on asmall group of 20 children. From the initial finding, you will makerecommendations to your group on furtherresearch.
Complete the regression analyses and answer the questions aboutthe models on this paper. Copy and paste Excel output to show howyou determined your answers.
| age | memory_span | IQ | reading_ability |
| 6.7 | 4.4 | 95 | 7.2 |
| 5.9 | 4 | 90 | 6 |
| 5.5 | 4.1 | 105 | 6 |
| 6.2 | 4.8 | 98 | 6.6 |
| 6.4 | 5 | 106 | 7 |
| 7.3 | 5.5 | 100 | 7.2 |
| 5.7 | 3.6 | 88 | 5.3 |
| 6.15 | 5 | 95 | 6.4 |
| 7.5 | 5.4 | 96 | 6.6 |
| 6.9 | 5 | 104 | 7.3 |
| 4.1 | 3.9 | 108 | 5 |
| 5.5 | 4.2 | 90 | 5.8 |
| 6.9 | 4.5 | 91 | 6.6 |
| 7.2 | 5 | 92 | 6.8 |
| 4 | 4.2 | 101 | 5.6 |
| 7.3 | 5.5 | 100 | 7.2 |
| 5.9 | 4 | 90 | 6 |
| 5.5 | 4.2 | 90 | 5.8 |
| 4 | 4.2 | 101 | 5.6 |
| 5.9 | 4 | 90 | 6 |
- Build a regression model using the variables as shown below.Review the results and determine which is the model is the“best”.
Model | Dependent variable | Independent variables |
Model 7 | read_ability | age, mem_span, IQ |
- What is the ANOVA table of the model?
- What is the regression equation of the model?
- Conduct the test for the significance of the Overall RegressionModel for the model?
- What is R2 of the best model?
- What are the 95% confidence intervals for the estimates of theregression coefficients—theBi’s?
- Provide an interpretation of the slopes,bi’s.
- Select one model you would use to explain reading ability. Thenuse that model to find the
- 95% confidence interval estimate for the mean readingability
- 95% prediction interval for reading ability
When age = 6, mem_span = 4.2 and IQ =91.
Which model did you select andwhy?
