Problem 7-7 Instructor Reserve
HeetJet Enterprises
Descriptive Statistics Using Excel Functions Descriptive Statistics
Using Data Analysis Excel Add-In
Data Sorted data
1 15.008 14.985 Mean 15.0005 Column1
2 15.000 14.985 Median 15 By inspection of sorted data
8 14.993 14.993 Stnd Dev (pop.) 0.0082006 Sample Variance 0.0001
9 14.993 15.000 Stnd Dev (sampl.) 0.0083408 Kurtosis -0.3305
10 15.015 15.000 Skewness -0.1392
11 15.008 15.000 Range 0.0300
12 15.015 15.000 Minimum 14.9850
13 15.008 15.000 Maximum 15.0150
14 15.008 15.000 Sum 450.0150
15 15.000 15.000 Count 30.0000
16 14.985 15.000
Confidence Level(95.0%)
0.0031
22 15.000 15.008
23 15.000 15.008 Original Data
24 15.000 15.008
25 15.008 15.008 15.008 15.000 15.008 14.985 14.993 15.008
26 15.008 15.008 15.000 15.000 15.015 14.993 15.000 14.993
Problem 7-7 Instructor Reserve
HeetJet Enterprises
Taguchi Loss Function
Enter data only in yellow cells.
Calculation of k for the Loss Function
Deviation from target 0.0250
Loss Calculation for a Specific x
Target specification, T 0.00
Dimensional value, x 0
Expected Loss Calculation
Economic Design Specifications
Target specification, T 15.00
Process mean 15.0005