Question

A regression model relating 2, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where Miotal = 30. 0 ANOVA 0 MSF Significance F SS 6361.5 Regression Residual Total 8844.6 P-value 85.0 5.418 Coefficients Standard Error Stat Intercept 10.553 Number of 43.0 Salespersons a. Write the estimated regression equation (to whole number). y= + b. Compute the F statistic and test the significance of the relationship at a 0.05 level of significance. (to 2 decimals) F-value p-value is - Select your answer - ,we - Select your answer- HO c. Compute the t statistic and test the significance of the relationship at a 0.05 level of significance. (to 2 decimals) t Stat p-value is Select your answer w e - Select your answer. H : d. Predict the annual sales at the Memphis branch office. This branch employs 11 salespersons (to whole number)

Answer 1

Please find the solution

ms of regressionss = 6361.5 -6361.5 ms of regre residual ss = (8844.6-6361.5) = 28 I=88.68 Evalue = 6361.5 - 71.73 88.68 p-value for F = 71-73 and Numerator d. of al and denominator d.of=28, Ip-value á o (from table) sinu than 0.05 p-value is We Reject less Ho (c) t-statistic is given by Coefficients Standard Gisor t-statistic for intercept = 85 - 8.05 To SS3 t-statistic for No. of salesp. = 43 = 17.94 5.418

[t-stat = 7.94 - p-value for t-stat =7.94 and dof=28 p-value = 0 Since p-value is less than 0.05 We reject the null Mo :P,=0 Annual sales at 11 sales persons = 85 t 43*11. 1558
Please find the completed table

	df	SS	MS	F
Regression	1	6361.5	6361.5	71.73372
Residual	28	2483.1	88.68214
Total	29	8844.6
	Coefficents	Standard Error	t -stat	P-value
Intercept	85	10.553	8.054582	0
No. of salespersons	43	5.418	7.936508	0