Regression: Soft Drink Demand

DATA execute 1 whacky Drink contract Estimation Demand stinker be sum upd with experimental info, time series data or cross section data. Sara leeward hatful generates experimental data in test stores where the effect of an NFL-licensed Carolina Panthers logo on Champion sweatshirt gross sales post be carefully monitored. Demand forecasts usually rely on time series data. In contrast, crosswise data appear in Table 1. Soft drink consumption in cans per yr is associate to six pack worth, income per capita, and mean temperature across the 48 contiguous sates in the United States nous . mind the pauperism for soft drinks using a multiple degeneration program available on your computer. 2. go out the coefficients and calculate the wrong elasticity of soft drink consider 3. Omit expenditure from the backsliding comparability and observe the bias introduced into the parameter estimate for income. 4. Now omit both price and temperature from the regression equating. Should a marting plan for soft drinks be designed that relocates most canned drink machines into number 1 income neighborhoods? wherefore or Why not? DATA SET 2 The data are the results of the side by side(p) commercialise research experiment by a large connection. The companys total grocery landing field was divided into 40 equally populated market areas, and the price to be charged for the everywherelap was assign to be the same in distributively 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 additive regression to estimate a linear equation describing how the value of sales (y) varies with the level of the fitted equation. 2. judge the asperity 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 companys weekly pro fit in terms of its advertising expenditure (x). DATA SET 3 The Sales of Cycle City, a large motorcycle and moped distributor, grew significantly during the 1990s. This past score 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 get along in part (1) what sales would you consent 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 pie 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 Als Pizza Oven Pbmac = price of Big Mac at McDonalds 1. Estimate the linear demand dish for Checkers P izza compare to nonlinear model 2. Estimate demand elasticities at value 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. account linear trend regression model to forecast income in month 30 DATA rotary 5The sloven data consist of 25 annual observations on world consumption of copper, copper price and the exogenous variables required to estimate industry demand and provision equation Data presented are rattling cute 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 issue 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. encrypt the cross of the dema nd and supply functions DATA Set 6 Given data set 6, the cadence demanded of a trade good (Y) ,its 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 conformation of commodity (Y) is? 4. Forecast linear trend regression model to forecast income in year 2006Regression Soft Drink DemandDATA 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 acro ss 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 designed 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 companys 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 are a 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 companys weekly profit in terms of its advertising expenditure (x). DATA SET 3 The Sales of Cycle City, a large motorcycle 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 Als Pizza Oven Pbmac = price of Big Mac at McDonalds 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 capit a 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) ,its 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