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 R 2 ) using two independent variables Observe Multiple R, R squared, Significant F, P values and interpret Observe the residuals and standard residuals of the model Use the following guidelines to assign performance rating on scale of 1 7 If the standard residuals is 3 00 and lower Rating of 1 3 00 to 2 00 Rating of 2 2 00 to 1 00 Rating of 3 1 00 to 1 00 Rating of 4 1 00 to 2 00 Rating of 5 2 00 to 3 00 Rating of 6 3 00 and higher Rating of 7 Find the best multiple linear regression using three 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 Find the best multiple linear regression using 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 10 99987 90 4582 88 2 51 0 34 74 86 15 05 12237 62 2 108 13 78458 36 5539 78 5 51 0 15 107 32 19 97 7728 72 3 13 82 28509 96 2950 38 10 91 0 72 96 75 17 34 4848 40 4 186 18 92503 71 2243 07 8 27 0 17 195 12 13 40 9877 12 5 161 79 78036 90 7747 08 9 15 0 50 180 44 17 64 12941 09 6 8 94 51039 37 402 44 5 51 0 15 104 88 16 22 7476 18 7 365 04 68762 60 3140 62 8 54 0 55 256 10 18 80 10629 38 8 220 32 48062 81 2086 16 7 07 0 49 126 83 19 86 7113 74 9 127 64 62338 64 8846 25 12 54 1 24 203 25 17 42 13772 34 10 105 69 56771 87 5673 11 8 85 0 31 119 51 21 41 10301 33 11 57 72 49720 11 2761 76 5 38 0 37 116 26 16 32 5214 22 12 23 58 45377 10 1991 85 5 43 0 65 142 28 14 51 5351 62 13 13 82 28907 27 1971 52 8 48 0 64 89 43 19 35 5087 13 14 13 82 27562 77 1737 38 7 80 1 01 84 55 20 02 4937 72 15 86 99 48967 20 10694 20 10 34 0 11 119 51 15 26 11802 43 16 165 85 31175 90 8618 61 5 15 0 04 80 49 15 87 9990 52 17 116 26 36286 10 7747 89 6 64 0 68 136 58 7 81 6948 86 18 42 28 53422 15 4565 81 5 45 0 66 78 86 16 00 5916 65 19 52 84 70019 30 6022 70 6 31 0 10 136 58 17 44 6895 62 20 165 04 79312 26 3721 10 6 35 0 03 138 21 17 98 7295 77 21 10 57 32387 61 860 97 7 37 1 63 75 61 20 99 4724 54 22 13 82 34688 06 3571 51 8 39 0 43 102 44 21 66 4300 52 23 8 13 32044 07 2845 50 5 15 0 04 76 42 21 46 3333 53 24 58 54 46324 29 5060 11 12 88 0 22 136 58 24 78 9063 72 25 21 14 30792 87 3552 00 9 14 0 74 88 62 24 96 6174 94

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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 26, 2024

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

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 R²) using two independent variables. Observe Multiple R, R-squared, Significant F, P-values and interpret. Observe the residuals and standard residuals of the model. Use the following guidelines to assign performance rating on scale of 1-7. If the standard residuals is:

-3.00 and lower Rating of 1

-3.00 to -2.00 Rating of 2

-2.00 to -1.00 Rating of 3

-1.00 to +1.00 Rating of 4

+1.00 to +2.00 Rating of 5

+2.00 to +3.00 Rating of 6

+3.00 and higher Rating of 7

Find the best multiple linear regression using three 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.

Find the best multiple linear regression using 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.10	99987.90	4582.88	2.51	0.34	74.86	15.05	12237.62
2	108.13	78458.36	5539.78	5.51	0.15	107.32	19.97	7728.72
3	13.82	28509.96	2950.38	10.91	-0.72	96.75	17.34	4848.40
4	186.18	92503.71	2243.07	8.27	0.17	195.12	13.40	9877.12
5	161.79	78036.90	7747.08	9.15	0.50	180.44	17.64	12941.09
6	8.94	51039.37	402.44	5.51	0.15	104.88	16.22	7476.18
7	365.04	68762.60	3140.62	8.54	0.55	256.10	18.80	10629.38
8	220.32	48062.81	2086.16	7.07	-0.49	126.83	19.86	7113.74
9	127.64	62338.64	8846.25	12.54	1.24	203.25	17.42	13772.34
10	105.69	56771.87	5673.11	8.85	0.31	119.51	21.41	10301.33
11	57.72	49720.11	2761.76	5.38	0.37	116.26	16.32	5214.22
12	23.58	45377.10	1991.85	5.43	-0.65	142.28	14.51	5351.62
13	13.82	28907.27	1971.52	8.48	0.64	89.43	19.35	5087.13
14	13.82	27562.77	1737.38	7.80	1.01	84.55	20.02	4937.72
15	86.99	48967.20	10694.20	10.34	0.11	119.51	15.26	11802.43
16	165.85	31175.90	8618.61	5.15	0.04	80.49	15.87	9990.52
17	116.26	36286.10	7747.89	6.64	0.68	136.58	7.81	6948.86
18	42.28	53422.15	4565.81	5.45	0.66	78.86	16.00	5916.65
19	52.84	70019.30	6022.70	6.31	-0.10	136.58	17.44	6895.62
20	165.04	79312.26	3721.10	6.35	-0.03	138.21	17.98	7295.77
21	10.57	32387.61	860.97	7.37	-1.63	75.61	20.99	4724.54
22	13.82	34688.06	3571.51	8.39	-0.43	102.44	21.66	4300.52
23	8.13	32044.07	2845.50	5.15	0.04	76.42	21.46	3333.53
24	58.54	46324.29	5060.11	12.88	0.22	136.58	24.78	9063.72
25	21.14	30792.87	3552.00	9.14	-0.74	88.62	24.96	6174.94