Sales (Y)	Calls (X1)	Time (X2)	Years (X3)	Type
21	116	19.9	3	NONE
21	116	18.0	2	GROUP
31	118	19.4	4	ONLINE
33	125	16.9	2	ONLINE
32	129	18.5	2	GROUP
29	131	14.6	1	GROUP
33	131	10.0	0	GROUP
42	131	19.4	5	GROUP
40	132	18.5	1	GROUP
33	135	15.3	2	GROUP
33	136	16.9	4	ONLINE
41	136	19.3	3	ONLINE
45	137	15.7	1	GROUP
42	139	12.4	1	GROUP
33	140	17.5	2	GROUP
41	140	13.9	3	NONE
42	141	12.2	3	NONE
42	142	17.0	3	ONLINE
35	143	17.7	3	NONE
40	143	18.3	2	NONE
32	146	15.4	3	GROUP
34	146	15.8	1	GROUP
40	146	18.2	2	NONE
43	146	16.4	0	ONLINE
44	146	16.5	1	NONE
45	146	15.6	3	ONLINE
41	147	18.5	3	GROUP
42	147	13.2	3	GROUP
42	148	10.5	2	GROUP
40	149	14.2	4	ONLINE
41	149	13.2	3	GROUP
43	149	12.7	1	GROUP
32	150	19.4	0	GROUP
43	150	17.4	3	GROUP
46	150	20.7	2	GROUP
41	151	18.0	1	NONE
43	151	14.3	1	GROUP
44	151	15.2	2	GROUP
43	152	17.2	1	GROUP
44	152	16.0	2	ONLINE
43	153	13.2	3	GROUP
46	153	22.0	0	ONLINE
40	154	16.4	3	GROUP
41	154	14.5	4	NONE
43	154	15.3	1	ONLINE
43	155	11.2	3	ONLINE
42	156	18.6	2	GROUP
43	156	20.5	2	ONLINE
45	157	16.3	4	ONLINE
46	157	19.3	2	ONLINE
44	158	13.9	1	GROUP
44	158	11.8	3	ONLINE
42	159	13.6	4	GROUP
48	160	15.8	2	ONLINE
46	161	13.2	3	GROUP
46	162	15.7	3	NONE
47	162	16.4	3	ONLINE
43	163	11.7	1	GROUP
45	164	17.2	3	ONLINE
44	165	17.4	3	ONLINE
44	165	15.0	0	ONLINE
44	165	19.2	2	NONE
45	166	19.5	5	NONE
45	167	14.5	4	GROUP
46	167	10.1	0	ONLINE
46	167	14.8	1	ONLINE
46	167	15.8	0	ONLINE
48	168	12.3	5	ONLINE
48	168	15.9	5	ONLINE
46	169	14.8	3	GROUP
48	170	12.1	1	ONLINE
45	171	19.4	2	ONLINE
47	171	17.3	2	ONLINE
45	172	12.6	3	GROUP
50	173	13.3	1	ONLINE
49	174	18.3	0	ONLINE
45	175	18.3	2	GROUP
47	175	13.9	2	GROUP
50	175	15.1	3	ONLINE
51	175	12.0	2	ONLINE
54	175	14.2	1	ONLINE
44	177	15.3	3	ONLINE
48	178	12.6	4	ONLINE
50	179	12.8	3	ONLINE
46	180	15.1	4	NONE
49	181	12.4	2	ONLINE
51	181	11.4	4	GROUP
51	182	17.9	2	ONLINE
47	183	13.0	3	ONLINE
50	183	11.7	1	GROUP
47	185	15.2	2	ONLINE
50	185	16.4	0	ONLINE
46	186	14.1	3	GROUP
49	186	17.5	1	GROUP
53	188	11.0	2	ONLINE
46	189	20.0	1	GROUP
52	190	13.2	3	ONLINE
49	191	13.1	2	GROUP
54	195	15.2	2	ONLINE
51	198	13.0	1	ONLINE

Regression Analysis Results

This section presents a statistical summary of the regression analysis using the following variables:

Dependent variable: SALES (everyone must select this variable) Independent variable: CALLS (everyone must select this variable)

Use the table below to answer the questions in the COURSE PROJECT OVERVIEW. If there is a difference in the way the questions are presented in the table and in the COURSE PROJECT OVERVIEW, please answer the questions as they are presented in the table below.

To get the numbers for this table, use the Week 6 Excel spreadsheet calculator in the shell. To get an understanding of the interpretations, please see the lecture notes and videos.

1. Scatter Plot	Use Excel OR another software package to create a scatter plot. Copy and paste the scatter plot. Make sure the dependent variable is on the Y-axis and the independent variable is on the X-axis. The axis should show the names of the variables.
2. Regression Equation	Put the regression equation here.
3. Coefficient of Correlation	Give the value of the coefficient of coefficient. Explain the type and strength of the correlation.
4. Coefficient of Determination	Give the value of the coefficient of determination. Interpret its value.
5. Results of the Hypothesis Test for Ho: B1 = 0 Ha: B1 0	p-value: put the p-value Result of test: Explain whether you will reject not reject Ho. NOTE: For the hypothesis test use significance level of .05.
6. Interpretation of the result of the hypothesis test above	Is the regression model (regression equation) significant in predicting the dependent variable? Why?
7. 95% confidence interval for B1
8. A. How many sales can we expect (estimate) for a sales person who made 140 calls? B. What is the 99% confidence interval for the number sales estimated above.	Estimated amount sales: Put the predicted value of SALES here. I am requesting everyone to use 140 calls. However, if you already did the assignment and used a different variable, that is ok. Just put your answer here and indicate that you used a different variable. Confidence interval for estimated amount of sales:
9. 99% prediction interval for the number sales estimated above	Prediction interval for estimated sales:
10. Not required	Not required

Identify and describe TWO business decisions that could be made based on the results of this analysis. In other words, how might the business operations change based on these statistical results. Write one paragraph for each decision. Incorporate the results of the your findings from section 2, but do not use technical jargon - use plain business language.