Question
Provide an overview of the credit card customers by finding the descriptive statistics of each variable (each variable separately). In descriptive statistics, you may find
Provide an overview of the credit card customers by finding the descriptive statistics of each variable (each variable separately). In descriptive statistics, you may find the average, mode, median, variance, standard deviation, minimum and maximum values. Please keep in mind that the descriptive statistics metrics may not be meaningful for all types of data. For instance, calculating the average of account numbers will not make any sense or the mode and median may not explain details of the dataset and they may not be useful compared to other metrics.
2. Upper management also asked you to compare the variability of each variable and provide an analysis about which variable has more variability. If you used a specific metric to compare the variabilities of each column, explain why you did use that method.
Account Number | x1 Annual Income ($1000) | x2 Household Size | x3 Years of Post-High School Education | x4 Hours Per Week Watching Television | x5 Age | x6 Gender (1:Female, 0:Male) | x7 Exceded Credit Limit in the Past 12 Months? (No:0, Yes:1) | y Annual Charges ($) |
23313578 | 21.8 | 4.0 | 5.0 | 29.0 | 47 | 1 | 0 | 10023.52 |
14168784 | 65.5 | 7.0 | 3.0 | 46.0 | 60 | 1 | 0 | 11248.76 |
498076 | 54.2 | 3.0 | 2.0 | 18.0 | 47 | 0 | 0 | 6115.00 |
12286258 | 73.7 | 6.0 | 0.0 | 44.0 | 41 | 0 | 0 | 9785.55 |
Step by Step Solution
3.38 Rating (145 Votes )
There are 3 Steps involved in it
Step: 1
a Descriptive statistic for all stated variables is as follows Support We will use MS Excel technologybased Data Analysis functionality to obtain the ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started