W. H 2.517 Review Final Dec14 - Microsoft Word (Coon akinBaunu npoly Danin MaBHag BCTABKa Pa3MeTKa CTpaHNLbI Ccbinky Pacchinky PeleHENpoBaHue BuA Acrobat d Bbipesatb Calibri (OCHO + 11 A A Aa 24 Aa56BBfr, Aa56BBfr, Aab6B KonupoBaTb BCTaBUTb DopMaT no obpasuy X K Y abe x x AA 1 06blyHbin 1 6e3 NHTep... 3aronoBOK bypep 06MeHa WpuQT 63all Exercise 7 The marketing manager of a large super market chain would like to determine the effect of shelf space on the sales of pet food. A random sample of 12 equal sized stores is selected with the following results Store Shelf space, X (Feet) Weekly Sales, Y (Hundreds of $) 1 5 1,6 2 5 2,2 3 5 1,4 4 10 1,9 5 10 2,4 6 10 2,6 7 15 2,3 8 15 2,7 9 15 2 , 8 10 20 2,6 11 20 2,9 12 20 3,1 (a) Set up scatter diagram (b) assuming linear relationship, run regression in Excel and to find the regression coefficients bo and b1 (c) Interpret the meaning of the slope bj in this problem (d) predict the average weekly sales (in hundreds of dollars) of pet food for stores with 8 feet of shell space for pet food. (e) Suppose that sales in store 12 are 2,6. Do parts (a)-(d) with this value and compare the results. f) What shelf space would you recommend that the marketing manager allocate to pet food? explain. Exercise 8 4ncno COB: 614 aHrnunckun (CLA) -6 . C D Cloudy nouck VACO ASUS ZenBook SC F2 F3 O F 4 F5 F6 F8