Spread Sheet
gloo1989
CH02Level1Figures1.xlsxCurrent
| Quality Control Data for TZBlazer Skis | ||||||
| Mfg ID# | Size | Style | Date Manufactured | Production Line | Friction Coefficient | Torsion Strength |
| 12134 | 174 | A | 11/17 | 1 | 0.82 | 2.21 |
| 12135 | 174 | A | 11/17 | 1 | 0.49 | 1.94 |
| 12139 | 174 | A | 11/17 | 1 | 0.52 | 2.03 |
| 12140 | 167 | A | 11/17 | 1 | 0.63 | 2.24 |
| 12142 | 167 | A | 11/17 | 1 | 0.64 | 2.28 |
| 12144 | 167 | A | 11/17 | 1 | 1.28 | 2.31 |
| 12145 | 174 | A | 11/17 | 1 | 0.45 | 2.02 |
| 12146 | 167 | A | 11/17 | 1 | 1.13 | 2.05 |
| 12148 | 167 | E | 11/18 | 1 | 0.43 | 2.27 |
| 12149 | 174 | E | 11/18 | 1 | 0.47 | 2.31 |
| 12154 | 174 | E | 11/18 | 1 | 0.97 | 2.23 |
| 12156 | 174 | E | 11/18 | 1 | 0.81 | 2.11 |
| 12160 | 174 | E | 11/19 | 1 | 0.68 | 2.22 |
| 12161 | 174 | E | 11/19 | 1 | 0.67 | 2.08 |
| 12162 | 181 | E | 11/19 | 1 | 0.95 | 2.01 |
| 12136 | 181 | R | 11/17 | 2 | 1.32 | 2.35 |
| 12137 | 181 | R | 11/17 | 2 | 0.75 | 1.73 |
| 12138 | 181 | R | 11/17 | 2 | 0.92 | 2.08 |
| 12141 | 181 | R | 11/17 | 2 | 0.46 | 2.26 |
| 12143 | 174 | R | 11/17 | 2 | 1.04 | 2.24 |
| 12147 | 181 | A | 11/18 | 2 | 0.90 | 2.01 |
| 12150 | 167 | A | 11/18 | 2 | 0.97 | 2.00 |
| 12151 | 181 | A | 11/18 | 2 | 0.49 | 2.08 |
| 12152 | 181 | A | 11/18 | 2 | 0.75 | 2.17 |
| 12153 | 167 | A | 11/18 | 2 | 0.30 | 3.22 |
| 12155 | 181 | E | 11/18 | 2 | 1.01 | 2.24 |
| 12157 | 181 | E | 11/19 | 2 | 0.84 | 2.34 |
| 12158 | 174 | E | 11/19 | 2 | 0.68 | 2.10 |
| 12159 | 181 | A | 11/19 | 2 | 0.58 | 2.33 |
| Mean | 0.76 | 2.19 | ||||
| Median | 0.75 | 2.21 | ||||
| Mode | 0.49 | 2.24 | ||||
| Standard Deviation | 0.26 | 0.25 | ||||
Comparison
| Analysis of Statistical Values - Current Data vs. Historical Data | |||||||||
| Friction Coefficient | Torsion Strength | ||||||||
| Value: | Historical | Current | Difference | %Difference | Historical | Current | Difference | %Difference | |
| Mean | 0.76 | 0.76 | 2.27 | 2.19 | |||||
| Median | 0.73 | 0.75 | 2.24 | 2.21 | |||||
| Mode | 0.53 | 0.49 | 2.15 | 2.24 | |||||
| Standard Deviation | 0.27 | 0.26 | 0.24 | 0.25 |
Figure2.4
| Quality Control Data for TZBlazer Skis | ||||||
| Mfg ID# | Size | Style | Date Manufactured | Production Line | Friction Coefficient | Torsion Strength |
| 12134 | 174 | A | 11/17 | 1 | 0.82 | 2.21 |
| 12135 | 174 | A | 11/17 | 1 | 0.49 | 1.94 |
| 12139 | 174 | A | 11/17 | 1 | 0.52 | 2.03 |
| 12140 | 167 | A | 11/17 | 1 | 0.63 | 2.24 |
| 12142 | 167 | A | 11/17 | 1 | 0.64 | 2.28 |
| 12144 | 167 | A | 11/17 | 1 | 1.28 | 2.31 |
| 12145 | 174 | A | 11/17 | 1 | 0.45 | 2.02 |
| 12146 | 167 | A | 11/17 | 1 | 1.13 | 2.05 |
| 12148 | 167 | E | 11/18 | 1 | 0.43 | 2.27 |
| 12149 | 174 | E | 11/18 | 1 | 0.47 | 2.31 |
| 12154 | 174 | E | 11/18 | 1 | 0.97 | 2.23 |
| 12156 | 174 | E | 11/18 | 1 | 0.81 | 2.11 |
| 12160 | 174 | E | 11/19 | 1 | 0.68 | 2.22 |
| 12161 | 174 | E | 11/19 | 1 | 0.67 | 2.08 |
| 12162 | 181 | E | 11/19 | 1 | 0.95 | 2.01 |
| 12136 | 181 | R | 11/17 | 2 | 1.32 | 2.35 |
| 12137 | 181 | R | 11/17 | 2 | 0.75 | 1.7345 |
| 12138 | 181 | R | 11/17 | 2 | 0.92 | 2.08 |
| 12141 | 181 | R | 11/17 | 2 | 0.46 | 2.26 |
| 12143 | 174 | R | 11/17 | 2 | 1.04 | 2.24 |
| 12147 | 181 | A | 11/18 | 2 | 0.90 | 2.01 |
| 12150 | 167 | A | 11/18 | 2 | 0.97 | 2.00001 |
| 12151 | 181 | A | 11/18 | 2 | 0.49 | 2.08 |
| 12152 | 181 | A | 11/18 | 2 | 0.75 | 2.17 |
| 12153 | 167 | A | 11/18 | 2 | 0.30 | 3.216 |
| 12155 | 181 | E | 11/18 | 2 | 1.01 | 2.24 |
| 12157 | 181 | E | 11/19 | 2 | 0.84 | 2.34 |
| 12158 | 174 | E | 11/19 | 2 | 0.68 | 2.1 |
| 12159 | 181 | A | 11/19 | 2 | 0.58 | 2.33 |
Figure2.5
| Quality Control Data for TZBlazer Skis | |||||||
| Mfg ID# | Size | Style | Date Manufactured | Production Line | Friction Coefficient | Torsion Strength | |
| 12134 | 174 | A | 11/17 | 1 | 0.82 | 2.21 | 2.21 |
| 12135 | 174 | A | 11/17 | 1 | 0.49 | 1.94 | 1.94 |
| 12139 | 174 | A | 11/17 | 1 | 0.52 | 2.03 | 2.03 |
| 12140 | 167 | A | 11/17 | 1 | 0.63 | 2.24 | 2.24 |
| 12142 | 167 | A | 11/17 | 1 | 0.64 | 2.28 | 2.28 |
| 12144 | 167 | A | 11/17 | 1 | 1.28 | 2.31 | 2.31 |
| 12145 | 174 | A | 11/17 | 1 | 0.45 | 2.02 | 2.02 |
| 12146 | 167 | A | 11/17 | 1 | 1.13 | 2.05 | 2.05 |
| 12148 | 167 | E | 11/18 | 1 | 0.43 | 2.27 | 2.27 |
| 12149 | 174 | E | 11/18 | 1 | 0.47 | 2.31 | 2.31 |
| 12154 | 174 | E | 11/18 | 1 | 0.97 | 2.23 | 2.23 |
| 12156 | 174 | E | 11/18 | 1 | 0.81 | 2.11 | 2.11 |
| 12160 | 174 | E | 11/19 | 1 | 0.68 | 2.22 | 2.22 |
| 12161 | 174 | E | 11/19 | 1 | 0.67 | 2.08 | 2.08 |
| 12162 | 181 | E | 11/19 | 1 | 0.95 | 2.01 | 2.01 |
| 12136 | 181 | R | 11/17 | 2 | 1.32 | 2.35 | 2.35 |
| 12137 | 181 | R | 11/17 | 2 | 0.75 | 1.7345 | 1.73 |
| 12138 | 181 | R | 11/17 | 2 | 0.92 | 2.08 | 2.08 |
| 12141 | 181 | R | 11/17 | 2 | 0.46 | 2.26 | 2.26 |
| 12143 | 174 | R | 11/17 | 2 | 1.04 | 2.24 | 2.24 |
| 12147 | 181 | A | 11/18 | 2 | 0.90 | 2.01 | 2.01 |
| 12150 | 167 | A | 11/18 | 2 | 0.97 | 2.00001 | 2.00 |
| 12151 | 181 | A | 11/18 | 2 | 0.49 | 2.08 | 2.08 |
| 12152 | 181 | A | 11/18 | 2 | 0.75 | 2.17 | 2.17 |
| 12153 | 167 | A | 11/18 | 2 | 0.30 | 3.216 | 3.22 |
| 12155 | 181 | E | 11/18 | 2 | 1.01 | 2.24 | 2.24 |
| 12157 | 181 | E | 11/19 | 2 | 0.84 | 2.34 | 2.34 |
| 12158 | 174 | E | 11/19 | 2 | 0.68 | 2.1 | 2.10 |
| 12159 | 181 | A | 11/19 | 2 | 0.58 | 2.33 | 2.33 |
Figure2.6
Figure2.7
| Quality Control Data for TZBlazer Skis | ||||||
| Mfg ID# | Size | Style | Date Manufactured | Production Line | Friction Coefficient | Torsion Strength |
| 12134 | 174 | A | 11/17 | 1 | 0.82 | 2.21 |
| 12135 | 174 | A | 11/17 | 1 | 0.49 | 1.94 |
| 12139 | 174 | A | 11/17 | 1 | 0.52 | 2.03 |
| 12140 | 167 | A | 11/17 | 1 | 0.63 | 2.24 |
| 12142 | 167 | A | 11/17 | 1 | 0.64 | 2.28 |
| 12144 | 167 | A | 11/17 | 1 | 1.28 | 2.31 |
| 12145 | 174 | A | 11/17 | 1 | 0.45 | 2.02 |
| 12146 | 167 | A | 11/17 | 1 | 1.13 | 2.05 |
| 12148 | 167 | E | 11/18 | 1 | 0.43 | 2.27 |
| 12149 | 174 | E | 11/18 | 1 | 0.47 | 2.31 |
| 12154 | 174 | E | 11/18 | 1 | 0.97 | 2.23 |
| 12156 | 174 | E | 11/18 | 1 | 0.81 | 2.11 |
| 12160 | 174 | E | 11/19 | 1 | 0.68 | 2.22 |
| 12161 | 174 | E | 11/19 | 1 | 0.67 | 2.08 |
| 12162 | 181 | E | 11/19 | 1 | 0.95 | 2.01 |
| 12136 | 181 | R | 11/17 | 2 | 1.32 | 2.35 |
| 12137 | 181 | R | 11/17 | 2 | 0.75 | 1.73 |
| 12138 | 181 | R | 11/17 | 2 | 0.92 | 2.08 |
| 12141 | 181 | R | 11/17 | 2 | 0.46 | 2.26 |
| 12143 | 174 | R | 11/17 | 2 | 1.04 | 2.24 |
| 12147 | 181 | A | 11/18 | 2 | 0.90 | 2.01 |
| 12150 | 167 | A | 11/18 | 2 | 0.97 | 2.00 |
| 12151 | 181 | A | 11/18 | 2 | 0.49 | 2.08 |
| 12152 | 181 | A | 11/18 | 2 | 0.75 | 2.17 |
| 12153 | 167 | A | 11/18 | 2 | 0.30 | 3.22 |
| 12155 | 181 | E | 11/18 | 2 | 1.01 | 2.24 |
| 12157 | 181 | E | 11/19 | 2 | 0.84 | 2.34 |
| 12158 | 174 | E | 11/19 | 2 | 0.68 | 2.10 |
| 12159 | 181 | A | 11/19 | 2 | 0.58 | 2.33 |
Figure2.8
Figure2.9
| Quality Control Data for TZBlazer Skis | ||||||
| Mfg ID# | Size | Style | Date Manufactured | Production Line | Friction Coefficient | Torsion Strength |
| 12134 | 174 | A | 11/17 | 1 | 0.82 | 2.21 |
| 12135 | 174 | A | 11/17 | 1 | 0.49 | 1.94 |
| 12139 | 174 | A | 11/17 | 1 | 0.52 | 2.03 |
| 12140 | 167 | A | 11/17 | 1 | 0.63 | 2.24 |
| 12142 | 167 | A | 11/17 | 1 | 0.64 | 2.28 |
| 12144 | 167 | A | 11/17 | 1 | 1.28 | 2.31 |
| 12145 | 174 | A | 11/17 | 1 | 0.45 | 2.02 |
| 12146 | 167 | A | 11/17 | 1 | 1.13 | 2.05 |
| 12148 | 167 | E | 11/18 | 1 | 0.43 | 2.27 |
| 12149 | 174 | E | 11/18 | 1 | 0.47 | 2.31 |
| 12154 | 174 | E | 11/18 | 1 | 0.97 | 2.23 |
| 12156 | 174 | E | 11/18 | 1 | 0.81 | 2.11 |
| 12160 | 174 | E | 11/19 | 1 | 0.68 | 2.22 |
| 12161 | 174 | E | 11/19 | 1 | 0.67 | 2.08 |
| 12162 | 181 | E | 11/19 | 1 | 0.95 | 2.01 |
| 12136 | 181 | R | 11/17 | 2 | 1.32 | 2.35 |
| 12137 | 181 | R | 11/17 | 2 | 0.75 | 1.73 |
| 12138 | 181 | R | 11/17 | 2 | 0.92 | 2.08 |
| 12141 | 181 | R | 11/17 | 2 | 0.46 | 2.26 |
| 12143 | 174 | R | 11/17 | 2 | 1.04 | 2.24 |
| 12147 | 181 | A | 11/18 | 2 | 0.90 | 2.01 |
| 12150 | 167 | A | 11/18 | 2 | 0.97 | 2.00 |
| 12151 | 181 | A | 11/18 | 2 | 0.49 | 2.08 |
| 12152 | 181 | A | 11/18 | 2 | 0.75 | 2.17 |
| 12153 | 167 | A | 11/18 | 2 | 0.30 | 3.22 |
| 12155 | 181 | E | 11/18 | 2 | 1.01 | 2.24 |
| 12157 | 181 | E | 11/19 | 2 | 0.84 | 2.34 |
| 12158 | 174 | E | 11/19 | 2 | 0.68 | 2.10 |
| 12159 | 181 | A | 11/19 | 2 | 0.58 | 2.33 |
| Mean | 0.76 | 2.19 | ||||
| Median | 0.75 | 2.21 | ||||
| Mode | 0.49 | 2.24 | ||||
| Standard Deviation | 0.26 | 0.25 | ||||
Figure2.10
| Quality Control Data for TZBlazer Skis | ||||||
| Mfg ID# | Size | Style | Date Manufactured | Production Line | Friction Coefficient | Torsion Strength |
| 12134 | 174 | A | 11/17 | 1 | 0.82 | 2.21 |
| 12135 | 174 | A | 11/17 | 1 | 0.49 | 1.94 |
| 12139 | 174 | A | 11/17 | 1 | 0.52 | 2.03 |
| 12140 | 167 | A | 11/17 | 1 | 0.63 | 2.24 |
| 12142 | 167 | A | 11/17 | 1 | 0.64 | 2.28 |
| 12144 | 167 | A | 11/17 | 1 | 1.28 | 2.31 |
| 12145 | 174 | A | 11/17 | 1 | 0.45 | 2.02 |
| 12146 | 167 | A | 11/17 | 1 | 1.13 | 2.05 |
| 12148 | 167 | E | 11/18 | 1 | 0.43 | 2.27 |
| 12149 | 174 | E | 11/18 | 1 | 0.47 | 2.31 |
| 12154 | 174 | E | 11/18 | 1 | 0.97 | 2.23 |
| 12156 | 174 | E | 11/18 | 1 | 0.81 | 2.11 |
| 12160 | 174 | E | 11/19 | 1 | 0.68 | 2.22 |
| 12161 | 174 | E | 11/19 | 1 | 0.67 | 2.08 |
| 12162 | 181 | E | 11/19 | 1 | 0.95 | 2.01 |
| 12136 | 181 | R | 11/17 | 2 | 1.32 | 2.35 |
| 12137 | 181 | R | 11/17 | 2 | 0.75 | 1.73 |
| 12138 | 181 | R | 11/17 | 2 | 0.92 | 2.08 |
| 12141 | 181 | R | 11/17 | 2 | 0.46 | 2.26 |
| 12143 | 174 | R | 11/17 | 2 | 1.04 | 2.24 |
| 12147 | 181 | A | 11/18 | 2 | 0.90 | 2.01 |
| 12150 | 167 | A | 11/18 | 2 | 0.97 | 2.00 |
| 12151 | 181 | A | 11/18 | 2 | 0.49 | 2.08 |
| 12152 | 181 | A | 11/18 | 2 | 0.75 | 2.17 |
| 12153 | 167 | A | 11/18 | 2 | 0.30 | 3.22 |
| 12155 | 181 | E | 11/18 | 2 | 1.01 | 2.24 |
| 12157 | 181 | E | 11/19 | 2 | 0.84 | 2.34 |
| 12158 | 174 | E | 11/19 | 2 | 0.68 | 2.10 |
| 12159 | 181 | A | 11/19 | 2 | 0.58 | 2.33 |
| Mean | 0.76 | 2.19 | ||||
| Median | 0.75 | 2.21 | ||||
| Mode | 0.49 | 2.24 | ||||
| Standard Deviation | 0.26 | 0.25 | ||||
Figure2.11
| Quality Control Data for TZBlazer Skis | ||||||
| Mfg ID# | Size | Style | Date Manufactured | Production Line | Friction Coefficient | Torsion Strength |
| 12134 | 174 | A | 11/17 | 1 | 0.82 | 2.21 |
| 12135 | 174 | A | 11/17 | 1 | 0.49 | 1.94 |
| 12139 | 174 | A | 11/17 | 1 | 0.52 | 2.03 |
| 12140 | 167 | A | 11/17 | 1 | 0.63 | 2.24 |
| 12142 | 167 | A | 11/17 | 1 | 0.64 | 2.28 |
| 12144 | 167 | A | 11/17 | 1 | 1.28 | 2.31 |
| 12145 | 174 | A | 11/17 | 1 | 0.45 | 2.02 |
| 12146 | 167 | A | 11/17 | 1 | 1.13 | 2.05 |
| 12148 | 167 | E | 11/18 | 1 | 0.43 | 2.27 |
| 12149 | 174 | E | 11/18 | 1 | 0.47 | 2.31 |
| 12154 | 174 | E | 11/18 | 1 | 0.97 | 2.23 |
| 12156 | 174 | E | 11/18 | 1 | 0.81 | 2.11 |
| 12160 | 174 | E | 11/19 | 1 | 0.68 | 2.22 |
| 12161 | 174 | E | 11/19 | 1 | 0.67 | 2.08 |
| 12162 | 181 | E | 11/19 | 1 | 0.95 | 2.01 |
| 12136 | 181 | R | 11/17 | 2 | 1.32 | 2.35 |
| 12137 | 181 | R | 11/17 | 2 | 0.75 | 1.73 |
| 12138 | 181 | R | 11/17 | 2 | 0.92 | 2.08 |
| 12141 | 181 | R | 11/17 | 2 | 0.46 | 2.26 |
| 12143 | 174 | R | 11/17 | 2 | 1.04 | 2.24 |
| 12147 | 181 | A | 11/18 | 2 | 0.90 | 2.01 |
| 12150 | 167 | A | 11/18 | 2 | 0.97 | 2.00 |
| 12151 | 181 | A | 11/18 | 2 | 0.49 | 2.08 |
| 12152 | 181 | A | 11/18 | 2 | 0.75 | 2.17 |
| 12153 | 167 | A | 11/18 | 2 | 0.30 | 3.22 |
| 12155 | 181 | E | 11/18 | 2 | 1.01 | 2.24 |
| 12157 | 181 | E | 11/19 | 2 | 0.84 | 2.34 |
| 12158 | 174 | E | 11/19 | 2 | 0.68 | 2.10 |
| 12159 | 181 | A | 11/19 | 2 | 0.58 | 2.33 |
| Mean | 0.76 | 2.19 | ||||
| Median | 0.75 | 2.21 | ||||
| Mode | 0.49 | 2.24 | ||||
| Standard Deviation | 0.26 | 0.25 | ||||
Figure2.12a
| Analysis of Statistical Values - Current Data vs. Historical Data | |||||||||
| Friction Coefficient | Torsion Strength | ||||||||
| Value: | Historical | Current | Difference | %Difference | Historical | Current | Difference | %Difference | |
| Mean | 0.76 | 0.76 | 2.27 | 2.19 | |||||
| Median | 0.73 | 0.75 | 2.24 | 2.21 | |||||
| Mode | 0.53 | 0.49 | 2.15 | 2.24 | |||||
| Standard Deviation | 0.27 | 0.26 | 0.24 | 0.25 |
Figure2.12b
| Analysis of Statistical Values - Current Data vs. Historical Data | |||||||||
| Friction Coefficient | Torsion Strength | ||||||||
| Value: | Historical | Current | Difference | %Difference | Historical | Current | Difference | %Difference | |
| Mean | 0.76 | 0.76 | 2.27 | 2.19 | |||||
| Median | 0.73 | 0.75 | 2.24 | 2.21 | |||||
| Mode | 0.53 | 0.49 | 2.15 | 2.24 | |||||
| Standard Deviation | 0.27 | 0.26 | 0.24 | 0.25 |
Figure2.13
| Analysis of Statistical Values - Current Data vs. Historical Data | |||||||||
| Friction Coefficient | Torsion Strength | ||||||||
| Value: | Historical | Current | Difference | %Difference | Historical | Current | Difference | %Difference | |
| Mean | 0.76 | 0.76 | -0.003 | 2.27 | 2.19 | ||||
| Median | 0.73 | 0.75 | 0.020 | 2.24 | 2.21 | ||||
| Mode | 0.53 | 0.49 | -0.040 | 2.15 | 2.24 | ||||
| Standard Deviation | 0.27 | 0.26 | -0.008 | 0.24 | 0.25 |
Figure2.14
| Analysis of Statistical Values - Current Data vs. Historical Data | |||||||||
| Friction Coefficient | Torsion Strength | ||||||||
| Value: | Historical | Current | Difference | %Difference | Historical | Current | Difference | %Difference | |
| Mean | 0.76 | 0.76 | -0.003 | -0.41% | 2.27 | 2.19 | -0.082 | -3.60% | |
| Median | 0.73 | 0.75 | 0.020 | 2.74% | 2.24 | 2.21 | -0.030 | -1.34% | |
| Mode | 0.53 | 0.49 | -0.040 | -7.55% | 2.15 | 2.24 | 0.090 | 4.19% | |
| Standard Deviation | 0.27 | 0.26 | -0.008 | -2.95% | 0.24 | 0.25 | 0.005 | 2.29% |
1
2
3
4
5
6
A
B
C
D
Mfg ID#
Size
Style
Date
Manufactured
12134
174
A
11/17
12135
174
A
11/17
12139
174
A
11/17
12140
167
A
11/17
Quality Control Data for TZBlazer Skis
