# Question: The file S11 44 xlsx contains data on pork sales Price is

The file S11_44.xlsx contains data on pork sales. Price is in dollars per hundred pounds sold, 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 these data to develop a regression equation that can be used to predict the quantity of pork sold during future periods. Is autocorrelation of residuals 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. Predict the quantity of pork sold during each of the next two quarters.

c. Use Winters’ method to develop a forecast of pork sales during the next two quarters. Does it appear to provide better (or different) predictions than the multiple regression in part a?

a. Use these data to develop a regression equation that can be used to predict the quantity of pork sold during future periods. Is autocorrelation of residuals 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. Predict the quantity of pork sold during each of the next two quarters.

c. Use Winters’ method to develop a forecast of pork sales during the next two quarters. Does it appear to provide better (or different) predictions than the multiple regression in part a?

## Relevant Questions

The file S12_72.xlsx contains data on a motel chain’s revenue and advertising.a. Use these data and multiple regression to make predictions of the motel chain’s revenues during the next four quarters. Assume that ...The file S12_77.xlsx contains monthly time series data on corporate bond yields. These are averages of daily figures, and each is expressed as an annual rate.The variables are:• Yield AAA: average yield on AAA bonds• ...Again continuing problem 2, suppose that you want to force the optimal solution to be integers. Do this in Solver by adding a new constraint. Select the changing cells for the left side of the constraint, and in the middle ...Use Solver Table to run a sensitivity analysis on the cost per assembling labor hour, letting it vary from $5 to $20 in increments of $1. Keep track of the computers produced in row 21, the hours used in the range B26:B28, ...In one modification of the Pigskin problem, the maximum storage constraint and the holding cost are based on the average inventory (not ending inventory) for a given month, where the average inventory is defined as the sum ...Post your question