business driven information system course

10 just the hour instead of hour and minutes. In other words =hour(G8). Then use an "if" formula to create a value of either day (time between 8:00 and 17:00) or night (not between 8:00 and 17:00). PART 2 - Analysis (10 MARKS) Now let's test your ability to think critically. This is also a small writing assignment. Our company's approach has been to divide advertising efforts evenly between web banner ads and email ads, and to give each region equal levels of resources. Requirement 4: What are the weaknesses to this approach? (5 MARKS) Requirement 5: What changes would you suggest to our advertising plan? (5 MARKS) For example, should we stop all advertising in the North? Concentrate on web banner ads of books in the South? Stop using Paypall? Write your answer in paragraph form. Be sure to include all pivot tables or other charts that you used to help make this decision. I Grade for Part Two of this homework will be based on: correctly identifying the problem, identifying any assumptions, quality supporting data, clarity of conclusions. ada) Focus A B C D Count of Region 286 224 510 1 2 3 Row Labels 4 Home 5 Work 6 Grand Total 7 8 9 10 11 12 13 14 fx A B C DE F Count of Region 322 188 510 1 2 3 Row Labels 4 Credit 5 Paypal 6 Grand Total 7 8 9 10 11 12 13 14 15 16 Jx !!! B C NA D Average of Amount 41.86 32.48 42.94 38.08 38.82668627 A 1 2 3 Row Labels 4 East 5 North 6 South 7 West 8 Grand Total 9 10 11 12 13 14 15 16 17