- Sales In 2017 Equipment Equipment Id January February March April May June July August September October November Decemb 1 (105.59 KiB) Viewed 90 times
sales per month in 2017. (Provide me with the excel formulas
used)
16. In cell D26, find the interquartile range per month in
2017. (Provide me with the excel formulas used)
17. In cells D27 through D31, find the five-number summary for
the sales per month in 2017. (Provide me with the excel formulas
used)
Sales in 2017 Equipment Equipment ID January February March April May June July August September October November December lls 1119 $ 1,741 $ 1,926 $ 1,812 $ 1.849 $ 2.208 $ 1,799 $ 1.819 $ 2,112 $ 1.829 $ 2.514 $ 2.023 $ 2,484 $ 24,116 als 1214 $ 1,286 $ 1,583 $ 1,711 $ 1,574 $ 1,687 $ 1,523 $ 1,573 $ 1,424 $ 1,669 $ 1,536 $ 1,632 $ 2,159 $ 19,357 ts 1182 $ 1,263 $ 1.368 $ 1.479 $ 1,357 $ 1,671 1.276 $ 1,493 $ 1,678 $ 1.157 $ 1,507 $ 1,529 $ 1,615 $ 17,393 cquets 1205 $ 1,046 $ 1.693 $ 1.938 $ 1,670 $ 1,895 $ 1.776 $ 1,608 $ 1.711 $ 1.856 $ 1,671 $ 1,907 $ 1,994 $ 20,765 ds and tackle 1206 $ 886 $ 1.214 $ 1,394 $ 1,174 $ 1.412 $ 1,291 $ 1,325 $ 1,373 $ 1.255 $ 1.448 $ 1,423 $ 1,534 $ 15,729 Lcks, bats and clubs 1195 $ 1,772 $ 1,761 $ 1,773 $ 1.927 $ 1,706 $ 2.290 $ 2,160 $ 2,556 $ 2.496 $ 2,161 $ 2.403 $ 2,592 $ 25,597 tal 7,994 $ 9,545 $ 10,107 $ 9,551 $ 10,579 $ 9,955 $ 9,978 $ 10,854 $ 10,262 $ 10,837 $ 10,917 $ 12,378 $ 122,957
$9.854.00 $10,184.50 24 15. In cells D24 and D25, find Q1 and Q3, respectively, for the sales per 25 month in 2017. 26 16. In cell D26, find the interquartile range per month in 2017. 17. In cells D27 through D31, find the five-number summary for the sales 27 per month in 2017. 28 $1,197.75 $7,994.00 $9,652.00 29 $ 10,184.50 30 $10,849.75 3 31 $12,378.00 32 18. In cell D32, find the standard deviation in sales per month in 2017. $1,046.53 33 19. In cell D33, find the variance in sales per month in 2017. $1,095,228.08