Question

4.

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

12. What is the standard error of estimate? (3 points)

Answer 1

the regression equation is Sales(y)=17.175+1.127*Clients(x)

and standard error of estimate is 5.650

following data has been used to generate the regression analysis information ,as variables in the data not separated properly please check and respond if any problem

Broker	Clients(x)	Sales(y)
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

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.647	58.30946	1.77E-05
Residual	10	319.2700705	31.92701
Total	11	2180.916667
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	17.17500569	4.283122765	4.009926	0.002478	7.631613	26.7184
Clients	1.127018422	0.147591552	7.636063	1.77E-05	0.798164	1.455873