Question: 4 2 4 3 4 4 4 5 4 6 4 7 4 8 4 9 5 0 5 1 5 2 5 3 5

42
43
44
45
46
47
48
49
50
51
52
53
54
\table[[5,ANSWER THE QUESTIONS GIVEN BELOW,ENTER HERE],[56,1) What is the Total Number of Units sold from Jan to May?,],[57,2) What is the Average Number of units sold in 1st Quarter of 2023?,],[58,3) On how many days (count) were sales made?,],[59,4) On above sales days, what was the minimum number of units sold,],[60,5) On above sales days, what was the maximum number of units sold,],[61,6) What was the total number of units sold in Feburary,],[62,7) What was the average number of units sold in May?,],[63,8) What percentage of total sales were made in May?,],[64,9) How many unit sales were made in "Atlantic US" Sales region?,],[65,10) What percentage of total sales were made in Central US region?,]]
(Tip: Use COUNTIF formula)
On how many days were unit sales of more than 1500 units made only
67 in the Central US region?
(Tip: Use COUNTIFS formula)D17
\table[[18,Order Date,Customer,Region,Sales Region,Units],[19,1/4/2023,AAIA,Alaska,Pacific US,876],[20,1/7/2023,BJAC,Germany,Europe,1001],[21,1/12/2023,HIFI,Hawai'i,Pacific US,3200],[22,1/17/2023,JCRI,Georgia,Atlantic US,975],[23,1/19/2023,WIMC,Wisconsin,Central US,716],[24,1/22/2023,WA4G,Washington,Pacific US,4000],[25,1/23/2023,AU9S,Austria,Europe,2000],[26,1/23/2023,MITA,Massachusetts,Atlantic US,6286],[27,1/24/2023,MAPO,Massachusetts,Atlantic US,1400],[28,1/31/2023,FL95,Florida,Atlantic US,1832],[29,2/1/2023,CASF,California,Pacific US,1205],[30,2/2/2023,OHMY,Ohio,Central US,6003],[31,2/4/2023,GAAT,Georgia,Atlantic US,4000],[32,2/8/2023,TREX,Texas,Central US,4900],[33,2/12/2023,PDOK,UK,Europe,1765],[34,2/14/2023,BJAC,Germany,Europe,267],[35,2/16/2023,CDFM,California,Pacific US,1000],[36,2/22/2023,ILUI,Ohio,Central US,1600],[37,2/23/2023,GAOM,Georgia,Atlantic US,2000],[38,2/24/2023,AAJA,Alaska,Pacific US,3000],[39,3/7/2023,MIMC,Michigan,Central US,500],[40,3/7/2023,DMGR,Germany,Europe,1700],[41,3/12/2023,AKFS,Alaska,Pacific US,1800],[42,3/17/2023,NCST,North Carolina,Atlantic US,1503]]
Please include the formulas so I can learn the steps properly. Thank you so much!
4 2 4 3 4 4 4 5 4 6 4 7 4 8 4 9 5 0 5 1 5 2 5 3 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!