Managing for Quality and Performance Excellence 10th Edition by James Evans ,William Lindsay

Exercise 37

Note: Data sets for many problems in this chapter are available in the Excel workbook C06Data.xlsx on the Student Companion Site. Click on the appropriate worksheet tab as noted in the problem (e.g., Prob. 6-1) to access the data. In addition, the spreadsheet templates illustrated in the chapter are also available to aid in solving many of these problems.
At White Clay Pottery a kiln is used to bake ceramic pottery. The production manager wishes to determine the relationship between temperature and brittleness, so he takes measurements of the brittleness of test items versus the temperature of the oven. (See the data in the Ch06Data Excel workbook.) Use the Excel Regression tool to determine the regression equation and the R 2 value. Explain the output. If the oven is heated to 875°C, what would you predict that the brittleness measure will be?