Spread Sheet

profilegloo1989
CH02Level2Figures1.xlsx
Home>Business & Finance homework help>Accounting homework help>Spread Sheet

Current

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost
12134 174 A 11/17 1 0.82 2.21 $ 54.50
12135 174 A 11/17 1 0.49 1.94 54.50
12139 174 A 11/17 1 0.52 2.03 54.50
12140 167 A 11/17 1 0.63 2.24 45.50
12142 167 A 11/17 1 0.64 2.28 45.50
12144 167 A 11/17 1 1.28 2.31 45.50
12145 174 A 11/17 1 0.45 2.02 54.50
12146 167 A 11/17 1 1.13 2.05 45.50
12148 167 E 11/18 1 0.43 2.27 55.50
12149 174 E 11/18 1 0.47 2.31 64.50
12154 174 E 11/18 1 0.97 2.23 64.50
12156 174 E 11/18 1 0.81 2.11 64.50
12160 174 E 11/19 1 0.68 2.22 64.50
12161 174 E 11/19 1 0.67 2.08 64.50
12162 181 E 11/19 1 0.95 2.01 70.50
12136 181 R 11/17 2 1.32 2.35 82.50
12137 181 R 11/17 2 0.75 1.73 82.50
12138 181 R 11/17 2 0.92 2.08 82.50
12141 181 R 11/17 2 0.46 2.26 82.50
12143 174 R 11/17 2 1.04 2.24 76.50
12147 181 A 11/18 2 0.90 2.01 60.50
12150 167 A 11/18 2 0.97 2.00 45.50
12151 181 A 11/18 2 0.49 2.08 60.50
12152 181 A 11/18 2 0.75 2.17 60.50
12153 167 A 11/18 2 0.30 3.22 45.50
12155 181 E 11/18 2 1.01 2.24 70.50
12157 181 E 11/19 2 0.84 2.34 70.50
12158 174 E 11/19 2 0.68 2.10 64.50
12159 181 A 11/19 2 0.58 2.33 70.50

HighLow

Analysis of QC Data Extreme Values
Top 5 (Highest) Bottom 5 (Lowest)
Friction Coefficient Torsion Strength Friction Coefficient Torsion Strength
1
2
3
4
5

Figure2.15

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost
12134 174 A 11/17 1 0.82 2.21 $ 54.50
12135 174 A 11/17 1 0.49 1.94 54.50
12139 174 A 11/17 1 0.52 2.03 54.50
12140 167 A 11/17 1 0.63 2.24 45.50
12142 167 A 11/17 1 0.64 2.28 45.50
12144 167 A 11/17 1 1.28 2.31 45.50
12145 174 A 11/17 1 0.45 2.02 54.50
12146 167 A 11/17 1 1.13 2.05 45.50
12148 167 E 11/18 1 0.43 2.27 55.50
12149 174 E 11/18 1 0.47 2.31 64.50
12154 174 E 11/18 1 0.97 2.23 64.50
12156 174 E 11/18 1 0.81 2.11 64.50
12160 174 E 11/19 1 0.68 2.22 64.50
12161 174 E 11/19 1 0.67 2.08 64.50
12162 181 E 11/19 1 0.95 2.01 70.50
12136 181 R 11/17 2 1.32 2.35 82.50
12137 181 R 11/17 2 0.75 1.73 82.50
12138 181 R 11/17 2 0.92 2.08 82.50
12141 181 R 11/17 2 0.46 2.26 82.50
12143 174 R 11/17 2 1.04 2.24 76.50
12147 181 A 11/18 2 0.90 2.01 60.50
12150 167 A 11/18 2 0.97 2.00 45.50
12151 181 A 11/18 2 0.49 2.08 60.50
12152 181 A 11/18 2 0.75 2.17 60.50
12153 167 A 11/18 2 0.30 3.22 45.50
12155 181 E 11/18 2 1.01 2.24 70.50
12157 181 E 11/19 2 0.84 2.34 70.50
12158 174 E 11/19 2 0.68 2.10 64.50
12159 181 A 11/19 2 0.58 2.33 70.50

