Question 1 The production manager of American Tool and Castings Company is conducting a study regarding the relationship between the number of alloy caps milled on a lathe versus the measure of distance from specification of outside cap diameters The lathe uses a sharp steel cutting tool in a milling process to cut and shape raw alloy bars into caps The lathe tool turns at a high speed while cutting into the alloy, in essence, cutting the alloy down to size and shaping it to resemble a round cap A similar lathe tool cuts into the inside of the cap The caps are later fit with interior gaskets and permanently sealed onto airtight canisters After the steel cutting tool is used repeatedly, the tool begins to wear, hence cutting a larger outside cap diameter than desired If the outside cap diameter is too large the cap can't be properly affixed and sealed to the canister The production manager would like to build a model to estimate predict how many caps a tool can mill until it wears down too much, hence milling caps that are too large in diameter and unusable Each cap costs approximately $400 to mill, so defective caps are expensive The main variable of interest (y) is distance from specification of outside cap diameter To conduct the study, 62 lathe tools were randomly sampled Each lathe operator keeps a record of the number of caps milled by particular tool Each cap milled is measured to see how close to specification the outside diameter is According to specification, each cap should be 6 inches in diameter For example, the measure in record one is 0 36, meaning it was 0 36 inches larger than specification When each tool was sampled, the number of caps milled by the tool was recorded, as well as a measure from specification of the diameter of the last cap milled by that particular tool The data for each cutting tool sampled and the measure of distance from specification of the outside cap diameter of the last cap milled is in the spreadsheet labeled American 4 points Scatterplot Construct a scatterplot revealing the relationship between the number of caps milled by a tool and the distance from specification of the outside cap diameter Make sure the x variable is on the x axis and the y variable is on the y axis Move the chart so that it starts in cell E3 Do not resize the chart beyond the red shaded region 6 points Correlation 2 points Using a built in Excel function in cell F22, calculate the correlation (r) between the number of caps milled by a tool and the distance from specification of the outside cap diameter 2 points In cell F23, indicate the strength of the linear relationship as very strong, relatively strong, very weak, relatively weak, or no relationship 2 points In cell F24, indicate if the relationship is positive or negative 4 points Anchoring the output in cell P3 , generate the regression output Make sure you select an appropriate Residual Plot, and place the residual plot in the designated area near cell E32 6 points Output 2 points In cells J23 and J24, enter the value of the intercept and slope (respectively) by referencing the appropriate cells in the regression output 1 point In cell K24, enter the value of the t test statistic for testing the slope significance by referencing the appropriate cell from the regression output 1 point In cell L24, enter the p value regarding the slope significance by referencing the appropriate cell from the regression output 2 points In cell M24, indicate with the word Yes or No if the slope coefficient is significant Assume 0 01 2 points In cell F29, provide the predictive power (a k a the coefficient of determination) of the model by referencing the appropriate cell from the regression output 4 points In cell J29, write the prediction equation relating NM to DS using the intercept and slope values This is a text input that starts with a number, so you must start the input with a space to trick Excel into interpreting the input as text For example, if a 4 and b 10, enter 4 10(NM), placing a space before the value 4 6 points 2 points Cell E32 should contain the residual plot Keep the plot within the red shaded area 2 points In cell F48, comment on the assumption of linearity as interpreted using this residual plot 2 points In cell F49, comment on the assumption of constant variance as interpreted using this residual plot 6 points Prediction and Residual 2 points In cell F53, predict the distance from specification of a cap milled by a tool when the cap is the 20 th cap to be milled 4 points In cells F54 and F55, determine the lower and upper values for the range for the independent variable in this data set 12 points Prediction Interval Using the table in cells J52 K53 as the Predication Data Set and StatTools, calculate the lower limit and upper limit for a 95 prediction interval for the DS of a cap that is the 20 th cap milled Anchor your StatTools Regression output in cell A1 of the Regression Worksheet Place the values in cells J58 and K58 by referencing the appropriate cells in the StatTools output Note that this will shift the columns of your worksheet

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 12, 2024

Question 1 The production manager of American Tool and Castings Company is conducting a study regarding the relationship between the number of alloy caps milled

Question 1

