Given below are seven observations collected in a regression study on two variables, x (independent variable) and y (dependent variable). Copy and paste the numbers in an Excel worksheet and then use Excel's Regression tool to conduct a simple linear regression analysis. Choose 95% confidence level. Answer the following questions: x y 2 12 3 9 6 8 7 7 8 6 7 5 9 2
Given below are seven observations collected in a regression study on two variables, x (independent variable) and y (dependent variable). Copy and paste the numbers in an Excel worksheet and then use Excel's Regression tool to conduct a simple linear
x | y |
---|---|
2 | 12 |
3 | 9 |
6 | 8 |
7 | 7 |
8 | 6 |
7 | 5 |
9 | 2 |
What is the
What is the coefficient of determination? (Keep 2 decimal places) Answer
Find out y-intercept b0 (Keep 2 decimal places) Answer
Find out regression coefficient b1 (Keep 2 decimal places) Answer
Find out SSR (Keep 2 decimal places) Answer
Find out SST (Only report the integer part) Answer
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images