Question: INSTRUCTIONS: Solve all questions using excel functions and the excel data analysis pack Can someone help me by going through what I need to put

INSTRUCTIONS: "Solve all questions using excel functions and the excel data analysis pack"

Can someone help me by going through what I need to put in terms of the functions/ answering these - I have absolutely no idea what I'm doing. Please explain in a detailed and simple manner - I have never done stats via excel before.

INSTRUCTIONS: "Solve all questions using excel functions and the excel data analysispack"Can someone help me by going through what I need to put

C D E F G H K 03 12 Marks 2 A researcher is Interested in determining if age predicts weight or not. 3 The table to the right indicate the age and weights of the people (14) in the sample. 4 5 G a) Run simple regression analysis using Excel. 2 Mark Note: use 95% confidence level. B b) Is age a significant determinant of weight? Explain. 3 Marks 10 c) What is amount of variation in weight that is explained by age? Explain. 4 Marks 12 13 d) What is the expected weight of a person who is 56 years old? 3 Marks 5N P Age Weight 54 65 62 92 80 82 25 74 28 76 71 62 79 64 85 47 82 49 62 52 64 35 54 36 73 91 83

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!