STAT122 TS11 Subject

https://docs.google.com/spreadsheets/d/1elzJ91BOtkQA5YSC5fEq9pcQO_YYS-rv/edit?usp=sharing&ouid=104241546016050269610&rtpof=true&sd=true

This is the data or table to be able to answer 1-5. ^^

1. Which month of the year 2012 received the most number of orders?

2. Which order priority garnered the highest amount in sales?

3. Out of all the orders with "Low" order priority, how many were shipped via "Regular Air"?

4. How many orders exceeded a sales amount of $5000?

5. Based on your answer in number 3, create a formula in the "Expanded Order Type" column to assign the correct type to each order by "Order Quantity." Copy the formula down to all the rows. Then, using this column, calculate the total "Sales" for all orders of "Medium-Large" type (rounded to 2 decimal places).

If done correctly, will leave a thumbs up and a positive comment. thank you in advanced!