You are a member of a group of researchers who study the reading ability of children....

90.2K

Verified Solution

Question

Basic Math

  1. 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.

    agememory_spanIQreading_ability
    6.74.4957.2
    5.94906
    5.54.11056
    6.24.8986.6
    6.451067
    7.35.51007.2
    5.73.6885.3
    6.155956.4
    7.55.4966.6
    6.951047.3
    4.13.91085
    5.54.2905.8
    6.94.5916.6
    7.25926.8
    44.21015.6
    7.35.51007.2
    5.94906
    5.54.2905.8
    44.21015.6
    5.94906
  2. 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

  1. What is the ANOVA table of the model?
  1. What is the regression equation of the model?
  1. Conduct the test for the significance of the Overall RegressionModel for the model?
  1. What is R2 of the best model?
  1. What are the 95% confidence intervals for the estimates of theregression coefficients—theBi’s?
  1. Provide an interpretation of the slopes,bi’s.
  1. 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?

Answer & Explanation Solved by verified expert
3.9 Ratings (445 Votes)
SolutionIn excel install analysis toolpak and then go toData Data analysisRegressionYou wil getSUMMARY OUTPUTRegression StatisticsMultipleR0913761809RSquare0834960644AdjustedR    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students