Figure2.16

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost
12134 174 A 11/17 1 0.82 2.21 $ 54.50
12135 174 A 11/17 1 0.49 1.94 54.50
12139 174 A 11/17 1 0.52 2.03 54.50
12140 167 A 11/17 1 0.63 2.24 45.50
12142 167 A 11/17 1 0.64 2.28 45.50
12144 167 A 11/17 1 1.28 2.31 45.50
12145 174 A 11/17 1 0.45 2.02 54.50
12146 167 A 11/17 1 1.13 2.05 45.50
12148 167 E 11/18 1 0.43 2.27 55.50
12149 174 E 11/18 1 0.47 2.31 64.50
12154 174 E 11/18 1 0.97 2.23 64.50
12156 174 E 11/18 1 0.81 2.11 64.50
12160 174 E 11/19 1 0.68 2.22 64.50
12161 174 E 11/19 1 0.67 2.08 64.50
12162 181 E 11/19 1 0.95 2.01 70.50
12136 181 R 11/17 2 1.32 2.35 82.50
12137 181 R 11/17 2 0.75 1.73 82.50
12138 181 R 11/17 2 0.92 2.08 82.50
12141 181 R 11/17 2 0.46 2.26 82.50
12143 174 R 11/17 2 1.04 2.24 76.50
12147 181 A 11/18 2 0.90 2.01 60.50
12150 167 A 11/18 2 0.97 2.00 45.50
12151 181 A 11/18 2 0.49 2.08 60.50
12152 181 A 11/18 2 0.75 2.17 60.50
12153 167 A 11/18 2 0.30 3.22 45.50
12155 181 E 11/18 2 1.01 2.24 70.50
12157 181 E 11/19 2 0.84 2.34 70.50
12158 174 E 11/19 2 0.68 2.10 64.50
12159 181 A 11/19 2 0.58 2.33 70.50

Figure2.17

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost
12134 174 A 11/17 1 0.82 2.21 $ 54.50
12135 174 A 11/17 1 0.49 1.94 54.50
12139 174 A 11/17 1 0.52 2.03 54.50
12140 167 A 11/17 1 0.63 2.24 45.50
12142 167 A 11/17 1 0.64 2.28 45.50
12144 167 A 11/17 1 1.28 2.31 45.50
12145 174 A 11/17 1 0.45 2.02 54.50
12146 167 A 11/17 1 1.13 2.05 45.50
12148 167 E 11/18 1 0.43 2.27 55.50
12149 174 E 11/18 1 0.47 2.31 64.50
12154 174 E 11/18 1 0.97 2.23 64.50
12156 174 E 11/18 1 0.81 2.11 64.50
12160 174 E 11/19 1 0.68 2.22 64.50
12161 174 E 11/19 1 0.67 2.08 64.50
12162 181 E 11/19 1 0.95 2.01 70.50
12136 181 R 11/17 2 1.32 2.35 82.50
12137 181 R 11/17 2 0.75 1.73 82.50
12138 181 R 11/17 2 0.92 2.08 82.50
12141 181 R 11/17 2 0.46 2.26 82.50
12143 174 R 11/17 2 1.04 2.24 76.50
12147 181 A 11/18 2 0.90 2.01 60.50
12150 167 A 11/18 2 0.97 2.00 45.50
12151 181 A 11/18 2 0.49 2.08 60.50
12152 181 A 11/18 2 0.75 2.17 60.50
12153 167 A 11/18 2 0.30 3.22 45.50
12155 181 E 11/18 2 1.01 2.24 70.50
12157 181 E 11/19 2 0.84 2.34 70.50
12158 174 E 11/19 2 0.68 2.10 64.50
12159 181 A 11/19 2 0.58 2.33 70.50
29 0.76 2.19 $ 1,803.50
# of Skis Average Average Total Value

Figure2.18

