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

The data for the following problems is in the file Ch51.xlsx.

1. We believe that pressure (high, medium, or low) and temperature (high, medium, or low) influence the yield of a production process. Given this theory, determine the answers to the following problems:

   • Use the data in the Problem 1 worksheet to determine how temperature and/or pressure influence the yield of the process.

   • With high pressure and low temperature, we’re 95 percent sure that process yield will be in what range?

2. We are trying to determine how the particular sales representative and the number of sales calls (either one, three, or five) made to a doctor influence the amount (in thousands of dollars) that each doctor prescribes of our drug. Use the data in the Problem 2 worksheet to determine the answers to the following problems:

   • How does the representative and number of sales calls influence our sales volume.

   • If Rep 3 makes five sales calls to a doctor, we’re 95 percent sure she will generate prescriptions within what range of dollars?

3. Answer the questions in Problem 2 by using the data in the Problem 3 worksheet.

4. The file Coupondata.xlsx contains information on sales of peanut butter for weeks when a coupon was given out (or not) and advertising was done (or not) in the Sunday paper. Describe how the coupon and advertising influence peanut butter sales.