Question

In: Statistics and Probability

Use Minitab to do a complete analysis of the following problem. Heat treating is often used...

Use Minitab to do a complete analysis of the following problem. Heat treating is often used to carburize metal parts such as gears. The of the carburized layer is considered a crucial feature of the gear and contributes to the overall reliability of the part. Because of the critical nature of this feature, two different lab tests are performed on each furnace load. One test is run on a sample pin that accompanies each load. The other test is a destructive test that cross-sections an actual part. This test involves running a carbon analysis on the surface of both the gear pitch (top of the gear tooth) and the gear root (between the gear teeth). Data is in excel file HW 6-Q6 Heat Treating.xlsx, shows the results of the pitch carbon analysis test for 32 parts. The regressors are furnace temperature (TEMP), carbon concentration and duration of the carburizing cycle (SOAK-PCT, SOAKTIME), and carbon concentration and duration of the diffuse cycle (DIFFPCT, DIFFTIME)

Temp

SoakTime

SoakPct

DiffTime

DiffPct

Pitch

1650

0.58

1.1

0.25

0.9

0.013

1650

0.66

1.1

0.33

0.9

0.016

1650

0.66

1.1

0.33

0.9

0.015

1650

0.66

1.1

0.33

0.95

0.016

1600

0.66

1.15

0.33

1

0.015

1600

0.66

1.15

0.33

1

0.016

1650

1

1.1

0.5

0.8

0.014

1650

1.17

1.1

0.58

0.8

0.021

1650

1.17

1.1

0.58

0.8

0.018

1650

1.17

1.1

0.58

0.8

0.019

1650

1.17

1.1

0.58

0.9

0.021

1650

1.17

1.1

0.58

0.9

0.019

1650

1.17

1.15

0.58

0.9

0.021

1650

1.2

1.15

1.1

0.8

0.025

1650

2

1.15

1

0.8

0.025

1650

2

1.1

1.1

0.8

0.026

1650

2.2

1.1

1.1

0.8

0.024

1650

2.2

1.1

1.1

0.8

0.025

1650

2.2

1.5

1.1

0.8

0.024

1650

2.2

1.1

1.1

0.9

0.025

1650

2.2

1.1

1.1

0.9

0.027

1650

2.2

1.1

1.5

0.9

0.026

1650

3

1.15

1.5

0.8

0.029

1650

3

1.1

1.5

0.7

0.03

1650

3

1.1

1.5

0.75

0.028

1650

3

1.15

1.66

0.85

0.032

1650

3.33

1.1

1.5

0.8

0.033

1700

4

1.1

1.5

0.7

0.039

1650

4

1.1

1.5

0.7

0.04

1650

4

1.15

1.5

0.85

0.035

1700

12.5

1

1.5

0.7

0.056

1700

18.5

1

1.5

0.7

0.068

1.State the problem—what are you trying to find out?

2.Fit a regression model using all of the five regressors. Summarize this analysis by providing the equation, ??2, and list the standard errors. What do you notice about the p values for the regressors? What does the analysis of variance indicate?

3.Use the model to predict PITCH when TEMP=1650, SOAKTIME=1, SOAKPCT=1.1, DIFFTIME=1 and DIFFPCT=.8.

4.Do you have any problems with multicollinearity?

5.Construct a t-test on each regression coefficient. What can you conclude about the variables in this model? Use an alpha = 0.05.

6.Find a 95% confidence interval on each of the coefficients that were identified to be significant. Also construct a confidence interval and prediction interval on the future observation for the data given in Q3.

7.Prepare a normal probability plot of the residuals and check the adequacy of the model.

8.Utilize stepwise regression to identify a model. How does this model differ from the first one you created? Construct a normal probability plot on the residuals to check model adequacy. Write out the equation.

9.What are the possible benefits of using a model that has fewer regressors?

Solutions

Expert Solution

solution:

1.our problem is to test whether do these regresion varibles really affect the response pitch

2. Output through miinitab

Regression Equation

pitch = -0.0302 + 0.000029 temp + 0.002318 soaktime - 0.00303 soakpct + 0.00848 difftime - 0.00236 diffpct

Regression Analysis: pitch versus temp, soaktime, soakpct, difftime, diffpct

Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 5 0.004189 0.000838 158.92 0
temp 1 0.000004 0.000004 0.69 0.414
soaktime 1 0.000939 0.000939 178.17 0
soakpct 1 0.000001 0.000001 0.27 0.609
difftime 1 0.000256 0.000256 48.47 0
diffpct 1 0 0 0.09 0.772
Error 26 0.000137 0.000005
Lack-of-Fit 19 0.000127 0.000007 4.6 0.023
Pure Error 7 0.00001 0.000001
Total 31 0.004326

?conclusion: through ANOVA table we can observe that Pvlue for Soaktime and diff time is 0 ,ths implies that there is no contributio of these two variables in variablity of pitch

3) pitch=-0.0302+0.000029*1650+0.00231*1-0.00303*1.1+0.00848*1-0.00236*0.8

    pitch=0.023219
4) we can observe for all variables is greater than 1 ,hence multicollinearity is present

5) t-test on each regression coefficient

?# result of indidvidual t test

