Watch the instructional video attached here Video [+].

Open the attached Excel sheet stats_2.xlsx [+].

Sort as needed to answer the following questions:

1) What was the most recent order date for an order from LEWIS AND CLARK county in the Economy category?  Give answer as MM/DD/Year For example 03/20/2013

2) What was the sample standard deviation in the quantity ordered from Lewis and Clark county in the Economy category?  

3) For Online orders from the city of Richey, what was the highest Quantity ordered?  

4) What was the average profit from Joliet?  

 

License