## Question

###### Local in the business of making bakery products wants to know whether there is any 2A company their products and the sale of those same products relabiounship between the aount spent on adverusing collects information on 6 of the sales conducted in - the (usc & 05) To answer this question thc managet but close enough perhaps) Sales and advertising past thrce years (not exactly = random sarple of sales Values are in SIOOOs: (Ads: advertising expenditures; Sale$ sales during week of sale)Sale

local in the business of making bakery products wants to know whether there is any 2A company their products and the sale of those same products relabiounship between the aount spent on adverusing collects information on 6 of the sales conducted in - the (usc & 05) To answer this question thc managet but close enough perhaps) Sales and advertising past thrce years (not exactly = random sarple of sales Values are in SIOOOs: (Ads: advertising expenditures; Sale$ sales during week of sale) Sale 1 2 34 5 6 Ads X2 14 3 3 2 Sales$ Y 40 65 45 60 30 40 (a) Use & 0S and statistical test ofr (you can tun Excel regression analysis to get correlation t) to test the significance of the relationship. That is I5 this relationship (correlation) between advertising expenditures and sales statistically significant? If there is relationship: describe it in YOur own words Do test calculations by hand. Statistical Test ofr Hyps; HO HL: | 2. Test & Analysis: 3. Conclusion: (b) Use & =.05 and statistical test of slope b (you can use Excel regression output to get slope bl and SSE) to test the significance of the slope of the regression line. That Is_ can We use advertising expenditures to predict sales statistically? (Please calculate below Values by hand s0 that you can build your test statistic). Test of Slope 6 Hyps; HO HI: 2 , Test & Analysis Conclusion