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
tableANSWER THE QUESTIONS GIVEN BELOW,ENTER HERE What is the Total Number of Units sold from Jan to May?, What is the Average Number of units sold in st Quarter of On how many days count were sales made?, On above sales days, what was the minimum number of units sold, On above sales days, what was the maximum number of units sold, What was the total number of units sold in Feburary, What was the average number of units sold in May?, What percentage of total sales were made in May?, How many unit sales were made in "Atlantic US Sales region?, 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 units made only
in the Central US region?
Tip: Use COUNTIFS formulaD
tableOrder Date,Customer,Region,Sales Region,UnitsAAIA,Alaska,Pacific USBJAC,Germany,Europe,HIFI,Hawai'i,Pacific USJCRI,Georgia,Atlantic USWIMC,Wisconsin,Central USWAGWashington,Pacific USAUSAustria,Europe,MITA,Massachusetts,Atlantic USMAPO,Massachusetts,Atlantic USFLFlorida,Atlantic USCASF,California,Pacific USOHMY,Ohio,Central USGAAT,Georgia,Atlantic USTREX,Texas,Central USPDOK,UKEurope,BJAC,Germany,Europe,CDFMCalifornia,Pacific USILUI,Ohio,Central USGAOM,Georgia,Atlantic USAAJA,Alaska,Pacific USMIMC,Michigan,Central USDMGRGermany,Europe,AKFS,Alaska,Pacific USNCSTNorth Carolina,Atlantic US
Please include the formulas so I can learn the steps properly. Thank you so much!
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
