Problems


You can find the data for the following problems in the file Chapter50data.xlsx.

  1. For patients of four cardiologists, we are given the number of days the patients stayed in the hospital after open-heart surgery.

    • Is there evidence that the doctors have different discharge policies?

    • You are 95 percent sure that a patient of Doctor 1 will stay in the hospital between what range of days?

  1. A drug can be produced by using a 400-degree, 300-degree, or 200-degree oven. You are given the pounds of the drug yielded when various batches are baked at different temperatures.

    • Does temperature appear to influence the process yield?

    • What is the range of pounds of the product that you are 95 percent sure will be produced with a 200-degree oven?

    • If you believe that pressure within the container also influences process yield, does this analysis remain valid?




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net