Purchase Solution

Frequency Distribution Scenario for Motivating Buying Habits

Not what you're looking for?

Ask Custom Question

Scenario: Your boss has asked you to analyze the ages of your customers to get a better idea of what might motivate their buying habits. Outside research has shown that different age groups buy products for different reasons. And that different age groups buy different kinds of products. Your boss developed a survey that was sent to 200 of your customers and simply asked their age and income level. 124 customers responded and received a gift card for $25 towards their next purchase. See the Data section below for the raw data.
Requirement
Using Excel, create a frequency distribution (histogram) of the age data that was captured from the survey. You should consider the width of the age categories (e.g., 5 years, 10 years, or ??). Once you have created this histogram, determine the mean, median and mode.
Then write a report to your boss that briefly describes the results that you obtained. Make a recommendation on how this data might be used for marketing purposes.
Data: Download the Word file Case 2 Data.docx or the Excel-based data file Case 2 Data.xls with the data of ages of the 124 customers. Use this data in Excel to create your histogram.
Expectations
Analysis
• Accurate and complete analysis in Excel using the Histogram function.
Written Report
• Length requirements = 4-5 pages minimum (not including Cover and Reference pages)
• Provide a brief introduction/ background of the problem.
• Complete and accurate Excel analysis.
• Written analysis that supports Excel analysis, and provides thorough discussion of assumptions, rationale, and logic used.
Complete, meaningful, and accurate recommendation(s).

Attachments
Purchase this Solution
Solution Summary

This exercise shows how to use Excel to calculate histograms and descriptive statistics on a single variable.

Solution Preview

I am attaching the Excel spreadsheet into which I had the data and made the histogram and other calculations, as well as a .pdf file providing the ...

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • P & G Pet Food Launch in Mexico

    - Compare sales based on distribution point (high frequency shops vs. chain store) - Is campaign on budget? - Is campaign working within time line? - What are ideas for improvement?

  • Skew, coefficients of variation, class limits etc.

    What is the relative frequency of students with high interest? 2. Refer to the following information from a frequency distribution for heights of college women recorded to the nearest inch: The first two class midpoints are 62.5" and 65.5".

  • Probability, Statistics, and Data

    Given the class midpoints in the histogram below, create the corresponding grouped frequency distribution: From the graph height, we could figure out the frequency for each interval.

  • Exporting and Marketing our Mexican Sauce to Australia

    Finally, present ONLY ONE distribution objective and its corresponding strategy. =============================================================== PART B SCENARIO FOR PART B Making the sauce does not require a high degree of technological

  • Shopping Survey

    - To find out more about specific strengths and weaknesses of the areas, set up a frequency distribution for variable 10 (e.g., how many "best-fits" votes did each area get for "easy to return/exchange goods"?).

  • Relative Frequency of Smoking

    201797 Relative Frequency of Smoking A sample of individuals is selected, and the individuals are classified according to their smoking habits and the smoking habits of their parents. The results are given in the contingency table below.

  • Descriptive Statistics

    Show the frequency distribution B. Show the relative frequency distribution c. Show the cumulative frequency distribution. d. Show the cumulative relative frequency distribution.

  • target market in a foreign country

    Shopping habits includes information about the shopping needs, buying predilections and shopping habits of customers (Keegan. W, &. Green .M, 1997),.

  • Classic One-Way ANOVA

    Thank you for using BrainMass. This solution provides a null and alternative hypothesis for each scenario and conducts a statistical test and decide whether or not to accept or reject the null hypothesis.

View More Related Solutions