Question
7. Find the best multiple linear regression using any four independent variables. Observe Multiple R, R-squared, Significant F, P-values and interpret. Observe the residuals and
7. Find the best multiple linear regression using any four independent variables. Observe Multiple R, R-squared, Significant F, P-values and interpret. Observe the residuals and standard residuals of the model. Assign ratings based on table above.
Representative | Time | MktPoten | AdvExp | MktShare | Change | Accts | WkLoad | Sales |
1 | 43.1 | 74065.11 | 4582.88 | 2.51 | 0.34 | 74.86 | 15.05 | 8107.928 |
2 | 108.13 | 58117.3 | 5539.78 | 5.51 | 0.15 | 107.32 | 19.97 | 4967.749 |
3 | 13.82 | 21118.49 | 2950.38 | 10.91 | -0.72 | 96.75 | 17.34 | 3281.993 |
4 | 186.18 | 68521.27 | 2243.07 | 8.27 | 0.17 | 195.12 | 13.4 | 6686.051 |
5 | 161.79 | 57805.11 | 7747.08 | 9.15 | 0.5 | 180.44 | 17.64 | 8760.123 |
6 | 8.94 | 37806.94 | 402.44 | 5.51 | 0.15 | 104.88 | 16.22 | 5060.801 |
7 | 365.04 | 50935.26 | 3140.62 | 8.54 | 0.55 | 256.1 | 18.8 | 7195.274 |
8 | 220.32 | 35602.08 | 2086.16 | 7.07 | -0.49 | 126.83 | 19.86 | 4815.454 |
9 | 127.64 | 46176.77 | 8846.25 | 12.54 | 1.24 | 203.25 | 17.42 | 9322.814 |
10 | 105.69 | 42053.24 | 5673.11 | 8.85 | 0.31 | 119.51 | 21.41 | 6973.209 |
11 | 57.72 | 36829.71 | 2761.76 | 5.38 | 0.37 | 116.26 | 16.32 | 3529.626 |
12 | 23.58 | 33612.67 | 1991.85 | 5.43 | -0.65 | 142.28 | 14.51 | 3622.633 |
13 | 13.82 | 21412.79 | 1971.52 | 8.48 | 0.64 | 89.43 | 19.35 | 3443.597 |
14 | 13.82 | 20416.87 | 1737.38 | 7.8 | 1.01 | 84.55 | 20.02 | 3342.453 |
15 | 86.99 | 36272 | 10694.2 | 10.34 | 0.11 | 119.51 | 15.26 | 7989.339 |
16 | 165.85 | 23093.26 | 8618.61 | 5.15 | 0.04 | 80.49 | 15.87 | 6762.813 |
17 | 116.26 | 26878.59 | 7747.89 | 6.64 | 0.68 | 136.58 | 7.81 | 4703.842 |
18 | 42.28 | 39571.96 | 4565.81 | 5.45 | 0.66 | 78.86 | 16 | 4005.115 |
19 | 52.84 | 51866.15 | 6022.7 | 6.31 | -0.1 | 136.58 | 17.44 | 4667.806 |
20 | 165.04 | 58749.82 | 3721.1 | 6.35 | -0.03 | 138.21 | 17.98 | 4938.677 |
21 | 10.57 | 23990.82 | 860.97 | 7.37 | -1.63 | 75.61 | 20.99 | 3198.151 |
22 | 13.82 | 25694.86 | 3571.51 | 8.39 | -0.43 | 102.44 | 21.66 | 2911.123 |
23 | 8.13 | 23736.35 | 2845.5 | 5.15 | 0.04 | 76.42 | 21.46 | 2256.54 |
24 | 58.54 | 34314.29 | 5060.11 | 12.88 | 0.22 | 136.58 | 24.78 | 5959.439 |
25 | 21.14 | 22809.53 | 3552 | 9.14 | -0.74 | 88.62 | 24.96 | 4003.957 |
Show a step by step how to input on Excel & what it should look like.
-3.00 and lower Rating of 1
-3.00 to -2.00 Rating of 2
-2.00 to -1.00 Rating of 3
-0.10 to 1.00 Rating of 4
+1.00 to 2.00 Rating of 5
2.00 to 3.00 Rating of 6
3.00 or higher Rating of 7
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