Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. The credit card balances (in $) for a sample of 67 households are provided in the Data of Question 3 in Assignment 1 Excel

image text in transcribed
3. The credit card balances (in $) for a sample of 67 households are provided in the Data of Question 3 in Assignment 1 Excel file. a. Use Excel to construct a frequency table, a frequency histogram, and an ogive for these data with ten classes and the provided bin values. Do not forget about the title and the data. Remember to check the cumulative percentage box to obtain an ogive. What can you observe about the data from the frequency distribution? {7 marks} b. Use Excel to find mean, median, mode, range, and standard deviation of the credit card balances in this sample. {4 marks} c. Based on the given data, how would you describe a typical credit card balances (in $) of this sample? {1 marks} HINT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Topological Dimension And Dynamical Systems

Authors: Michel Coornaert

1st Edition

3319197940, 9783319197944

More Books

Students also viewed these Mathematics questions