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

The Answer is in the image, click to view ...

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Hello; I need help answering these questions step by step in excel and interpreting the data using three and four variables. Thank you in advance :) Find the best multiple linear regression (based on...

The Fresh Detergent Case Enterprise Industries produces Fresh, a brand of liquid detergent. In order to more effectively manage its inventory, the company would like to better predict demand for...

Create charts to better understand data sets. For cross-sectional data, use a scatter chart. For time series data, use a line chart. Linear y = a + bx Logarithmic y = ln(x) Polynomial (2nd order) y =...

s Make sure to use the de-seasonalized demand data for this model and all future models. 11-Repeat part (10) with DIFF as the independent variable. 12-Construct multiple linear regression model with...

As usual, let's do some exploratory data analysis using the concepts taught over the first three weeks! Firstly, let us examine the first few rows of the dataset just to have a look: [47]: #Examine...

Sales manager of a company wishes to evaluate the performance of the companys sales representatives. Each sales rep. is solely responsible for one sales territory, and the manager decides that it is...

Help with question 8 please Important Notice: All team members must work on all parts and compare results for accuracy. Only one team member will upload an Excel file of analysis. Sales manager of a...

Budgeting for Nonprofit Organizations Although budgeting is just as important for nonprofit organizations as for for-profit companies, the approach taken toward budgeting can be very different. In...

11-Repeat part (10) with DIFF as the independent variable. 12-Construct multiple linear regression model with Period, AIP, DIFF, and ADV as independent variables. Formulate the equation, find MAD,...

Based on the below, identify on the "Ledger Accounts" and "Trial Balance" HIGHLIGHTED YELLOW information which identified to be inaccurate? correct the inaccurate figures The following events...

The Sterling Tire Company's income statement for 20XX is as follows: STERLING TIRE COMPANY Income Statement Year ended December 31, 20XX Sales (35,000 tires at $50 each) Less: Variable costs (35,000...

0 1 2 3 4 | | | | - 5 0 0 0 1 5 0 0 0 1 2 5 0 0 0 1 7 5 0 2 5 0 0 0 2 0 % discount rate NET preset value

is based on the assumption that the future will be an extrapolation of the past. Group of answer choices The Cooke method The Delphi method Judgmental forecasting Statistical forecasting

4. What is meant by the statement: We are extremely limited in our willingness to allow others to put their own case in a social situation?.

8. Give three examples of how the level of confidence one has in someone can affect a communication situation.

7. List examples from a communication situation with a foreign person in which you have used the sauna manoeuvre (described in this chapter), and examples where you have been subjected to the...