Grindwell, Inc., a manufacturer of abrasive tools, is concerned with the durability of its products, which depends on the permeability of the mixtures used in production. Suspecting that the carbon content might be the source of the problem, the plant manager collected the following data.

to. Using spreadsheet software (eg, MS Excel), draw a scatterplot for these data.

b. Using spreadsheet software (eg, MS Excel) or statistical software of your choice, perform a regression analysis to assess the strength of the relationship between permeability and carbon content. What conclusions can you draw? Explain your answer.

Carbon content (%)	permeability index
5.5	18
4	23
3.5	27
5	21
4.6	18
4.4	21
4.2	22
4.2	19
5.4	22
4.4	20
4.8	19
5.6	23
4.2	18
3.8	26
4.5	25

Answer rating: 100% (QA)

Step 1 Data Entry Enter the provided data into two columns in an Excel spreadsheet one for Carbon content and the other for Permeability index Step 2 ... View the full answer