View the step-by-step solution to:

Question

The table below gives the average weight (in kilograms) of certain people

ages 1-20

. Use Excel to find the best fit linear regression equation, where age is the explanatory variable. Round the slope and intercept to two decimal places.

Age /Weight 1/ 9.2 2 /12 3 /14.2 4 /15.4 5/ 17.9 6 /19.9 7 /22.4 8 /25.8 9 /28.1 10 /31.9 11/ 36.9 12/ 41.5 13/ 45.8 14/ 47.6 15/ 52.1 16/ 53.5 17/ 54.4 18/ 56.7 19/ 57.1 20/ 58

Top Answer

View the full answer
Screenshot (462).png

A
B
C
D
E
F
G
2 Regression Analysis
3
A
12 0.981
n 20
5
r 0.991
k 1
6
Std. Error 2.422
Dep. Var. Weight
ANOVA table
9
Source
SS
df
MS
F
0-value
10
Regression 5,547.5015
1
5,547.5015
946.04...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question