Figure2.19

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 18 15
12135 174 A 11/17 1 0.49 1.94 54.50 6 28
12139 174 A 11/17 1 0.52 2.03 54.50 8 23
12140 167 A 11/17 1 0.63 2.24 45.50 10 10
12142 167 A 11/17 1 0.64 2.28 45.50 11 7
12144 167 A 11/17 1 1.28 2.31 45.50 28 5
12145 174 A 11/17 1 0.45 2.02 54.50 3 24
12146 167 A 11/17 1 1.13 2.05 45.50 27 22
12148 167 E 11/18 1 0.43 2.27 55.50 2 8
12149 174 E 11/18 1 0.47 2.31 64.50 5 5
12154 174 E 11/18 1 0.97 2.23 64.50 23 13
12156 174 E 11/18 1 0.81 2.11 64.50 17 17
12160 174 E 11/19 1 0.68 2.22 64.50 13 14
12161 174 E 11/19 1 0.67 2.08 64.50 12 19
12162 181 E 11/19 1 0.95 2.01 70.50 22 25
12136 181 R 11/17 2 1.32 2.35 82.50 29 2
12137 181 R 11/17 2 0.75 1.73 82.50 15 29
12138 181 R 11/17 2 0.92 2.08 82.50 21 19
12141 181 R 11/17 2 0.46 2.26 82.50 4 9
12143 174 R 11/17 2 1.04 2.24 76.50 26 10
12147 181 A 11/18 2 0.90 2.01 60.50 20 25
12150 167 A 11/18 2 0.97 2.00 45.50 23 27
12151 181 A 11/18 2 0.49 2.08 60.50 6 19
12152 181 A 11/18 2 0.75 2.17 60.50 15 16
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 25 10
12157 181 E 11/19 2 0.84 2.34 70.50 19 3
12158 174 E 11/19 2 0.68 2.10 64.50 13 18
12159 181 A 11/19 2 0.58 2.33 70.50 9 4
29 0.76 2.19 $ 1,803.50
# of Skis Average Average Total Value

Figure2.20

Analysis of QC Data Extreme Values
Top 5 (Highest) Bottom 5 (Lowest)
Friction Coefficient Torsion Strength Friction Coefficient Torsion Strength
1
2
3
4
5

Figure2.21

Analysis of QC Data Extreme Values
Top 5 (Highest) Bottom 5 (Lowest)
Friction Coefficient Torsion Strength Friction Coefficient Torsion Strength
1 1.32 3.22
2 1.28 2.35
3 1.13 2.34
4 1.04 2.33
5 1.01 2.31

Figure2.22

Analysis of QC Data Extreme Values
Top 5 (Highest) Bottom 5 (Lowest)
Friction Coefficient Torsion Strength Friction Coefficient Torsion Strength
1 1.32 3.22 0.30 1.73
2 1.28 2.35 0.43 1.94
3 1.13 2.34 0.45 2.00
4 1.04 2.33 0.46 2.01
5 1.01 2.31 0.47 2.01

Figure2.23

Quality Control Data for TZBlazer Skis
MFG ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Inspector ID Shipped
12134 174 A 11/17 1 0.82 2.21 A313 TRUE
12135 174 a 11/17 1 0.49 1.94 A328 FALSE
12139 174 A 11/17 1 0.52 2.03 B224 TRUE
12140 167 A 11/17 1 0.63 2.24 B224 TRUE
12142 167 A 11/17 1 0.64 2.28 AA313 TRUE
12144 167 A 11/17 1 1.28 2.31 A417 TRUE
12145 174 A 11/17 1 0.45 2.02 A313 TRUE
12146 167 AA 11/17 1 1.13 2.05 B313 TRUE
12148 167 E 11/18 1 0.43 2.27 C321 TRUE
12149 174 E 11/18 1 0.47 2.31 C321 TRUE
12154 174 E 11/18 1 0.97 2.23 A328 FALSE
# In style A - text 7
# Size 167 - numerical value 5
# Shipped - Boolean value 9
# sizes equal to value in cell F18 167 5
# > 1.0 FC 2
# from inspectors starting with A 6
# from inspectors with ID# with any letter followed by 313 3

