2.4 Memo Problem: Carnivorous Cruise Lines, Part 2

To: Analysis Staff
From: Marketing Director
Date: May 15, 2008
Re: RFP from Ms. Way

The marketing team wants some further details for the proposal we developed for Ms. Way regarding the possible issues with entertainment at Carnivorous Cruise Lines. So here is what I want you to do:

  1. Design data collection forms that I can include in the final proposal. These forms might be questionnaires, attendance counts, sales figures, however you are proposing to go about collecting data.
  2. Develop a spreadsheet for each different type of data collection form and enter some test data (maybe 15 observations; you shouldn’t go overboard, but you should do enough to ”show off” the range of values of your variables). Since you have more than one spreadsheet, put them all in one workbook with individual, relevant names, so that I don’t overlook them.
  3. Include comments below your data on the spreadsheet that
    1. Provide explanations for any codes you are using (where appropriate) and
    2. Give the units of your variables when they are not obvious.
  4. All data collection forms and their accompanying spreadsheets must be incorporated into a Microsoft Word document and sent to me.
  5. Just under your mockup data in the spreadsheet, list each variable and identify the type of data, e.g. nominal categorical, discrete continuous, etc.