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
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