Question
For this data set, run a regression line in excel using the data/ data analysis tab. a. State the equation for the line of best
For this data set, run a regression line in excel using the data/ data analysis tab.
a. State the equation for the line of best fit and explain what the slope coefficient means.
b. What is the R^2 value and what does it mean?
c. Solve the equatiob by setting X=0 and ansser. What is another name for the value/answer that you just found?
d. Do you require an adjusted R^2? Why or why not?
DATA SET:
Hospital Room Size (square footage) | Electricity Bill |
3117 | 186.435 |
1086 | 74.73 |
4276 | 250.18 |
4019 | 236.045 |
857 | 62.135 |
3114 | 186.27 |
1132 | 77.26 |
3427 | 203.485 |
690 | 52.95 |
4806 | 279.33 |
4052 | 234.86 |
173 | 21.515 |
1948 | 119.14 |
209 | 23.495 |
1175 | 76.625 |
3223 | 189.265 |
3950 | 229.25 |
4778 | 274.79 |
3089 | 181.895 |
1524 | 95.82 |
4082 | 236.51 |
276 | 36.18 |
478 | 47.29 |
1482 | 102.51 |
3933 | 237.315 |
1533 | 105.315 |
4095 | 246.225 |
4791 | 284.505 |
2893 | 180.115 |
1950 | 128.25 |
2263 | 145.465 |
4344 | 259.92 |
2805 | 175.275 |
4329 | 123.225 |
896 | 37.4 |
4671 | 131.775 |
146 | 18.65 |
1910 | 89 |
622 | 30.55 |
1422 | 50.55 |
2241 | 71.025 |
564 | 29.1 |
2972 | 89.3 |
123 | 18.075 |
2740 | 83.5 |
1342 | 48.55 |
246 | 21.15 |
1213 | 45.325 |
3558 | 103.95 |
2782 | 84.55 |
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