Figure2.24

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 18 15
12135 174 A 11/17 1 0.49 1.94 54.50 6 28
12139 174 A 11/17 1 0.52 2.03 54.50 8 23
12140 167 A 11/17 1 0.63 2.24 45.50 10 10
12142 167 A 11/17 1 0.64 2.28 45.50 11 7
12144 167 A 11/17 1 1.28 2.31 45.50 28 5
12145 174 A 11/17 1 0.45 2.02 54.50 3 24
12146 167 A 11/17 1 1.13 2.05 45.50 27 22
12148 167 E 11/18 1 0.43 2.27 55.50 2 8
12149 174 E 11/18 1 0.47 2.31 64.50 5 5
12154 174 E 11/18 1 0.97 2.23 64.50 23 13
12156 174 E 11/18 1 0.81 2.11 64.50 17 17
12160 174 E 11/19 1 0.68 2.22 64.50 13 14
12161 174 E 11/19 1 0.67 2.08 64.50 12 19
12162 181 E 11/19 1 0.95 2.01 70.50 22 25
12136 181 R 11/17 2 1.32 2.35 82.50 29 2
12137 181 R 11/17 2 0.75 1.73 82.50 15 29
12138 181 R 11/17 2 0.92 2.08 82.50 21 19
12141 181 R 11/17 2 0.46 2.26 82.50 4 9
12143 174 R 11/17 2 1.04 2.24 76.50 26 10
12147 181 A 11/18 2 0.90 2.01 60.50 20 25
12150 167 A 11/18 2 0.97 2.00 45.50 23 27
12151 181 A 11/18 2 0.49 2.08 60.50 6 19
12152 181 A 11/18 2 0.75 2.17 60.50 15 16
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 25 10
12157 181 E 11/19 2 0.84 2.34 70.50 19 3
12158 174 E 11/19 2 0.68 2.10 64.50 13 18
12159 181 A 11/19 2 0.58 2.33 70.50 9 4
29 0.76 2.19 $ 1,803.50
# of Skis Average Average Total Value
# Rejected 2 2

Figure2.25

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 16 13
12135 174 A 11/17 1 1.94 54.50 26
12139 174 A 11/17 1 0.52 2.03 54.50 7 21
12140 167 A 11/17 1 0.63 2.24 45.50 9 8
12142 167 A 11/17 1 0.64 2.28 45.50 10 5
12144 167 A 11/17 1 1.28 45.50 26
12145 174 A 11/17 1 0.45 2.02 54.50 3 22
12146 167 A 11/17 1 1.13 2.05 45.50 25 20
12148 167 E 11/18 1 0.43 2.27 55.50 2 6
12149 174 E 11/18 1 0.47 2.31 64.50 5 4
12154 174 E 11/18 1 0.97 2.23 64.50 21 11
12156 174 E 11/18 1 0.81 2.11 64.50 15 15
12160 174 E 11/19 1 0.68 2.22 64.50 12 12
12161 174 E 11/19 1 0.67 2.08 64.50 11 17
12162 181 E 11/19 1 0.95 2.01 70.50 20 23
12136 181 R 11/17 2 1.32 82.50 27
12137 181 R 11/17 2 1.73 82.50 27
12138 181 R 11/17 2 0.92 2.08 82.50 19 17
12141 181 R 11/17 2 0.46 2.26 82.50 4 7
12143 174 R 11/17 2 1.04 2.24 76.50 24 8
12147 181 A 11/18 2 0.90 2.01 60.50 18 23
12150 167 A 11/18 2 0.97 2.00 45.50 21 25
12151 181 A 11/18 2 0.49 2.08 60.50 6 17
12152 181 A 11/18 2 0.75 2.17 60.50 14 14
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 23 8
12157 181 E 11/19 2 0.84 2.34 70.50 17 2
12158 174 E 11/19 2 0.68 2.10 64.50 12 16
12159 181 A 11/19 2 0.58 2.33 70.50 8 3
29 0.77 2.18 $ 1,803.50
# of Skis Average Average Total Value
# Rejected 2 2

