Path: blob/master/april_18/projects/unit-projects/project-4/assets/project4-Example.ipynb
1905 views
Project 4 Example
Intro: Write a problem Statement/ Specific Aim for this project
Answer: Using Planet Express customer data from January 3001-3005, determine how likely previous customers are to request a repeat delivery using demographic information (profession, company size, location) and previous delivery data (days since last delivery, number of total deliveries).
Dataset: Write up a description of your data and any cleaning that was completed.
Answer: There were 525 deliveries in our dataset. There were 25 observations with missing data that were dropped from this analysis. The final analytic sample was 500. This data was collected from January 3001-3005.
There were three common professions- Account Manager, Warehouse Manger, and Alien Intake. All others were combined into a fourth category: Other.
Similarily there were 4 locations in this data set which had 20 or more deliveries; they were included in this analysis while all others were grouped into the "Other" category. "Days since last delivery" and "number of deliveries" are continuous variables ranging from 0-360 days and 1-100 deliveries, respectively.
Provide a table that explains the data by admission status
| Variable | Description | Type of Variable |
|---|---|---|
| Profession | Title of the account owner | categorical |
| Company Size | 1- small, 2- medium, 3- large | categorical |
| Location | planet of the company | categorical |
| Days Since Last Delivery | integer | continuous |
| Number of Deliveries | integer | continuous |
Mean (STD) or counts for 2 of the 4 variables
| Variable | Mean (STD) or Frequency (%) |
|---|---|
| Number of Deliveries | 50.0 (10) |
| Earth | 50 (10%) |
| Amphibios 9 | 100 (20%) |
| Bogad | 100 (20%) |
| Colgate 8 | 100 (20%) |
| Other | 150 (30%) |
Methods: Write up the methods used in your analysis
Answer: We completed a logistic regression using Statsmodels v. XX. We calculated the probability of a customer placing another order with Planet Express.
Results: Write up your results
Customers from large companies had 2.0 (CI 1.9, 2.1) the odds of of placing another order with Planet Express compared to customers from small companies.
Discussion: Write up your discussion and future steps
Our findings indicate that customers have a higher probability of returning if they are from a large company. Next steps could include exploring the difference by statisfaction levels, as measured by a survey.