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 Total	510

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

Region	Sum 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 Amount	Ad Source
Payment Type	Email	Web	Grand 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 Labels	Sum 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

Answer rating: 100% (QA)

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