Estimate a logistic regression model using BUYER

Assignment Help Applied Statistics
Reference no: EM132276904

Assignment -

Instructions: There are two questions in this assignment. Answer the questions in docx using .sav file using SPSS.

Question 1: Customer Targeting Using RFM with Logical Breakpoints

In this question, you will explore RFM segmentation, a technique used to group customers according to their aggregate purchase history with a company. Specifically, look at how recently customers have purchased (R-recency), how often they have purchased (F - frequency), and how much they have spent (M - monetary) to target groups of customers that are most likely to buy "Art History of Florence".

Use the following mapping scheme to create the Recency, Frequency, and Monetary variables from the raw data provided.

Assign index values for R, F, and M based on logical breakpoints in the data. For this dataset, use the following breakpoints:

Recency


Frequency


Monetary

1-3 months

3 or more orders

$201 and up

4-6 months

2 orders

$101-$200

7-12 months

1 order

$51-$100

> 12 months


$26-$50


$1-$25

Use the above scores to outline segments that you would like to target for "Art History of Florence". Briefly outline how you would target these groups.

Question 2: Logistic Analysis and Customer Targeting

a. Estimate a logistic regression model using BUYER as the dependent variable and a set of independent covariates you think may be affecting buying decision.

b. Summarize and interpret the results (so that a marketing manager can understand them). Which variables are significant? Interpret the coefficients for each of the predictors.

c. Using the logistic analysis, outline segments of customers that you would like to target for "Art History of Florence."

d. Between RFM analysis (question 1) and logistic analysis, which method is better for customer targeting and why?

Please make sure to include screenshots for each step of RFM analysis and each step of logistic regression (5 screenshots total) with your submission.

Attachment:- Assignment Files.rar

Reference no: EM132276904

Questions Cloud

Baker has been assigned to research literature : Baker has been assigned to research the literature for a possible solution to a major operational problem at his employer.
Should it be classified as low-cost provider strategy : How would you characterize Best Buy’s competitive strategy? Should it be classified as a low-cost provider strategy?
Establish hrm strategies to improve competitive advantages : Analyze how the selected company can establish HRM strategies to improve competitive advantages.
What external environmental analysis data could be applied : What external and internal environmental analysis data could be applied to the marketing plan you are developing for your Final Project?
Estimate a logistic regression model using BUYER : Estimate a logistic regression model using BUYER as the dependent variable and a set of independent covariates you think may be affecting buying decision
Define how the information gleaned can be applied : For this discussion, you will examine market research strategies and how the information gleaned can be applied to the Marketing Mix section.
Define key marketing objectives in chosen hco strategic plan : MGMT 650 The information can be applied to the Introduction portion of the marketing plan for your Final Project. After reading Chapter 7 and reviewing.
What is franchise : What is a franchise? Can you think of a business that you frequent that is likely a franchise?
Discussed consumer markets and consumer buying behavior : This week, we discussed Marketing Information systems and marketing research. We also discussed Consumer Markets and Consumer Buying Behavior.

Reviews

len2276904

4/7/2019 10:36:31 PM

Instructions: Answer the questions in docx using .sav file using spss. There are two questions in this part of the exam worth 100 points. To answer these questions you need to use the file customer.sav (A book retailer is launching a new book “The Art History of Florence.” The retailer has historical data on customers and know what types of books the customers bought in the past. It also has some behavioral, demographic, and location information. Provide screenshots for each step of RFM analysis and each step of logistic regression (5 screenshots total).

len2276904

4/7/2019 10:36:25 PM

Evaluation Criteria and Grading Rubric - Question 1 on RFM (40%) - Clearly outlined steps with correct answers. Question 2 part A 10% - Provided an exhaustive list of variables with a sound written motivation of why a variable was included. Question 2 part B 15% - Outstanding write-up of model results. Highly managerially relevant. Question 2 Part C 20% - Clearly outlined steps with correct answers. Question 2 Part D 15% - Comparison of the model result is correctly done using data.

Write a Review

Applied Statistics Questions & Answers

  Interpret the meaning of the p-value

There evidence that the mean price is higher at Whole Foods Market than at the Fairway supermarket and interpret the meaning of the p-value in (a)

  Evaluation of technical quality

Synthesize the data and information and interpret it yourself based on the information you are learning about evidence for validity in this course.

  Explain how changes in debt equity ratio impact the beta of

e-education How does the Law of Conservation of Value (presented in the text) contrast with the first and second Propositions by Modigliani and Miller? Explain how changes in debt-equity ratio impact the beta of the firm's equity. Provide a mathemati..

  Determine the option price at time zero

Determine the option price at time zero by the Black-Scholes formula. That's what your customers pay and cumulative distribution function of the standard normal distribution function, satisfies the Black- Scholes PDE with the terminal condition fo..

  The united states has ten times the population of canada

The United States has ten times the population of Canada.  Assuming equal standard deviations, how many American teenagers must be sampled in order to estimate the true mean amount of time American teenagers spend on the internet per day to within 15..

  A variety of climbing and mountaineering equipment

A variety of climbing and mountaineering equipment.

  Analysis and the introduction od six sigma

Produce a short report to update your manager on both the method and results of your analysis and the introduction od 'Six Sigma'.

  At what value should the lowest passing score be set

At what value should the lowest passing score be set if the school wishes only 2.5 percent of those taking the test to pass?

  A particular department store knows from past experience

A particular department store knows from past experience that 17% of their customers have the store's credit card. What is the probability that out of the next 120 customers that at least 15% have the store's credit card? (please express your answer ..

  Create a histogram for iq and include normal distribution

Use Analyze, Descriptive statistics, Frequencies to summarize nonmetric variables, and create a pie-chart for Year in college and create a histogram for IQ and include the normal distribution.

  Construct a side-by-side boxplots for all meals

Construct a side-by-side boxplots for "all meals" and for each of the meal times sessions. How many potential outliers can be identified

  Create a frequency table for General Health Condition

Create a frequency table for General Health Condition (NHANES dataset). What proportion indicated that their health was better than fair

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd