Question: Project C: Regression and Correlation Analysis Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file.

Project C: Regression and Correlation Analysis

Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following.

Sales (Y)	Calls (X1)	Time (X2)	Years (X3)	Type
51	167	12.6	5	ONLINE
34	133	15.2	4	GROUP
49	161	16.1	3	NONE
45	185	13.3	1	ONLINE
47	176	14.1	2	ONLINE
47	183	12.8	2	ONLINE
38	122	19.3	3	GROUP
44	171	13.6	3	GROUP
47	157	14.3	1	GROUP
37	148	15.7	3	GROUP
51	177	11.4	4	NONE
40	144	17.4	0	NONE
48	136	13.3	2	ONLINE
52	197	14	2	ONLINE
46	145	16.8	0	ONLINE
42	167	17.7	3	ONLINE
37	120	12	2	NONE
42	148	16.9	1	NONE
43	131	18.5	1	NONE
45	120	11.9	2	ONLINE
43	180	18.9	1	NONE
50	169	17.7	1	ONLINE
42	129	20.2	1	ONLINE
37	185	12	0	GROUP
43	150	21.4	3	GROUP
52	146	19.2	4	NONE
38	164	13.4	1	NONE
41	183	17	3	NONE
52	161	19.1	3	GROUP
43	173	19.8	2	ONLINE
47	164	15.3	0	ONLINE
48	177	13.9	3	ONLINE
49	160	13.6	3	GROUP
51	190	11.3	1	ONLINE
42	135	16.1	0	NONE
37	137	18.1	1	ONLINE
51	167	16.2	1	ONLINE
44	169	8.9	0	ONLINE
46	149	17.8	3	NONE
42	153	15.5	2	GROUP
45	140	11	3	GROUP
37	133	19.8	2	NONE
52	173	18.6	0	ONLINE
39	156	13.3	4	NONE
45	130	20.6	3	GROUP
37	130	15.6	1	GROUP
40	125	12.2	4	NONE
44	182	15.5	4	NONE
48	165	19.8	5	ONLINE
42	154	14.8	2	ONLINE
53	178	13.2	2	ONLINE
37	142	18.5	1	NONE
46	153	14.1	1	ONLINE
43	166	17.6	3	ONLINE
45	138	18.9	2	NONE
42	167	18	2	NONE
48	171	13	2	GROUP
39	149	18.8	1	GROUP
46	151	16	1	GROUP
46	162	16.2	2	ONLINE
45	158	13.9	1	ONLINE
44	188	12.9	3	GROUP
49	149	21.1	2	GROUP
41	157	11.5	3	ONLINE
48	156	15.1	4	ONLINE
46	172	12.5	1	ONLINE
48	174	18.6	2	GROUP
47	188	16.3	1	NONE
54	180	11.8	4	GROUP
45	173	17.6	2	ONLINE
53	184	15.2	0	ONLINE
37	148	16.2	1	GROUP
45	155	18.9	2	GROUP
44	159	18.1	2	ONLINE
46	162	12.1	1	GROUP
52	177	14.5	1	ONLINE
54	174	10.8	2	NONE
48	175	13.7	1	ONLINE
44	139	15.2	2	NONE
41	158	19.3	2	ONLINE
43	145	18.6	2	NONE
40	150	10.8	1	GROUP
53	182	10.5	1	ONLINE
47	193	13.5	2	ONLINE
43	148	14.5	4	ONLINE
45	173	17.6	2	ONLINE
53	184	15.2	0	ONLINE
37	148	16.2	1	GROUP
45	155	18.9	2	GROUP
44	159	18.1	2	ONLINE
46	162	12.1	1	GROUP
42	160	10.6	3	NONE
46	148	13.1	1	GROUP
45	177	14.2	2	GROUP
43	153	15.2	3	GROUP
41	153	14.7	1	GROUP
49	152	22.3	0	ONLINE
44	169	13.6	1	ONLINE
49	166	16.2	0	ONLINE
37	145	18	3	NONE

1. Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the "best fit" line. Interpret.

2. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable.

3. Determine the coefficient of correlation. Interpret.

4. Determine the coefficient of determination. Interpret.

5. Test the utility of this regression model. Interpret results, including the p-value.

6. Based on the findings in Steps 1-5, analyze the ability of the independent variableto predict the designated dependent variable.

7. Compute the confidence interval for ₁(the population slope) using a 95% confidence level. Interpret this interval.

8. Using an interval, estimate the average for the dependent variable for a selected value of the independent variable. Interpret this interval.

9. Using an interval, predict the particular value of the dependent variable for a selected value of the independent variable. Interpret this interval.

10. What can be said about the value of the dependent variable for values of the independent variable that are outside the range of the sample values? Explain.

In an attempt to improve the model, use a multiple regression model to predict the dependent variable, Y, based on all of the independent variables, X1, X2, and X3.

11. Using Excel, run the multiple regression analysis using the designated dependent and three independent variables. State the equation for this multiple regression model.

12. Perform the Global Test for Utility (F-Test). Explain the conclusion.

13. Perform the t-test on each independent variable. Explain the conclusions and clearly state how the analysis should proceed. In particular, which independent variables should be kept and which should be discarded. If any independent variables are to be discarded, re-run the multiple regression, including only the significant independent variables, and summarize results with discussion of analysis.

14. Is this multiple regression model better than the linear model generated in parts 1-10? Explain.

*Provide answers in details following those 14 points. And make sure i copy them easily.

*Please an expert

Thank you

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!

48 36 46 47 44 49 35 46 44 39 48 42 45 54 43 44 34 44 40 51 41 45 52 39 41 45 46 47 42 45 44 50 46 53 39 39 48 46 43 44 42 39 49 41 42 39 37 46 45 44 50 39 43 45 42 168 131 162 183 177 181 123 169...

Hello, please see attach and due dates. Please let me know if you're able to do this. Part A: Exploratory Data Analysis Preparation Open the files for the Course Project and the data set. For each of...

do not plaigiarize Preparation Open the files for the Course Project and the data set. For each of the five variables, process, organize, present and summarize the data. Analyze each variable by...

Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following....

Final Project: Regression and Correlation Analysis Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one...

THE DATA IS AT THE END PLEASE ANSWER ALL STEPS 1-11 WITH EXPLANATION AND INCLUDE SCREENSHOTS OF DIAGRAMS AND SCATTERPLOT FROM EXCEL SPREADSHEET. THIS IS A SUMMARY REPORT. Sum of Years (X3) by Type...

Link to Data: https://docs.google.com/spreadsheets/d/1hC7USotAz6f0z9kC4Gn4vddF3oo-NaL5/edit?usp=sharing&ouid=108129733642934907584&rtpof=true&sd=true PLEASE ANSWER ALL STEPS 1-11 WITH EXPLANATION AND...

Link to data: https://docs.google.com/spreadsheets/d/1bOagDhO_6sJtboyb5o2tKZNtHvV94VWPxJhZzKCR28/edit?usp=sharing PLEASE ANSWER ALL STEPS 1-11 WITH EXPLANATION AND INCLUDE EXCEL SPREADSHEET LINK....

Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis. Use Excel to...

Question 3- Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis....

Briefing.com offers Internet-based analyses of investment opportunities to investors. Richard Green is the companys president. One of Briefing coms competitors is Street Account, LLC (limited...

On March 1, the board of directors declared a cash dividend of $0.75 per common share to shareholders of record on March 10, payable March 31. There were 125,000 shares issued and outstanding on...

What is earnings per share? why is earnings per share continuously focused on by the investing community?

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...