Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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.

  1. 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 20th 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.

  1. 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 20th 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Counting With Symmetric Functions

Authors: Jeffrey Remmel, Anthony Mendes

1st Edition

3319236180, 9783319236186

More Books

Students also viewed these Mathematics questions

Question

Outline the four functions and two attitudes in Jungs psychology.

Answered: 1 week ago

Question

please dont use chat gpt or other AI 1 0 6 5 . .

Answered: 1 week ago

Question

The relevance of the information to the interpreter

Answered: 1 week ago