Question: Do our customers shop at work (most likely between 8:00 and 17:00) or at home? Ad Source Count of Amount Email 142 Web 368 Grand

Do our customers shop at work (most likely between 8:00 and 17:00) or at home?

Ad SourceCount of Amount
Email142
Web368
Grand Total510

Row LabelsAverage of Order Amount
Email$ 41.35
Web$ 37.85
Grand Total$ 38.83

RegionSum of Order Amount
East$4,227.87
North$2,988.07
South$4,551.83
West$8,033.84
Grand Total$19,801.61

Sum of Order AmountAd Source
Payment TypeEmailWebGrand Total
Credit$ 3,847.22$ 8,845.72$12,692.94
Paypal$ 2,024.29$ 5,084.38$ 7,108.67
Grand Total$ 5,871.51$13,930.10$19,801.61

Row LabelsSum of Order Amount
12 AM$ 956.44
1 AM$ 497.01
2 AM$ 267.99
3 AM$ 299.03
4 AM$ 284.47
5 AM$ 655.97
6 AM$ 423.92
7 AM$ 457.97
8 AM$ 454.55
9 AM$ 1,584.41
10 AM$ 1,288.61
11 AM$ 655.83
12 PM$ 927.29
1 PM$ 598.63
2 PM$ 1,288.51
3 PM$ 766.64
4 PM$ 2,002.56
5 PM$ 1,280.64
6 PM$ 1,118.40
7 PM$ 898.60
8 PM$ 2,167.56
9 PM$ 673.59
10 PM$ 252.99
Grand Total$ 19,801.61

Step by Step Solution

3.43 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Please use the formula IFANDHour8 Hour 17 Hour 8Home Bookl Microsoft Excel Home Page La... View full answer

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 Accounting Questions!