AutoSave OFF @ E. Chapters 8-9 Homework Summer 2021 Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me Share Comments X NIT Calibri (Body) v 11 - A V = = ab Wrap Text General IIX F AYO WE Paste BIU a Av A Merge & Center & $ %) Insert 3 .00 000 Delete Format V Conditional Format Cell Formatting as Table Styles v Sort & Filter Find & Select Analyze Data G25 2 x fx v B D E F G G H 1 K L M N O P Q R s T U v w 2. The manager of PetSmart was studying the characteristics of her customers. She surveyed 100 customers and found that: The amount spent was X = $25,5 = $ 7 . 45 customers have more than one dog. A) Construct a 95% confidence interval estimate for the population mean amount spent. B) Construct a 95% confidence interval estimate for the population proportion of customers who have more than one dog The branch manager of a different PetSmart wishes to conduct a similar study of his store. The manager does not have access to the information generated by the manager of the other PetSmart. Answer the following questions: C) What sample size is needed to have 95% confidence of estimating the population mean amount spent in this store within +/- $2.00, if the standard C deviation is estimated to be $10? 1 2 8.61 3 Part A. 4 4 Confidence interval Lower Bound 5 Confidence Interval Upper Bound 6 Part B. 7 Confidence Interval Lower Bound 8 Confidence interval Upper Bound 9 Part C. 10 Sample Size 11 Part D. 12 Number of Customers 13 14 15 16 17 18 19 20 21 22 23 24 D) How many customers need to be selected to have 90% confidence of estimating the population proportion of customers who have more than one dog to within +/.05? . 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Read First! Answer Sheet. 8.1 8.2 8.3 9.1 9.2 9.3 CIE Mean Sigma Known CIE Sigma Unknown CIE Prop n mean n prop Ztest + Ready + 100%