Question: There is only three independent variables in your Excel Data, but the model you are testing has 5 independent variables. Accordingly, it is YOU that
There is only three independent variables in your Excel Data, but the model you are testing has 5 independent variables. Accordingly, it is YOU that has to create those two additional columns. Variable X4 is the Cube (Third power) of X1;:: X5 is the Square root of the MEAN of X2 and x3.
After creating those two additional columns, you run a Multiple Regression model, including the residuals and residual plots and Normal probability plot and also do additional Excel operations needed to answer the questions in the Word file (That is, items such as the Histogram of the residuals and Durbin-Watson Test Statistic, Correlation Matrix of the Independent variables, and Histogram of residuals). You then save this Excel file to be submitted as the Excel File part of the Excel Project. The Word File part will serve as your Final Exam and will count twice and will not be dropped. Excel file will not be dropped either, but counts only once.
| y | 109000 | 155000 | 86060 | 120000 | 153000 | 170000 | 90000 | 122900 | 325000 | 120000 | 85860 | 97000 | 127000 | 89900 | 155000 | 253750 | 60000 | 87500 | 112000 | 104900 | 148635 | 150000 | 90400 | 248800 | 135000 | 145000 | 457000 | 140000 | 130000 | 187000 | 229000 | 227000 | 179900 | 169900 | 209900 | 169900 | 293000 | 24590 | 157000 | 195000 | 150000 | 234900 | 279550 | 246500 | 124000 | 138000 | 290000 | 108000 | 134900 | 64500 | 142000 | 125000 | 88000 | 135000 | 90000 | 90100 | 126900 | 175000 | 158000 | 92000 | 82800 | 140000 | 171000 | 200640 | 139000 | 225000 | 182000 | 208767 | 186000 | 93000 | 257386 | 161000 | 92000 |
| x1 | 0.19 | 0.41 | 0.11 | 0.68 | 0.4 | 1.21 | 0.83 | 1.94 | 2.29 | 0.92 | 8.97 | 0.11 | 0.14 | 2 | 0.13 | 2 | 0.21 | 0.88 | 1 | 0.43 | 0.32 | 0.03 | 0.36 | 4 | 1.83 | 3 | 0.43 | 0.44 | 1.24 | 0.46 | 0.87 | 1.8 | 0.46 | 0.91 | 0.46 | 0.59 | 7.24 | 0.19 | 0.46 | 0.41 | 0.78 | 0.89 | 1.34 | 1 | 1 | 0.27 | 0.71 | 0.9 | 0.24 | 0.06 | 0.55 | 0.34 | 0.19 | 0.23 | 0.07 | 0.09 | 0.25 | 0.47 | 0.36 | 0.07 | 0.11 | 0.23 | 3.16 | 0.08 | 0.57 | 0.5 | 1 | 0.5 | 0.55 | 0.1 | 0.5 | 0.31 | 0.28 |
| x2 | 133 | 13 | 20 | 31 | 33 | 23 | 36 | 4 | 123 | 1 | 13 | 153 | 9 | 88 | 9 | 7 | 82 | 17 | 12 | 21 | 1 | 24 | 16 | 28 | 126 | 26 | 53 | 56 | 51 | 3 | 9 | 201 | 1 | 19 | 1 | 10 | 43 | 2 | 45 | 32 | 54 | 9 | 60 | 70 | 98 | 54 | 73 | 48 | 10 | 16 | 20 | 32 | 15 | 135 | 14 | 15 | 10 | 15 | 10 | 14 | 225 | 25 | 15 | 4 | 30 | 12 | 16 | 8 | 17 | 14 | 90 | 10 | 18 |
| x3 | 7300 | 18700 | 15000 | 14000 | 23300 | 14600 | 22200 | 21200 | 12600 | 22300 | 4800 | 3100 | 300 | 2500 | 300 | 49800 | 8500 | 19400 | 8600 | 5600 | 6200 | 5100 | 5200 | 5500 | 6000 | 4500 | 2700 | 19400 | 24800 | 15200 | 41100 | 25500 | 15200 | 20200 | 15200 | 17300 | 36600 | 20700 | 20200 | 27100 | 24500 | 41600 | 44400 | 17100 | 15500 | 8900 | 61000 | 19000 | 8000 | 1600 | 13800 | 11100 | 3400 | 8100 | 1800 | 2400 | 8400 | 27200 | 12100 | 1800 | 3900 | 8300 | 24100 | 32000 | 7500 | 15300 | 26600 | 32000 | 4400 | 2600 | 32000 | 10400 | 6300 |
| x4 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| x5 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
