Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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