Question

The U.S. Commodities Futures Trading Commission reports on the volume of trading in the U.S. commodity futures exchanges. Shown here are the figures for grain, oilseeds, and livestock products over a period of several years. Use these data to develop a multiple regression model to predict grain futures volume of trading from oilseeds volume and livestock products volume. All figures are given in units of millions. Grain Oilseeds Livestock 2.2 3.7 3.4 18.3 15.7 11.8 19.8 20.3 9.8 14.9 15.8 11.0 17.8 19.8 11.1 15.9 23.5 8.4 10.7 14.9 7.9 10.3 13.8 8.6 10.9 14.2 8.8 15.9 22.5 9.6 15.9 21.1 8.2 Appendix A Statistical Tables (Round your answers to 3 decimal places.) The regression model: Grain = + Oilseeds + Livestock.

The U.S. Commodities Futures Trading Commission reports on the volume of trading in the U.S. commodity futures exchanges. Shown here are the figures for grain, oilseeds, and livestock products over a period of several years. Use these data to develop a multiple regression model to predict grain futures volume of trading from oilseeds volume and livestock products volume. All figures are given in units of millions.

Grain	Oilseeds	Livestock
2.2	3.7	3.4
18.3	15.7	11.8
19.8	20.3	9.8
14.9	15.8	11.0
17.8	19.8	11.1
15.9	23.5	8.4
10.7	14.9	7.9
10.3	13.8	8.6
10.9	14.2	8.8
15.9	22.5	9.6
15.9	21.1	8.2

Answer 1

The regression model:

Grain = -4.675 + 0.473*Oilseeds + 1.180*Livestock.

	R²	0.901
	Adjusted R²	0.877
	R	0.949
	Std. Error	1.761
	n	11
	k	2
	Dep. Var.	Grain
ANOVA table
Source	SS	df	MS	F	p-value
Regression	226.6568	2	113.3284	36.55	.0001
Residual	24.8050	8	3.1006
Total	251.4618	10
Regression output				confidence interval
variables	coefficients	std. error	t (df=8)	p-value	95% lower	95% upper
Intercept	-4.675
Oilseeds	0.473	0.1266	3.738	.0057	0.1813	0.7650
Livestock	1.180	0.3122	3.780	.0054	0.4601	1.8999