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 Source | Count of Amount |
| 142 | |
| Web | 368 |
| Grand Total | 510 |
| Row Labels | Average of Order Amount |
| $ 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 | 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 |
Step by Step Solution
3.43 Rating (156 Votes )
There are 3 Steps involved in it
Please use the formula IFANDHour8 Hour 17 Hour 8Home Bookl Microsoft Excel Home Page La... View full answer
Get step-by-step solutions from verified subject matter experts
