Excel Project Assignments | Online Homework Help

ANSWER THE QUESTIONS IN EXCEL CHART

1) What is   the Total Number of Units sold from Jan to May?

2) What is   the Average Number of units sold from Jan to May?

3) On how   many days (count) were sales made?

4) On above   sales days, what was the minimum number of units sold

5) On above   sales days, what was the maximum number of units sold

6) What was   the total number of units sold in Feburary

7) What was   the average number of units sold in March

8) What   percentage of sales were made in May?

9) How many   unit sales were made in “Atlantic US” Sales region?

10) What   percentage of total sales were made in Central US region?

11) On how   many days were unit sales of more than 1500 made?

12) On how   many days were unit sales of less than 1000 units made?

MKTG3808 – Prof. Hazari

Order Date Customer Region Sales Region Units
1/2/2018 AAJA Alaska Pacific US 735
1/7/2018 BJAC Germany Europe 1000
1/12/2018 HIFI Hawai’i Pacific US 3200
1/17/2018 JCRI Georgia Atlantic US 975
1/19/2018 WIMC Wisconsin Central US 716
1/22/2018 WA4G Washington Pacific US 4000
1/23/2018 AU9S Austria Europe 2000
1/23/2018 MITA Massachusetts Atlantic US 6275
1/24/2018 MAPO Massachusetts Atlantic US 1400
1/31/2018 FL95 Florida Atlantic US 1325
2/1/2018 CASF California Pacific US 1205
2/2/2018 OHMY Ohio Central US 7000
2/4/2018 GAAT Georgia Atlantic US 4000
2/8/2018 TREX Texas Central US 4900
2/12/2018 PDOK UK Europe 1765
2/14/2018 BJAC Germany Europe 200
2/16/2018 CDFM California Pacific US 1000
2/22/2018 ILUI Ohio Central US 1600
2/23/2018 GAOM Georgia Atlantic US 2000
2/24/2018 AAJA Alaska Pacific US 3000
3/7/2018 MIMC Michigan Central US 500
3/8/2018 DMGR Germany Europe 1700
3/12/2018 AKFS Alaska Pacific US 1800
3/17/2018 NCST North Carolina Atlantic US 1500
3/28/2018 OKOK Arkansas Central US 1350
3/29/2018 FLMI Florida Atlantic US 1700
3/30/2018 ARKS Arkansas Central US 3650
4/2/2018 SWX2 Switzerland Europe 1500
4/7/2018 MAPO Massachusetts Atlantic US 750
4/9/2018 ATTX Texas Central US 1000
4/12/2018 SPTR Hawai’i Pacific US 2100
5/1/2018 SWX1 Switzerland Europe 1600
5/7/2018 HV11 Switzerland Europe 2000
5/9/2018 S2SC Tennessee Atlantic US 2050
5/9/2018 ORRC Washington Pacific US 2100

ANSWER THE QUESTIONS GIVEN BELOW ENTER HERE
1) What is the Total Number of Units sold from Jan to May?
2) What is the Average Number of units sold from Jan to May?
3) On how many days (count) were sales made?
4) On above sales days, what was the minimum number of units sold
5) On above sales days, what was the maximum number of units sold
6) What was the total number of units sold in Feburary
7) What was the average number of units sold in March
8) What percentage of sales were made in May?
9) How many unit sales were made in “Atlantic US” Sales region?
10) What percentage of total sales were made in Central US region?
11) On how many days were unit sales of more than 1500 made? (Tip: Use COUNTIF formula)
12) On how many days were unit sales of less than 1000 units made? (Tip: Use COUNTIF formula)