Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Single Variable

Authors: Howard Anton, Irl C Bivens, Stephen Davis

11th Edition

1118885686, 9781118885680

More Books

Students also viewed these Mathematics questions