Answered step by step
Verified Expert Solution
Question
1 Approved Answer
X 22 41 35 72 14 40 10 22 15 22 29 51 13 21 17 27 21 34 23 38 28 47 12 24
X 22 41 35 72 14 40 10 22 15 22 29 51 13 21 17 27 21 34 23 38 28 47 12 24 18 34 25 53 26 47 26 42 15 32 24 45 32 60 28 64 20 43 27 53 34 60 33 65 23 52 29 62 21 51 20 51 31 70 33 77Consider the sample data included in worksheet Q1 of the "Test - Regression Analysis.xIsx" Excel file. Excel data file a. Construct and interpret the scatterplot. The scatterplot shows that x and y appear to have a positive linear relationship. v b. Calculate the sample correlation coefficient. Enter your answer with a three-decimal digit precision. 0.902 c. Calculate bo and by. What is the sample regression equation? (Negative values should be indicated by a minus sign. Round answers to 2 decimal places.) y = d. Find the predicted value for y if x equals 10, 15, and 20. (Negative values should be indicated by a minus sign. Round answers to 2 decimal places.) X 10 15 20
Step 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