Quality Control Data Ski Bindings Pressure Test (Lbs) 11/1/16 10:26 0.745 11/1/1
ID: 3069903 • Letter: Q
Question
Quality Control Data Ski Bindings Pressure Test (Lbs) 11/1/16 10:26 0.745 11/1/16 10:3316.123 11/1/16 104010,484 11/1/16 10:47 1.042 11/1/16 10:54 10.001 11/1/16 1102 11.531 9.998 11/1/16 11 1610,322 9.999 11/1/16 113010.510 11/1/16 1138 10.001 11/1/16 1145 10,424 11/1/16 11:52 10.098 9.995 11/1/16 1206 13.002 11/1/16 12:14 0.120 3839 211/1/16 1221 10.566 10.130 3841 2 11/1/16 12:35 10.559 11/1/16 12:42 10.399 11/1/16 1250 10.002 11/1/16 12:5710.389 11/1/16 13:04 10.313 11/1/16 13:1110.149 10.002 11/1/16 1326 10.010 Failure ID#-Type Date/Time Temperature oCValue 66.6 -69.9 68.4 68.7 -66.0 66.4 68.3 33.59 33.58 41.05 33.54 33.56 3824 3827 1 11/1/16 11:09 33.54 33.56 33.62 3831 11/1/16 11-23 3832 -68.0 58.9 3836 3837 1 11/1/16 11:59 64.08 3840 2 11/1/16 1228 63.13 64.02 64.07 64.07 3842 2 69.3 38432 3845 2 3847 2 11/1/16 13:18 3849 2 3851 3 68.1 66.0 66.7 11/1/16 13.33 0.16 55.22 11/1/16 1340 10.525 11/1/16 13:47 10.002 11/1/16 13:54 11.497 11/1/16 140211.637 3854311/1/16 14:09 10.832 9.998 11/1/16 1423 10.627 11/1/16 14:3010.846 11/1/16 14:38 2.267 9.997 3860 311/1/16 14:52 10.405 3861 311/1/16 14:59 11.792 11/1/16 150610.814 11/1/16 15:1410.239 11.010 11/1/16 15.28 10.190 11.047 10.765 66.6 68.5 22.16 66.0 66.5 68.6 1/1/16 14:16 22.08 3857 3 3859 3 11/1/16 14:45 69.1 40.02 66.0 66.6 66.0 -69.0 27.42 27.42 27.42 92.06 92.12 92.07 92.06 11/1/16 15:21 11/1/16 15:35 3867 3 11/1/16 15:42 66.8Explanation / Answer
2. The formula written in G3 that can be copied down the column to give the relative ranking of the highest pressure is
=RANK(C3,$C$3:$C$47,0)
The formula written in H3 that can be copied down the column to give the relative ranking of the coldest temperature is
=RANK(D3,$D$3:$D$47,1)
3.The formula to determine the number of ski bindings pressure that failed to meet the minimum pressure requirements to be weritten in D49 is
=COUNTIF(C3:C47,"<10")
4.The formula to determine the number of ski bindings pressure that failed to meet the minimum temperature requirements to be weritten in E49 is
=COUNTIF(D3:D47,">-59")
5.The formula to determine the number of ski bindings that have been rejected to be written in F49 is
=SUMIF(D3:D47,">-59",E3:E47)
6.
8.The formula to calculate the highest pressure that it will be automatically updated even if the data is changed later. And when this formula is copied down the column gives the second highest and third highest and so on. And when copied down the column gives highest temperature.
=LARGE(C$3:C$47,ROW(2:2))
9.The formula to calculate the lowest pressure that it will be automatically updated even if the data is changed later. And when this formula is copied down the column gives the second lowest and third lowest and so on .And when copied down the column gives lowest temperature
=SMALL(C$3:C$47,ROW(1:1))
Formula Sheet
TOP 5(Highest) Bottom 5(Lowest) Pressure Temperature Pressure Temperature 1 16.123 -58.9 9.995 -70.6 2 13.002 -59.7 9.997 -69.3 3 12.267 -65.5 9.998 -69.3 4 11.792 -66 9.998 -69.2 5 11.637 -66 9.999 -69.2