Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 Numberx1
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 ($)
2331357821.84.05.029.0471010023.52
1416878465.57.03.046.0601011248.76
49807654.23.02.018.047006115.00
1228625873.76.00.044.041009785.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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems Analysis and Design

Authors: Shelly Cashman, Harry J. Rosenblatt

10th edition

1285422708, 1285171349, 9781285422701, 978-1285171340

More Books

Students also viewed these Accounting questions

Question

Provide an overview of the systems design phase.

Answered: 1 week ago

Question

Why is the national security argument for tariffs questionable?

Answered: 1 week ago