fbpx

Analyzing the case | Business & Finance homework help

Don't use plagiarized sources. Get Your Assignment on
Analyzing the case | Business & Finance homework help
Just from $13/Page
Order Now

 

ANALYZING THE CASE ASSESSMENT EXHIBIT 1

Please use the following to decode the data set:

Amount:

Product customer bought our weedkiller product

1–2 times this year = 1
3–4 times this year = 2
5+ times this year = 3

Store:

Bought product primarily at:

Garden Specialty Store = 1
Mass Merchandiser = 2
Big Box = 3
Other = 4

Type:

Ready To Use = 1 (nets $1.00 profit each)
Concentrate = 2 (nets $2.00 profit each)

Age:

21–30  = 1
31–40  = 2
41–50  = 3
51–60  = 4
61–70  = 5
71–over = 6

Gender: 

Male = 0
Female = 1

Marital Status: 

Single/Divorced/Widowed = 0
Married = 1

Household Income:

$0–50,000 = 1        
$50,001–75,000 = 2        
$75,001–100,000 = 3        
$100,001–125,000 = 4  
$125,001–150,000 = 5        
$150,001+ = 6

Purchases within last year: 

1 = yes
0 = no

Car                Home                Boat                          

Living: 

Home under 1 acre = 1
Home over 1 acre = 2      

Activities engaged in within last year: 

1 = yes
0 = no

Gardening    Participant Sports    Spectator Sports    Nature    Home DIY

Profile Areas: 

1 = yes
0 = no

Smoker         Pet Lover         Health Conscious         Gourmet Cook

Throughout the course, you have examined and applied data mining strategies and tools. Now, imagine you are the Vice President of Marketing for a consumer weed killer brand. The raw data in the Analyzing the Case Assessment Data Set (linked in the Resources, under the Required Resources heading) has been gathered by your marketing research staff.

For this assessment, integrate your learning into an analysis of this product by completing the following:

  • Examine the Analyzing the Case Assessment Data Set linked in the Resources. This data set represents a sample of 100 customers of a weed killer product.
    • Note: The definitions of the columns in the file are those contained in Analyzing the Case Assessment Exhibit 1, also linked in the Resources under the Required Resources heading.
  • Develop a pivot table that summarizes customer profitability along other meaningful dimensions.
    • Explain how you are defining profitability.
    • What does this pivot table tell you?
  • Use regression analysis to see whether any attributes can be used to predict customer account profitability.
    • What is the best model you can develop?
    • What does it tell you in regard to identifying profitable customers?
  • What additional data would you want, in order to complete your analysis of customer profitability before any marketing? Explain why that data would be useful.
    • Identify additional data needed to support global management decisions.
    • Make a recommendation supported by information from your analyses and any other arguments you can logically support.
      • Who is the top target?
      • What type of retail stores would you expand?
      • How would you develop a communications plan?

Additional Requirements

Your report should contain the following elements:

  • Proper memorandum format.
    • Note: Several appropriate templates are provided in Microsoft Word.
  • Short introductory paragraph stating the purpose of the memo.
  • Brief concluding paragraph.
  • The following subdivisions (at minimum):
    • A profitability analysis, explaining how you define profitability and the dimensions by which you categorize customer groups. Use statistical analysis software to develop a pivot table for meaningful data analysis. Include your pivot table in your report as an appendix.
    • Your regression analysis results and interpretation. (Use statistical analysis software to develop a representative regression model.)
    • A discussion of additional data needed, and your rationale for using that data. (Assess the content and usefulness of internal data stores. Analyze data sources in internal organizational databases and identify additional data needed to support global management decisions.)
    • Present a business decision recommendation based on the results of statistical analysis.
    • Present results of analysis in a concise and compelling manner using effective communication strategies and appropriate business terms.

Recent Blog Posts

No recent articles to show.

Other Blog Posts

What are the key elements of an essay

You may clearly understand what an essay is and have had the experience of writing a number. However, it is […]

Feb 25th, 2022

How to write a research paper fast

The day inevitably comes; you need to submit your assignment. You have been procrastinating on writing your paper until the […]

Feb 24th, 2022

220+ best humanities research paper topics

Choosing a paper topic can be a daunting task for any assignment. A student may face agony trying to come […]

Feb 24th, 2022

How to write a media analysis essay

The media is an integral part of modern society. Think of what would happen to the world if there were […]

Feb 23rd, 2022

Great tricks on how to write a hypothesis in 2022

A hypothesis is a statement that can be proven by scientific research. It proves the theory of action and reaction, […]

Feb 22nd, 2022

How to get better at math

Math is not difficult. However, it is complex and tough compared to other subjects and requires a little bit more […]

Feb 22nd, 2022