Question

Calculate the standard deviation of the Days in Inventory for the cars in the sample.

Answer format: ##.##

? =STDEV.S(DATA!F2:F31)

Sample Car # Suggest Retail Option Price Days in Inventory Package Color Grey Grev Blue Black Blue Blue Red MPG 27.6 $ 24,390.00 LX 32.4 $ 21,780.00 Touring 33.2 21,149.00 Touring 34.7 22,069.00 LX 27.2$ 22,532.00 Touring 26.6 $ 20,345.00 Touring 37.3$ 22,112.00 EX 34.9 $ 21,289.00 Touring 29.6$ 24,871.00 LX 32.3 25,389.00 EX 31.9$ 25,998.00 EX 26.4$ 19,713.00 LX 34.8$ 25,213.00 EX 35.9$ 24,467.00 Touring 34.6 $ 21,402.00 LX 33.3 20,351.00 LX 33.1$ 23,732.00 Touring 37.5$ 24,558.00 Touring 27.8$ 19,167.00 LX 36.1$ 19,903.00 Touring 28.8 $ 22,140.00 Touring 26.2|$ 22,180.00|EX 27.4 $ 23,120.00 Touring 34.9 $ 19,837.00 Touring 36.5$ 24,666.00 EX 26.3$ 19,446.00 EX 31.4 $ 23,954.00 Touring 30.9 21,201.00 LX 27.4$ 21,346.00 EX 10 28 21 16 4 Silver Silver Silver 12 23 15 Grey 12 Red Black 28 13 Silver Black 16 Black Grey 18 Red 19 Red 20 Red Blue 22 Red 15 17 17 18 21 19 Silver 24 Black 25 Red 26 Red 27 28 29 Red 30 Red 21 31 35 Blue Blue 26 31 36 $ 19,406.00 EX

Answer 1