The production manager of American Tool and Castings Company is conducting a study regarding the relationship between the number of alloy caps milled on a lathe versus the measure of distance from specification of outside cap diameters. The lathe uses a sharp steel cutting tool in a milling process to cut and shape raw alloy bars into caps. The lathe tool turns at a high speed while cutting into the alloy, in essence, cutting the alloy down to size and shaping it to resemble a round cap.A similar lathe tool cuts into the inside of the cap. The caps are later fit with interior gaskets and permanently sealed onto airtight canisters. After the steel cutting tool is used repeatedly, the tool begins to wear, hence cutting a larger outside cap diameter than desired. If the outside cap diameter is too large the cap can't be properly affixed and sealed to the canister. The production manager would like to build a model to estimate/predict how many caps a tool can mill until it wears down too much, hence milling caps that are too large in diameter and unusable. Each cap costs approximately $400 to mill, so defective caps are expensive.The main variable of interest (y) is "distance from specification" of outside cap diameter.

To conduct the study, 62 lathe tools were randomly sampled. Each lathe operator keeps a record of the number of caps milled by particular tool. Each cap milled is measured to see how close to specification the outside diameter is.According to specification, each cap should be 6 inches in diameter. For example, the measure in record one is 0.36, meaning it was 0.36 inches larger than specification. When each tool was sampled, the number of caps milled by the tool was recorded, as well as a measure from specification of the diameter of the last cap milled by that particular tool. The data for each cutting tool sampled and the measure of distance from specification of the outside cap diameter of the last cap milled is in the spreadsheet labeled American.

4 points: Scatterplot
- Construct a scatterplot revealing the relationship between the number of caps milled by a tool and the distance from specification of the outside cap diameter. Make sure the x variable is on the x-axis and the y-variable is on the y-axis. Move the chart so that it starts in cell E3. Do not resize the chart beyond the red shaded region.

6 points: Correlation
- 2 points: Using a built-in Excel function in cell F22, calculate the correlation (r) between the number of caps milled by a tool and the distance from specification of the outside cap diameter.
- 2 points: In cell F23, indicate the strength of the linear relationship as very strong, relatively strong, very weak, relatively weak, or no relationship.
- 2 points: In cell F24, indicate if the relationship is positive or negative.

4 points: Anchoring the output in cell P3, generate the regression output. Make sure you select an appropriate "Residual Plot," and place the residual plot in the designated area near cell E32.

6 points: Output
- 2 points: In cells J23 and J24, enter the value of the intercept and slope (respectively) by referencing the appropriate cells in the regression output.
- 1 point: In cell K24, enter the value of the t test statistic for testing the slope significance by referencing the appropriate cell from the regression output.
- 1 point: In cell L24, enter the p-value regarding the slope significance by referencing the appropriate cell from the regression output.
- 2 points: In cell M24, indicate with the word "Yes" or "No" if the slope coefficient is significant. Assume =0.01.

2 points: In cell F29, provide the predictive power (a.k.a. the coefficient of determination) of the model by referencing the appropriate cell from the regression output.

4 points: In cell J29, write the prediction equation relating NM to DS using the intercept and slope values. This is a text input that starts with a number, so you must start the input with a space to trick Excel into interpreting the input as text. For example, if a = 4 and b = 10, enter 4 + 10(NM), placing a space before the value 4.

6 points:
- 2 points: Cell E32 should contain the residual plot. Keep the plot within the red shaded area.
- 2 points: In cell F48, comment on the assumption of linearity as interpreted using this residual plot.
- 2 points: In cell F49, comment on the assumption of constant variance as interpreted using this residual plot.

6 points: Prediction and Residual
- 2 points: In cell F53, predict the distance from specification of a cap milled by a tool when the cap is the 20^th cap to be milled.
- 4 points: In cells F54 and F55, determine the lower and upper values for the range for the independent variable in this data set.

12 points: Prediction Interval

Using the table in cells J52:K53 as the Predication Data Set and StatTools, calculate the lower limit and upper limit for a 95% prediction interval for the DS of a cap that is the 20^th cap milled. Anchor your StatTools Regression output in cell A1 of the Regression Worksheet Place the values in cells J58 and K58 by referencing the appropriate cells in the StatTools output. Note that this will shift the columns of your worksheet.