Question

The managers of a brokerage firm are interested in finding out if the number of new clients a broker brings into the firm affects the sales generated by the broker. They sample 12 brokers and determine the number of new clients they have enrolled in the last year and their sales amounts in thousands of dollars. These data are presented in the table that follows.

Broker​Clients​Sales

​1​48​72

​2​11​37

​3​42​64

​4​33​55

​5​15​29

​6​15​34

​7​25​58

​8​36​59

​9​28​44

​10​30​48

​11​17​31

​12​22​38

Please use Excel to conduct the Simple Linear Regression Analysis on the data set above and show the summary output. Please attach the output. (3 points)

Please use the regression analysis results you get from the information above to answer the following questions. Confidence level is 95%.

7. What is the total variation of “Sales”? (3 points)

Answer 1

x	y
48	72
11	37
42	64
33	55
15	29
15	34
25	58
36	59
28	44
30	48
17	31
22	38

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.923908759
R Square	0.853607396
Adjusted R Square	0.838968135
Standard Error	5.65039884
Observations	12
ANOVA
	df	SS	MS	F	Significance F
Regression	1	1861.646596	1861.646596	58.30946174	1.76618E-05
Residual	10	319.2700705	31.92700705
Total	11	2180.916667
	Coefficients	Standard Error	t Stat	P-value	Lower 95%
Intercept	17.17500569	4.283122765	4.009926081	0.002478349	7.631613445
x	1.127018422	0.147591552	7.636063236	1.76618E-05	0.798163951

7)

SST = 2180.9167

Please rate