Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i have liner regression equatoin i need you to test that on testing set that is provided and tell me r square for the testing
i have liner regression equatoin i need you to test that on testing set that is provided and tell me r square for the testing set.
| Coefficients | |
| Intercept | 1981.600777 |
| February | -0.033331055 |
| March | -0.151989982 |
| April | -0.215512757 |
| May | -0.323797503 |
| June | -0.393675233 |
| July | -0.498270121 |
| August | -0.502950097 |
| September | -0.548339368 |
| October | -0.565961096 |
| November | -0.568751804 |
| December | -0.693818133 |
| ElantraSales | 1.31093E-05 |
| Unemployment | -0.309413897 |
| Queries | 0.000804024 |
| CPI.Energy | -0.015633618 |
| CPI.All | 0.159565087 |
equation
| Y=1981.6007770.033331055February0.151989982March0.215512757April0.323797503May0.393675233June0.498270121July0.502950097August0.548339368September0.565961096October0.568751804November0.693818133December+1.31093105ElantraSales0.309413897Unemployment+0.000804024Queries0.015633618CPI.Energy+0.159565087CPI.All0.548339368September0.565961096October0.568751804November0.693818133December+1.31093105ElantraSales0.309413897Unemployment+0.000804024Queries0.015633618CPI.Energy+0.159565087CPI.All |
testing set:
| Year | MONTHS | February | March | April | May | June | July | August | September | October | November | December | ElantraSales | Unemployment | Queries | CPI.Energy | CPI.All |
| 2013 | January | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12174 | 7.9 | 230 | 242.56 | 231.321 |
| 2013 | February | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16219 | 7.7 | 239 | 252.639 | 232.599 |
| 2013 | March | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26153 | 7.5 | 313 | 244.598 | 232.075 |
| 2013 | April | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24445 | 7.5 | 248 | 238.86 | 231.707 |
| 2013 | May | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25090 | 7.5 | 252 | 240.972 | 232.124 |
| 2013 | June | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 22163 | 7.5 | 320 | 245.412 | 232.86 |
| 2013 | July | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 23958 | 7.3 | 274 | 245.926 | 233.252 |
| 2013 | August | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 24700 | 7.2 | 271 | 244.917 | 233.433 |
| 2013 | September | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 19691 | 7.2 | 298 | 245.566 | 233.743 |
| 2013 | October | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 14876 | 7.2 | 223 | 243.374 | 233.782 |
| 2013 | November | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 16751 | 7 | 231 | 242.301 | 234.033 |
| 2013 | December | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 21692 | 6.7 | 279 | 246.189 | 234.594 |
| 2014 | January | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15326 | 6.6 | 232 | 247.575 | 234.933 |
| 2014 | February | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16393 | 6.7 | 240 | 246.389 | 235.169 |
use excel and share all formula tab and result, thanks
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
Discrete Mathematics and Its Applications
Authors: Kenneth H. Rosen
7th edition
0073383090, 978-0073383095
