Module 2:
Module 2 – Case INSTRUCTIONS
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.xlsx 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).
The PIVOT Table and paper that you completed for me approxamatly 3 weeks ago was outstanding. Please do the same here. Thanks writer 369459
Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted rate
You May Also Like This:
- Risk: Frequency Distribution, Probabilities, and Expected Value SLP
- Frequency Distribution, Probabilities, and Expected Value SLP
- forecasting of sales
- Analysis / Forecasting Data
- EXPONENTIAL SMOOTHING FORECASTING AND VALUE OF INFORMATION
- BUS520-CASE4
- thread 1
- Determining the Posterior probabilities of Favorable and Unfavorable Markets for the Real Estate business
- Quantitative Methods for Risk Analysis
- Strategic Management Case
- Bottling Company Case Study
- Ranking and treating risk
- Social Media As Credible Marketing & Distribution tool in hospitality industry
- 1.Suppose a company’s $50 stock pays an 8% continuous dividend and the continuously compounded risk-free rate is 6%.
- most common file types imported into Excel
- Management Data Analysis / Survey ( basic concepts of probability and statistical analysis )Global Business Management
- Case 21.2 Kasten v. Saint-Gobain Performance Plastics Corp
- Population At Risk(Pregnant Women at Risk In Maryland)
- DERIVATIVES AND RISK MANAGEMENT
- Adult Daycare Facility branding, pricing, and distribution strategy
- Frequency Distributions
- Job Satisfaction
- Netflix Case Analysis
- orld’s resources to achieve sustainability and equitable distribution at the personal, professional, and global level.
- Suppose the gold spot price is $1700/oz, the 1-year forward price is 1760.54, and the continuously compounded risk-free rate is 4%.
- Risk analysis
- NR601 Week 2: COPD Case Study Part 2 What is your primary (one) diagnosis for this patient at this time? (support the decision for your diagnosis with pertinent positives and negatives from the case)
- NR601 Week 2: COPD Case Study Part 1 Briefly and concisely summarize the history and physical (H&P) findings as if you were presenting it to your preceptor using the pertinent facts from the case.
- Cardillo Travel Systems case
- Security and Risk Management