Question

(chapter.9 lab) ANSWERS MUST BE SUBMITTED THROUGH EXCEL. PLEASE SCREENSHOT ANSWERS/WORK THROUGH EXCEL work will not be counted for if answer isnt given through excel!! please do not answer if your not going to send screenshot through excel!! THANK YOU SO MUCH!! Do Problem 9-44 on page 312 of the textbook- Chapter 9, problem 44, and answer the corresponding questions in Connect 2 Do Problem 9-56 on page 313 of the textbook-Chapter 9, problem 56, and answer the corresponding questions in Connect Please note that these assignments must be answered in Connect and done on Excel. Not only must the assignment be submitted as an Excel file, but students are expected to actually solve the problems using Excel. The use of Excel is clearly explained in the PowerPoint slides and in the text, and there are multiple examples of excel solutions posted for each chapter All work must be supported with and Excel file· lf the Excel file is not provided, the student will receive zero credit. 44. FILE PrintTech, Inc. is introducing a new line of ink-jet printers and would like to promote the number of pages a user can expect from a print cartridge. A sample of 10 cartridges revealed the following number of pages printed 2,698 2,028 2.474 2,395 2,372 2475 1927 3,006 2,334 2,379 a. What is the point estimate of the population mean? b. Develop a 95% confidence interv al for the population mean. 56) 56. Families USA, a monthly magazine that discusses issues related to health and health costs, surveyed 20 of its subscribers. It found that the annual health insurance premiums for a family with coverage through an employer averaged $10,979. The standard deviation of the sample was $1,000. a. Based on this sample information, develop a 90% confidence interval for the population mean yearly premium. b. How large a sample is needed to find the population mean within $250 at 99% confidence? PLEASE USE EXCEL!!! SCREENSHOT ANSWER AND WORK hank you!

Answer 1

44)