Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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 83Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started