Assignment Overview
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.
Case Assignment
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.
Assignment 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).
Case 2 Data
Age Data from Survey Response
43 31 23 57
37 46 36 54
32 48 50 76
39 38 38 20
56 54 29 42
42 22 32 32
63 32 68 41
40 41 66 52
35 22 59 41
36 44 43 39
68 55 51 62
26 37 64 76
45 34 22 21
39 72 33 51
22 55 43 35
38 63 30 50
34 70 28 29
57 27 47 53
50 52 57 59
43 42 46 62
39 73 45 56
46 35 53 31
35 71 53 61
58 41 48 58
54 45 58 28
48 42 34 45
59 42 48 45
41 49 69 45
36 43 46 34
53 37 63 33
59 67 46 22
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!