Term Coef SE Coef T-Value P-Value VIF
Constant -0.0302 0.0618 -0.49 0.629
temp 0.000029 0.000034 0.83 0.414 2.78
soaktime 0.002318 0.000174 13.35 0 2.28
soakpct -0.00303 0.00584 -0.52 0.609 1.22
difftime 0.00848 0.00122 6.96 0 2
diffpct -0.00236 0.00808 -0.29 0.772 2.71

??conclusion: we can observe that Pvlue for Soaktime and diff time is 0 ,ths implies that there is no contributio of these two variables in variablity of pitch

6) Confidence interval

regressor lower limit upper limit
temp 1.722E-05 4.07804E-05
soakpct -0.00505346 -0.001006543
diffpct -0.00515958 0.000439577

Related Solutions

it is a different table so please do the calculation again Heat treating is often used...
it is a different table so please do the calculation again Heat treating is often used to carburize metal parts, such as gears. The thickness of the carburized layer is considered a crucial feature of the gear and contributes to the overall reliability of the part. Because of the critical nature of this feature, two different lab tests are performed on each furnace load. One test is run on a sample pin that accompanies each load. The other test is...
Heat treating is often used to carburize metal parts, such as gears. The thickness of the...
Heat treating is often used to carburize metal parts, such as gears. The thickness of the carburized layer is considered a crucial feature of the gear and contributes to the overall reliability of the part. Because of the critical nature of this feature, two different lab tests are performed on each furnace load. One test is run on a sample pin that accompanies each load. The other test is a destructive test, where an actual part is cross-sectioned. This test...
Heat treating is often used to carburize metal parts, such as gears. The thickness of the...
Heat treating is often used to carburize metal parts, such as gears. The thickness of the carburized layer is considered a crucial feature of the gear and contributes to the overall reliability of the part. Because of the critical nature of this feature, two different lab tests are performed on each furnace load. One test is run on a sample pin that accompanies each load. The other test is a destructive test, where an actual part is cross-sectioned. This test...
Heat treating is often used to carburize metal parts, such as gears. The thickness of the...
Heat treating is often used to carburize metal parts, such as gears. The thickness of the carburized layer is considered a crucial feature of the gear and contributes to the overall reliability of the part. Because of the critical nature of this feature, two different lab tests are performed on each furnace load. One test is run on a sample pin that accompanies each load. The other test is a destructive test, where an actual part is cross-sectioned. This test...
Use calculator or Excel to solve the following problems. DO NOT USE MINITAB (except e). Do...
Use calculator or Excel to solve the following problems. DO NOT USE MINITAB (except e). Do NOT use Excel built-in functions or solvers (except t.inv() and f.inv() to obtain critical t and f values). The tensile strength of Portland cement is being studied. Four different mixing techniques can be used economically. A completely randomized experiment was conducted and the following data were collected: Technique Tensile Strength Tensile Strength Tensile Strength Tensile Strength 1 3129 3000 2865 2890 2 3200 3300...
Option #2: Financial Statement Analysis Problems Complete the following problems: 1. For this problem, use the...
Option #2: Financial Statement Analysis Problems Complete the following problems: 1. For this problem, use the following randomly generated list of accounts, placing them in appropriate order to prepare an income statement. Accounts ($000,000) Depreciation 25 General and administrative expenses 22 Sales 345 Sales expenses 18 Cost of goods sold 255 Lease expense 4 Interest expense 3 The following randomly constructed table requires that as part of your Critical Thinking Assignment you arrange the accounts into a well-labeled income statement....
Subject: Heat exchanger Lab Question: 1.1) in heat exchanger analysis, the following quantities are used. Explain...
Subject: Heat exchanger Lab Question: 1.1) in heat exchanger analysis, the following quantities are used. Explain what each means and give a formula for each. Assume the mass flow rates, fluid properties, inlet, temperatures, and length and diameters of the heat exchanger are known. a) Overall heat transfer coefficient. UA. b) A number of transfer units, NTU. c) Effectiveness, e 1.2) what is the hydraulic diameter and why is it useful for double-pipe heat exchanger analysis?
Please solve using MINITAB Complete the problem as a “two to the fifth minus one, resolution...
Please solve using MINITAB Complete the problem as a “two to the fifth minus one, resolution five” Fractional Factorial DOE with factor E as the fifth factor. Answer the following: a) Determine what factors if any are statistically significant, b) Determine if there are any two factor interactions and if so, show graphically, c) Determine the model equation. Data shown on the next slide. A B C D E Response -1 -1 -1 -1 1 38.9 1 -1 -1 -1...
This is the data analysis using technology part of the Midterm. Use Minitab or a graphing...
This is the data analysis using technology part of the Midterm. Use Minitab or a graphing calculator to accomplish this assignment. You can copy and paste the data into a Minitab worksheet to run the analysis. If you use a graphing calculator, take a screen shot or a picture of the calculator output. The table below is a sample data set from 50 people. Carefully read and answer the following questions: (2pts) Make a Normal Probability Plot (Graph-Probability Plot-Single) for...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 101 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 96 3.0 3.3 94 3.5 2.3 94 2.5 4.2 101 3.0 2.5 a. Develop an estimated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT