Regression: Soft Drink Demand

DATA SET 1 Soft Drink Demand Estimation Demand can be estimated with experimental data, time series data or cross section data. Sara Lee Corporation generates experimental data in test stores where the effect of an NFL-licensed Carolina Panthers logo on Champion sweatshirt sales can be carefully monitored. Demand forecasts usually rely on time series data. In contrast, cross-section data appear in Table 1. Soft drink consumption in cans per year is related to six pack price, income per capita, and mean temperature across the 48 contiguous sates in the United States Question . Estimate the demand for soft drinks using a multiple regression program available on your computer. 2. Interpret the coefficients and calculate the price elasticity of soft drink demand 3. Omit price from the regression equation and observe the bias introduced into the parameter estimate for income. 4. Now omit both price and temperature from the regression equation. Should a marketing plan for soft drinks be de signed that relocates most canned drink machines into low income neighborhoods?Why or Why not? DATA SET 2 The data are the results of the following market research experiment by a large company. The company’s total market area was divided into 40 equally populated market areas, and the price to be charged for the product was set to be the same in each area. Then, the weekly amount of advertising expenditure ($) in each of these market areas was set as indicated in column B. The weekly sales (y units) in each market area was then recorded as shown in column C. 1.Use linear regression to estimate a linear equation describing how the value of sales (y) varies with the level of the fitted equation. 2. Assess the validity of the fitted equation. 3. If the product sells at a price of $100 and costs $70 per unit to produce, estimate a linear equation for the company’s weekly profit in terms of its advertising expenditure (x). DATA SET 3 The Sales of Cycle City, a large motorc ycle and moped distributor, grew significantly during the 1990s. This past history of sales growth is indicated in data set 3. . What is the compound annual rate of growth in sales for Cycle City over this 10 year period? 2. Based on your answer in part (1) what sales would you have forecasted for the next (2001)? 3. Graph the growth in sales over the 10 years. What happened to the rate of growth over this period? 4. Based on your answer to Part (3), what sales would you have forecasted for 2001. DATA SET 4 Pizza firm The manager of pizza firm collects data on the last 24 month of pizza sales from her own company records.Where Q= sales of pizza at Checkers Pizza P = Price of a pizza at Checker Pizza M = Average annual household income in Westbury Pai = price of a pizza at Al’s Pizza Oven Pbmac = price of Big Mac at McDonald’s 1. Estimate the linear demand function for Checkers Pizza compare to nonlinear model 2. Estimate demand elasticities at values of P, M, Pal, and Pbmac at values P=9. 05, M=26614 , Pal = 10. 12 and Pbmac = 1. 15 (for either demand function) 3. Forecast linear trend regression model to forecast income in month 30 DATA Set 5The copper data consist of 25 annual observations on world consumption of copper, copper price and the exogenous variables required to estimate industry demand and supply equation Data presented are actually valued for 1950-1975 Qc= world consumption sales of copper in 1000 of metric tons Pc = price of copper in cents per pound (inflation adjusted) M= index of real per capita income 1970=100 Pa = price of aluminum in cents per pound (inflation adjusted) X= ratio of consumption in the previous year to production in the previous year (=Qc/Qp) T=technology (time period is a proxy) 1.Estimate the copper industry demand and supply equation 2. Locate copper demand and supply in year 26 3. Calculate the intersection of the demand and supply functions DATA Set 6 Given data set 6, the quantity demanded of a commodity (Y) ,it’s price (X1) and consumer income (X2) from 1986-2005 1. Estimate the regression equation of Y on X1 and X2 2. Assess the validity of the fitted equation. 3. What is price elasticity at $4 and income elasticity at level 3800? Explain what kind of commodity (Y) is? 4. Forecast linear trend regression model to forecast income in year 2006 Regression: Soft Drink Demand DATA SET 1 Soft Drink Demand Estimation Demand can be estimated with experimental data, time series data or cross section data. Sara Lee Corporation generates experimental data in test stores where the effect of an NFL-licensed Carolina Panthers logo on Champion sweatshirt sales can be carefully monitored. Demand forecasts usually rely on time series data. In contrast, cross-section data appear in Table 1. Soft drink consumption in cans per year is related to six pack price, income per capita, and mean temperature across the 48 contiguous sates in the United States Question . Estimate the demand for soft drinks using a multiple regression program available on your computer. 2. Interpret the coefficients and calculate the price elasticity of soft drink demand 3. Omit price from the regression equation and observe the bias introduced into the parameter estimate for income. 4. Now omit both price and temperature from the regression equation. Should a marketing plan for soft drinks be de signed that relocates most canned drink machines into low income neighborhoods?Why or Why not? DATA SET 2 The data are the results of the following market research experiment by a large company. The company’s total market area was divided into 40 equally populated market areas, and the price to be charged for the product was set to be the same in each area. Then, the weekly amount of advertising expenditure ($) in each of these market areas was set as indicated in column B. The weekly sales (y units) in each market area was then recorded as shown in column C. 1.Use linear regression to estimate a linear equation describing how the value of sales (y) varies with the level of the fitted equation. 2. Assess the validity of the fitted equation. 3. If the product sells at a price of $100 and costs $70 per unit to produce, estimate a linear equation for the company’s weekly profit in terms of its advertising expenditure (x). DATA SET 3 The Sales of Cycle City, a large motorc ycle and moped distributor, grew significantly during the 1990s. This past history of sales growth is indicated in data set 3. . What is the compound annual rate of growth in sales for Cycle City over this 10 year period? 2. Based on your answer in part (1) what sales would you have forecasted for the next (2001)? 3. Graph the growth in sales over the 10 years. What happened to the rate of growth over this period? 4. Based on your answer to Part (3), what sales would you have forecasted for 2001. DATA SET 4 Pizza firm The manager of pizza firm collects data on the last 24 month of pizza sales from her own company records.Where Q= sales of pizza at Checkers Pizza P = Price of a pizza at Checker Pizza M = Average annual household income in Westbury Pai = price of a pizza at Al’s Pizza Oven Pbmac = price of Big Mac at McDonald’s 1. Estimate the linear demand function for Checkers Pizza compare to nonlinear model 2. Estimate demand elasticities at values of P, M, Pal, and Pbmac at values P=9. 05, M=26614 , Pal = 10. 12 and Pbmac = 1. 15 (for either demand function) 3. Forecast linear trend regression model to forecast income in month 30 DATA Set 5The copper data consist of 25 annual observations on world consumption of copper, copper price and the exogenous variables required to estimate industry demand and supply equation Data presented are actually valued for 1950-1975 Qc= world consumption sales of copper in 1000 of metric tons Pc = price of copper in cents per pound (inflation adjusted) M= index of real per capita income 1970=100 Pa = price of aluminum in cents per pound (inflation adjusted) X= ratio of consumption in the previous year to production in the previous year (=Qc/Qp) T=technology (time period is a proxy) 1.Estimate the copper industry demand and supply equation 2. Locate copper demand and supply in year 26 3. Calculate the intersection of the demand and supply functions DATA Set 6 Given data set 6, the quantity demanded of a commodity (Y) ,it’s price (X1) and consumer income (X2) from 1986-2005 1. Estimate the regression equation of Y on X1 and X2 2. Assess the validity of the fitted equation. 3. What is price elasticity at $4 and income elasticity at level 3800? Explain what kind of commodity (Y) is? 4. Forecast linear trend regression model to forecast income in year 2006