# Analyze some Data

Instructions

Please read the attached case study and answer the following questions (you do not need to answer the questions from the case study). Please explain all your answers in details, otherwise no point will be given. You also need to upload all the excel files where you have done data analysis, this is a mandatory requirement.

1. If you do not do any choice modeling, then which top 20% customers will you target from the main sample? Why?

2. a) Now develop an Ordinary linear regression model using the main sample data. Based on the regression output which top 20% customers will you choose? Assume that the only decision variable in this regard is the choice probability. Also, in simple English clearly interpret your regression output, do not use any mathematical jargon while interpreting.

b) Further develop a Logistic regression model and and re-do question 2a. How is your answer different from 2a?

c) Now, in question 2b assume that the decision variable is expected revenue instead of only choice probability. How would your answer change from 2b?

3.a) Now apply your regression model from 2a to holdout sample. Choose top 20% customers in terms of i) choice probability and ii) expected revenue.

b) Now, instead of applying the regression model from 2a, develop an original linear regression model using the data from the holdout sample. How would your answers differ from 3a (i) and 3a (ii)?

c) If you are the Marketing manager of the BBB club, in order to work target the customers from the holdout sample will you develop an original regression model? Or can you rely on the regression model developed from the main sample and just apply the equation in the holdout sample context?

Skills: Data Processing, Excel, Word

About the Employer:
( 0 reviews ) Romania

Project ID: #11823394

## 11 freelancers are bidding on average \$67 for this job

citijayamala

Expert in Excel, Excel formulas, and all excel functions, macros, lookup concepts. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Can complete on time with More

\$150 USD in 3 days
(24 Reviews)
4.3
adgotmare

A proposal has not yet been provided

\$250 USD in 8 days
(6 Reviews)
3.1
\$40 USD in 1 day
(2 Reviews)
2.8
lramanathan

Being a certified six sigma black belt backed with strong expertise in statistical data analysis, I am well placed to take up this assignment. I have done many analysis based on regression and statistical models.

\$111 USD in 1 day
(1 Review)
1.8
thinkitltd4

see this fo ile.i can do.

\$15 USD in 1 day
(1 Review)
0.0
Abhi339

i THINK THE TYPE OF GUY YOU ARE LOOKING FOR IS RIGHT BEFORE YOU. I AM EXPERT AT MY JOB. AND I REST IS ONE YOU .

\$25 USD in 1 day
(0 Reviews)
0.0
vw1313054vw

I will deliver a satisfactory job that will impress you. I crave for a chance to prove to you my worth and abilities.

\$25 USD in 1 day
(0 Reviews)
0.0
emokaya32

I am a PhD student pursuing doctoral studies in statistics. Previously, I graduated with a M.Sc. (Statistics) and earlier on I had finished my B.Ed. (Sciences) majoring in Double Mathematics from university. Among the More

\$25 USD in 1 day
(0 Reviews)
0.6
yasir5723

A proposal has not yet been provided

\$30 USD in 2 days
(0 Reviews)
0.0
lamesmhmd2

A proposal has not yet been provided

\$20 USD in 1 day
(0 Reviews)
0.0
dch5745f77fe1aef

i m very good at mathematics nd i can do very well in analysing tha data and i can assur u wont regret aftr seeing my work thank you

\$50 USD in 5 days
(0 Reviews)
0.0