Question: Please use SPSS to answer this question for regression and include all regression table and graph . Based on the given data uploaded , conduct
Please use SPSS to answer this question for regression and include all regression table and graph.
Based on the given data uploaded, conduct a regression analysis for the variable energy consumption (enrgcons) using Capacity area (area). Summarized your findings including all regular steps for regression.
| Hotels | enrgcons | area | age | guestrooms | occrate | effrooms |
| 1 | 1953916 | 43000 | 6 | 420 | 0.326 | 136.92 |
| 2 | 1045555 | 19979 | 16 | 215 | 0.63 | 135.45 |
| 3 | 4245313 | 46529 | 7 | 273 | 0.6505 | 177.59 |
| 4 | 2126199 | 20962 | 6 | 222 | 0.705 | 156.51 |
| 5 | 2785958 | 24212 | 5 | 474 | 0.697 | 330.38 |
| 6 | 13833968 | 112200 | 4 | 787 | 0.4897 | 385.39 |
| 7 | 5558123 | 45000 | 3 | 325 | 0.49 | 159.25 |
| 8 | 4001213 | 28548 | 6 | 199 | 0.5227 | 104.02 |
| 9 | 4669758 | 32865 | 8 | 359 | 0.5 | 179.5 |
| 10 | 8924035 | 59406 | 5 | 503 | 0.5766 | 290.03 |
| 11 | 6865534 | 45000 | 10 | 416 | 0.9408 | 391.37 |
| 12 | 6014590 | 37435 | 13 | 418 | 0.687 | 287.17 |
| 13 | 8185738 | 50828 | 4 | 347 | 0.49 | 170.03 |
| 14 | 11736136 | 68000 | 13 | 455 | 0.642 | 292.11 |
| 15 | 14837426 | 78868 | 8 | 511 | 0.6351 | 324.54 |
| 16 | 5366490 | 28454 | 13 | 219 | 0.7654 | 167.62 |
| 17 | 13516215 | 70000 | 4 | 501 | 0.6757 | 338.53 |
| 18 | 3884425 | 20000 | 5 | 197 | 0.66 | 130.02 |
| 19 | 10573409 | 50000 | 12 | 318 | 0.615 | 195.57 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
