Solutions Statistics

A mail order business uses the weight of mail to predict the number of orders received. The results

Question: A mail order business uses the weight of mail to predict the number of orders received. The results of the simple linear regression analysis from Excel are given below.

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.932698
R Square	0.869925
Adjusted R Square	0.856918
Standard Error	0.839872
Observations	12

ANOVA
	df	SS	MS	F	Significance F
Regression	1	47.17532	47.17532	66.8788	9.71E-06
Residual	10	7.053852	0.705385
Total	11	54.22917

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	0.88991	1.073448	0.82902	0.426438	-1.50188	3.281701	-1.50188	3.281701
Weight	0.027048	0.003307	8.177946	9.71E-06	0.019679	0.034418	0.019679	0.034418