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

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

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 General Management Questions!

OPRE 3360: Managerial Methods in Decision Making Under Uncertainty Graded Group Assignment 2: Hypothesis Testing and Statistical Inference This group assignment is open book and notes. However, once...

I do not want you to solve this problem by using MINITAB. I want you to solve it by using R. Also, you should show me all your work. For example you should show me your output and code step by step....

Hello, I need help answering questions on this excel sheet regarding accounting financial comparisons between Walgreens and CVS. I began to answer requirements 2-6 and need them looked over. I mostly...

Hello, I need help answering these questions based on the attached PDF file. PLEASSSEEEEE!! 1.Summarize the process that Deb Young used to develop a balanced scorecard for GPI. 2. Identify the...

I'm an undergrad accounting student in an introduction to forensic accounting course.I need help getting started on a final project for this class over a fictitious company called the Grand Teton...

Week 1 Lecture 1 Class Approach to Statistics Statistics is basically a set of tools that allow us to get information out of data sets (we will get to the more formal definition below). As such, it...

I hope you can answer this question and find the reference below the question. Thank you Topic: Conducting personal job interviews using the STAR model 1- Design a two-hour training work plan for 10...

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 65.1 27 36.1 61.4 46.6 73.3 39.7 23.2 74.6 22.8 23.4 62 40.7 23 24 51.1...

Table of Contents Main Objective of the assessment 1 Description of the Assessment 1 Learning Outcomes and Marking Criteria. 4 Format of the Assessment 6 Submission Instructions. 7 Avoiding...

solve the equation 4x+4y=2 subject to the initial condition 4(x,0)=x^2.

A particle that hangs from a spring oscillates with an angular frequency w. The spring-particle system is suspended from the ceiling of an elevator car and hangs motionless (relative to the elevator...

As AcclaimAcclaim uses more refined cost pools, the costs of basic trophies decreases, increases, and costs of deluxe trophies decreases. increases. This is because basic deluxe trophies use a higher...

(2) juha Refer to Alfurat Company. What ?is the labor efficiency variance a. $3,780 F O d. $3,825 U 0 b. $3,780 U O c. $3,825F O Refer to Alfurat Company. Assume that the company computes the...