+ Reply to Thread
Results 1 to 2 of 2

interrogating large data sets

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Question interrogating large data sets

    The worksheet has 150 data like this

    Please Login or Register  to view this content.
    Here is the task I have to do.

    Task Five - Interrogating large data sets

    You own a fast food restaurant and have do5ne some market research in an attempt to better
    understand your customers. For a random sample of customers, you are given the income, gender,
    and number of days per week that they go out for fast food.

    5.1 Use this information to determine how gender, income and the two combined influence the
    frequency with which a person goes out to eat fast food.

    5.2 Briefly discuss how you might plan your marketing based on this information. Consider the
    profile of you best customers and how you might target potential new customers?

    so far i thought of making tables for different age groups like 20-30, 30-40 for men and women. but what sort of chart should i use - pie, column, bar? and when i make charts then what? i have no idea.
    Last edited by ruleworld; 01-04-2011 at 10:08 AM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010

    Re: need some idea where to start

    This isn't really an Excel question, more a general stats one. If you really have no clue where to start you should speak to your tutor.
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1