Develop a regression model to help explain the variation in sales. Explain which
ID: 1119465 • Letter: D
Question
Develop a regression model to help explain the variation in sales. Explain which variables are statistically significant and which are not. Interpret in your own words what the numerical values of the significant coefficients mean.
Predict what sales would be if Price Chomper devotes $50,000 each to advertising in local papers and on TV. Assume that Hannafood is engaged in a medium level of advertising.
Data:
Date Sales Paper TV Compete Apr-13 4250750 75253 114433 2 May-13 3153050 15036 63599 3 Jun-13 4321010 134440 64988 2 Jul-13 3571910 119740 66842 2 Aug-13 3478740 135590 39626 2 Sep-13 4355290 189636 107503 2 Oct-13 2994030 9308 97129 3 Nov-13 2965050 41099 56404 3 Dec-13 4267010 9391 260576 2 Jan-14 3297220 942 243523 1 Feb-14 2817830 1818 75473 2 Mar-14 1663910 672 19037 3 Apr-14 6294040 548704 1000 1 May-14 2634670 52819 78799 3 Jun-14 4686120 2793 175906 2 Jul-14 3132210 27749 49616 3 Aug-14 4444040 21887 119720 2 Sep-14 3869860 1110 114293 2 Oct-14 4143140 436 177370 2 Nov-14 2534930 1407 11345 3 Dec-14 4843650 376650 7020 1 Jan-15 3059890 122906 27880 2 Feb-15 3154070 15138 66800 1 Mar-15 1827840 5532 88576 3 Apr-15 6557480 544807 166178 1 May-15 2704830 43704 134206 1 Jun-15 4294800 5740 137890 1 Jul-15 2604580 9614 37520 1 Aug-15 5282100 1507 145200 2 Sep-15 3798560 13620 108770 2 Oct-15 4720580 101179 90286 2 Nov-15 2545160 80309 24461 2 Dec-15 5513540 335768 7593 2 Jan-16 3358260 91710 37581 1 Feb-16 3204080 9856 73261 2 Mar-16 2769010 107172 40697 3 Apr-16 4551360 299781 8133 2 May-16 2475700 21218 5867 2 Jun-16 7320050 157 1125864 2 Jul-16 3571070 12961 125226 1 Aug-16 4531560 333529 1000 1 Sep-16 3201030 178105 1000 1 Oct-16 4517790 315564 11526 2 Nov-16 2494820 80206 23063 3 Dec-16 7445830 5940 1217488 2 Jan-17 4211860 36819 94139 1 Feb-17 3973670 234562 94139 1 Mar-17 2690960 71881 138134 3Explanation / Answer
Results
Since all the variables are significant . Coeeficient implies
1. paper - if advertising expenditure on paper increases by $1 sales will increase by $5.25.
2. Tv- If advertising expenditure on TV increases by $1 sales will increase by $3.76.
3.Low type advertising increases sales by $623159 more than the high type advertising
4. Medium type advertising increases sales by $951772.3 more than high type sales
Dependent Variable: Sales Variables Coef. Std. Err. t P>t [95% Conf. Interval] paper 5.250503 0.676478 7.76 0 3.886255 6.614751 tv 3.768379 0.395112 9.54 0 2.971561 4.565198 low 623159 253635.2 2.46 0.018 111654.9 1134663 medium 951772.3 223636.6 4.26 0 500766.1 1402779 Constant 2198309 180363.3 12.19 0 1834572 2562047Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.