39. The file P11_39.xlsx contains quarterly data on pork sales. Price is in dollars per hundred pounds, quantity sold is in billions of pounds, per capita income is in dollars, U.S. population is in millions, and GDP is in billions of dollars.
a. Use the data to develop a regression equation that could be used to predict the quantity of pork sold during future periods. Discuss how you can tell whether heteroscedasticity, autocorrelation, or multicollinearity might be a problem.
b. Suppose that during each of the next two quarters, price is 45, U.S. population is 240, GDP is 2620,
and per capita income is 10,000. (These are in the units described previously.) Predict the quantity of
pork sold during each of the next two quarters.
"regression equation:
Pork Sales = 146.9846 + 0.18067*quarter - 0.3356*pork price - 0.00384*income - 0.4944*popn + 0.2164*GDP
"
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.
Login | Sign Up
