Jj Davis Case Study

1675 Words7 Pages
This document consists of a summary of an exploratory data analysis for AJ Davis Department Stores. AJ Davis seeks to know more about their customers which pay via credit. We will assess the location, income, household size, years lived at household and credit balance. The following data shall serve as a sample of AJ Davis’ customer base: Income ($1000) 54 30 32 50 31 55 37 40 66 51 25 48 27 33 65 63 42 21 44 37 62 21 55 42 41 54 30 48 34 67 50 67 55 52 62 64 22 29 39 Credit Balance($) 4016 3159 5100 4742 1864 4070 2731 3348 4764 4110 4208 4219 2477 2514 4214 4965 4412 2448 2995 4171 5678 3623 5301 3020 4828 5573 2583 3866 3586 5037 3605 5345 5370 3890 4705 4157 3579 3890 2972 Location Urban Rural Suburban Suburban Rural Urban Rural Urban Suburban Urban Urban…show more content…
As AJ Davis appears to be motivated to learn about their customers who carry credit, all categories will compare to credit. Amount of Credit vs Income: The amount of credit and the income of the household appear to be related. Analysis reveals that as income increases, so too does the amount of credit. Note that this represents all households in all locations. Scatterplot of Credit Balance($) vs Income ($1000) 6000 5000 Credit Balance($) 4000 3000 2000 20 30 40 50 Income ($1000) 60 70 The following charts depict location as a factor in credit balance and income: Overlaid Locations: Scatterplot of Credit Balance($) vs Income ($1000) 6000 Location Rural Suburban Urban 5000 Credit Balance($) 4000 3000 2000 20 30 40 50 Income ($1000) 60 70 Individual Locations: Scatterplot of Credit Balance($) vs Income ($1000) 20 Rural 30 40 50 60 6000 5000 Suburban Credit Balance($) 4000 3000 2000 6000 5000 4000 3000 2000 20 30 40 50 Urban Income ($1000) 60 Panel variable:

More about Jj Davis Case Study

Open Document