Figure2.26

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 16 13
12135 174 A 11/17 1 1.94 54.50 26
12139 174 A 11/17 1 0.52 2.03 54.50 7 21
12140 167 A 11/17 1 0.63 2.24 45.50 9 8
12142 167 A 11/17 1 0.64 2.28 45.50 10 5
12144 167 A 11/17 1 1.28 45.50 26
12145 174 A 11/17 1 0.45 2.02 54.50 3 22
12146 167 A 11/17 1 1.13 2.05 45.50 25 20
12148 167 E 11/18 1 0.43 2.27 55.50 2 6
12149 174 E 11/18 1 0.47 2.31 64.50 5 4
12154 174 E 11/18 1 0.97 2.23 64.50 21 11
12156 174 E 11/18 1 0.81 2.11 64.50 15 15
12160 174 E 11/19 1 0.68 2.22 64.50 12 12
12161 174 E 11/19 1 0.67 2.08 64.50 11 17
12162 181 E 11/19 1 0.95 2.01 70.50 20 23
12136 181 R 11/17 2 1.32 82.50 27
12137 181 R 11/17 2 1.73 82.50 27
12138 181 R 11/17 2 0.92 2.08 82.50 19 17
12141 181 R 11/17 2 0.46 2.26 82.50 4 7
12143 174 R 11/17 2 1.04 2.24 76.50 24 8
12147 181 A 11/18 2 0.90 2.01 60.50 18 23
12150 167 A 11/18 2 0.97 2.00 45.50 21 25
12151 181 A 11/18 2 0.49 2.08 60.50 6 17
12152 181 A 11/18 2 0.75 2.17 60.50 14 14
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 23 8
12157 181 E 11/19 2 0.84 2.34 70.50 17 2
12158 174 E 11/19 2 0.68 2.10 64.50 12 16
12159 181 A 11/19 2 0.58 2.33 70.50 8 3
29 0.77 2.18 $ 1,803.50
# of Skis Average Average Total Value
# Rejected 2 2 $ 265.00

Figure2.27

Quality Control Data for TZBlazer Skis
Mfg ID# Size Style Date Manufactured Production Line Friction Coefficient Torsion Strength Ski Cost Rank Friction Coefficient Rank Torsion Strength
12134 174 A 11/17 1 0.82 2.21 $ 54.50 16 13
12135 174 A 11/17 1 1.94 54.50 26
12139 174 A 11/17 1 0.52 2.03 54.50 7 21
12140 167 A 11/17 1 0.63 2.24 45.50 9 8
12142 167 A 11/17 1 0.64 2.28 45.50 10 5
12144 167 A 11/17 1 1.28 45.50 26
12145 174 A 11/17 1 0.45 2.02 54.50 3 22
12146 167 A 11/17 1 1.13 2.05 45.50 25 20
12148 167 E 11/18 1 0.43 2.27 55.50 2 6
12149 174 E 11/18 1 0.47 2.31 64.50 5 4
12154 174 E 11/18 1 0.97 2.23 64.50 21 11
12156 174 E 11/18 1 0.81 2.11 64.50 15 15
12160 174 E 11/19 1 0.68 2.22 64.50 12 12
12161 174 E 11/19 1 0.67 2.08 64.50 11 17
12162 181 E 11/19 1 0.95 2.01 70.50 20 23
12136 181 R 11/17 2 1.32 82.50 27
12137 181 R 11/17 2 1.73 82.50 27
12138 181 R 11/17 2 0.92 2.08 82.50 19 17
12141 181 R 11/17 2 0.46 2.26 82.50 4 7
12143 174 R 11/17 2 1.04 2.24 76.50 24 8
12147 181 A 11/18 2 0.90 2.01 60.50 18 23
12150 167 A 11/18 2 0.97 2.00 45.50 21 25
12151 181 A 11/18 2 0.49 2.08 60.50 6 17
12152 181 A 11/18 2 0.75 2.17 60.50 14 14
12153 167 A 11/18 2 0.30 3.22 45.50 1 1
12155 181 E 11/18 2 1.01 2.24 70.50 23 8
12157 181 E 11/19 2 0.84 2.34 70.50 17 2
12158 174 E 11/19 2 0.68 2.10 64.50 12 16
12159 181 A 11/19 2 0.58 2.33 70.50 8 3
29 0.77 2.18 $ 1,803.50
# of Skis Average Average Total Value
# Rejected 2 2 $ 128.00

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