MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

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?

Related

Категории