How accurate is the regression equation in predicting sales

Assignment Help Econometrics
Reference no: EM13205538

A food-products company has recently introduced a new line of fruit pies in six U.S. cities: Atlanta, Baltimore, Chicago, Denver, St. Louis, and Fort Lauderdale. Based on the pie's apparent success, the company is considering a nationwide launch. Before doing so, it has decided to use data collected during a two-year market test to guide it in setting prices and forecasting future demand.

For each of the six markets, the firm has collected eight quarters of data for a total of 48 observations. Each observation consists of data on quantity demanded (number of pies purchased per week), price per pie, competitors' average price per pie, income, and population. The company has also included a time-trend variable for each observation. A value of 1 denotes the first quarter observation, 2 the second quarter, and so on, up to 8 for the eighth and last quarter.


A company forecaster has run a regression on the data, obtaining
the results displayed in the table.

Coefficient Standard Error of Coefficent Mean of ValueVariable

Intercept -4,516.3 4,988.2 ------

Price (dollars) -3,690.6 702.8 7.50

Competitor's
price (dollars) 4226.5 851.0 6.50

Income ($000) 777.1 66.4 40

Population(000) .40 .31 2,300

Time (1 to 8) 356.1 92.3 -----

N = 48. R2=.93. Standard error of regression = 1,442

a. Which of the explanatory variables in the regression are statistically significant? Explain. How much of the total variation in pie sales does the regression model explain? -

b. Compute the price elasticity of demand for pies at the firm's mean price: ($7.50) and mean weekly sales quantity (20,000 pies). Next, compute the cross-price elasticity of demand. Comment on these estimates.

c. Other things equal, how much do we expect sales to grow (or fall over the next year?

d. How accurate is the regression equation in predicting sales next quarter? Two years from now? Why might these answers differ?

e. How confident are you about applying these test-market results to decisions concerning national pricing strategies for pies?

Reference no: EM13205538

Questions Cloud

Where does the normal line to the ellipse : Where does the normal line to the ellipse X^2-xy+y^2=3 at the point (-1,1) intercept the ellipse a second time?
What is the maximum area : a carpenter is building a rectangular room with a fixed perimeter of 328 ft. what dimensions would yield the maximum area? what is the maximum area?
What root property is essential to solve radical equation : What root property is essential to solve any radical equation involving square root? Use examples to help explain.
Explain sodium tripolyphosphate and water : phosphate combines with sodium hydrogen phosphate to yield sodium tripolyphosphate and water
How accurate is the regression equation in predicting sales : A food-products company has recently introduced a new line of fruit pies in six U.S. cities: Atlanta, Baltimore, Chicago, Denver, St. Louis, and Fort Lauderdale. Based on the pie's apparent success, the company is considering a nationwide launch.
Define metals react with most acids to produce gas : According to the activity series, which of these metals will react with most acids to produce H2 gas?
Advantages and disadvantages of mergers and acquisitions : What are the advantages and disadvantages of mergers and acquisitions to the economy and what are some ways the government is involved in them, and should the government be more or less involved?
Define the racemic mixture : Why does a pure enantiomer have a lower melting point range than the racemic mixture?
Computation to prove that dilution of acid : which portion of the titration curve are you in to reach pH = 7? Show your calculations to prove that dilution of 10,000 gal aniline requires 0.58 gal of this acid.

Reviews

Write a Review

Econometrics Questions & Answers

  Determine the outlook of fictitious economy

According to the following economic indicators, estimate the outlook of this fictitious economy. Although I know what these indicators mean,

  Find the covariance between x and y

find the covariance between hourly wage X and education Y (measured in years of schooling) using the following summary statistics for a sample of 10 workers in a plant. xbar = 11.775 ybar=13.8 sum of (x-xbar)(y-ybar) = 103.55 sum of xy =1728.5

  What would you expect to earn after your raise

Suppose you are currently earning $15 an hour. If the inflation rate over the current year is 10 percent and your firm provides a cost-of-living raise based on the rate of inflation, what would you expect to earn after your raise? If the cost-of..

  Estimate the selling price per pound of product

A large chemical plant is being planned with the capacity to produce 3 million pounds (lb.) of product annually. Raw-materials costs for the product are $0.45/lb. and utility costs are $0.25/lb. Overhead costs are 75 percent of the labor costs.

  Explain how to arrive at that conclusion

the formula for AFC, AVC, ATC, MC, TR, MR The market price faced by this firm is $6.00 per widget. a. Fill in the formula for AFC, AVC, ATC, MC, TR, MR, and Total Profit b. Fill in the missing values for TFC, TVC, AFC, AVC, ATC, MC, TR, MR,

  Calculate total revenue before and after the price change

Using the midpoint method, calculate and interpret the price elasticity of demand for the following situation a. When the price of oranges increases from $1.00 per pound to $1.50 per pound, quantity demanded falls from 500 pounds to 400 pounds. Cal..

  Determine how much labor is needed

Suppose the following equations are true: Production Function: Q = K1/3L2/3, which means MPK = 1/3K-2/3L2/3,MPL = 2/3K1/3L-1/3 MRTS = 2(K/L) Total Cost = rK + wL r = .2 w = $5

  What is the new equilibrium price level

Suppose that the aggregate demand and aggregate supply schedules for a hypothetical economy are as shown at the top left of the next page. a. Use the data above to graph the aggregate demand and aggregate supply curves. What is the equilibrium pri..

  What range of payments will the farmer accept

What are the highest and lowest payments from the writer that the bookkeeper farmer team will accept for the 6th day Assume that the farmer can dispose of $7 from the writer as she wishes, what range of payments will the beekeeper accept

  What wage would the firm pay if the candidate was found

The firm prefers to have type M in job D type U in job E. In the best outside option, the candidate is paid $80,000 a year. The monetary value of disutility in the job D is $15,000 for type M and $30,000 for type U.

  What state of business cycles

How do you relate the most recent unemployment rate (Look for Jan, 2012 data on unemployment rate) to your conclusion of this question indicating if the US economy is in a state of full employment. Feb 2012 unemployment data will be announced on M..

  Determine the optimal two-part pricing strategy

You are the manager of a monopoly. A typical consumer's inverse demand function for your firm's product is P = 250 - 40Q, and your cost function is C(Q) = 10Q. a. Determine the optimal two-part pricing strategy. Per-unit fee: $ Fixed fee: $

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd