Regresion Help

You have been retained by a regional food marketer, FoodKing , to forecast the demand for small cakes that are mass -produced and marketed under the name Big Suzy’s Snack Cakes . To assist with your analysis, you are provided with data that was collected for 8 consecutive quarters and 6 geographic markets. (Note: THE DATA IS CONTAINED IN THE EXCEL FILE LABELED “BIG SUZY.XLSX”). EITHER CIRCLE or BOLD all Final Answers. Estima te a regression model that expresses sales as a function of price, income, competitor’s price and population . Having done that, you are asked to address the following questions. (a) Estimate a regression model that expresses sales as a function of pric e, income and competitor’s price and population? Once you have estimates the regression model , (a) provide a clear interpretation of the “R 2” and (b) the statistical significant of the overall regression . Be sure to explain if the overall regression is sta tistically significant at a 5% level and how you know that. ANSWER QUESTION BELOW. (b) Can you provide a clear, concise interpretation for the slope coefficient on price ? Is that coefficient significantly different from zero at the 5% level ? How do you know that? ANSWER QUESTION BELOW. (c) FoodKing is considering entering a new market. In this market, the population is 2,750,000, the average (or per capita) income is $46,500 and the competitor’s product sells for $4.75. Using this regression model, if you price your product at $5.50, how many pies w ill you sell ? BE VERY CAREFUL WITH THE UNITS OF MEAUREMENT – FOR EXAMPLE: NOTE THAT THE PRICES IN THE DATA SET ARE MEASURED IN CENTS. SHOW YOUR WORK. (hint: just plug the numbers into the regression estimated above – be careful with units) At $5.50, w e will sell ______________ pies. (d) One of your assistants notes that the market that you are considering entering is located in the southern part of the nation. She asserts that “everyone knows that southerners eat lots of snack cakes.” You note that in your data set, Atlanta and Dallas are the only two cities that are in the “South” census district. Can you test you assistant’s hypothesis that “southerners eat lots of snack cakes”? If so, is she correct? If so, how many mo re snake cakes do Southerners eat than their comparable non -southerners ? SHOW YOUR WORK . (hint: use a dummy variable) Do Southerners eat more stack cakes than non -Southerners? YES or NO (circle one) If “Yes”, how many more? They eat _________________ more cakes. (e) Ignore the issue about Southerners in (d). Instead, one of your assistants suggests that there is a significant seasonal effect on the consumption of snack cakes. Specifically, he suggests that “people each more snack cakes during that holiday season (Oct ober through December)”. Can you test you assistant’s hypothesis? If so, is she correct? If so, how many more snack cakes do they eat doing the holiday season? SHOW YOUR WORK. (hint: use a dummy variable) Do we sell more stack cakes during the ho liday season? YES or NO (circle one) If “Yes”, how many more? They eat _________________ more cakes.