Provide an overview of the credit card customers by finding the descriptive statistics of each variable (each
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 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 |
Systems Analysis and Design
ISBN: 978-1285171340
10th edition
Authors: Shelly Cashman, Harry J. Rosenblatt