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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Vitamin A is an important part of the visual cycle that ultimately enables you to see. On the line structure below, select all atoms with tetrahedral molecular geometry. H3C. CH3 CH3 CH3 CH3 -: H

Part 1 Instructions Record the following journal entries for ABC Corporation on the journal in the provided Student Input Form (Excel file). Use the letter for each as the date. Journal Entries A....

plz answer correctly Personal Budget Assignment Businesses use budgets to plan for the future. That's what you will be doing for this assignment. Rather than budgeting for your current financial...

this looks like a lot but its for one hw project! Personal Budget Assignment Businesses use budgets to plan for the future. That's what you will be doing for this assignment. Rather than budgeting...

1. An article discussed the changes that banks in a certain country are making to the way they calculate the minimum payment due on credit card balances. The changes are being pushed by regulators in...

I need Help putting the notes from the word document into the excel spreadsheet AutoSave OFF os 5- w Lab 6 BS STUDENT - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View...

CS 112 Project 5 Dictionaries and File IO Due Date: Sunday, April 23rd, 11:59pm Last chance to use tokens! (P6 won't allow late submissions) The purpose of this assignment is to explore dictionaries...

this is all the information required to do assignment Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The...

Final_Exam_Macro Question 1 (2 points) Purchasing-power panty theory does not hold at all times because many goods are not easily transported and the same goods produced in different countries may be...

Businesses use budgets to plan for the future. Thats what you will be doing for this assignment. Rather than budgeting for your current financial situation, I want you to put together a budget for...

Briefly explain the basic characteristics of long-term care insurance.

What considerations should a successor accountant make in accepting a new engagement?

Find the maximum rate o f change o f f ( x , y , z ) = x + y z a t the point ( - 1 , 4 , 2 ) and the direction i n which i t occurs. Maximum rate o f change: Direction i n which i t occurs:

Sometimes, the root cause of a variance requires that variance analysis be performed in both hours and dollars. It is possible that calculating the variances in both hours and dollars is the only way...

Manufacturing cost data for Meneses Company, which uses a job order cost system, are presented below. Indicate the missing amount for each letter. Assume that in all cases manufacturing overhead is...

Data for investments in stock classified as trading securities are presented in E16-10. Assume instead that the investments are classified as available-for-sale securities. They have the same cost...

Taylor Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2012. The following data were used in...

Adler Company is considering purchasing new equipment for $300,000. It is expected that the equipment will produce annual net income of $10,000 over its 10-year useful life. Annual depreciation will...

A new trailer worth $17.500 is purchased and it's expected that the salvage value after 10 years will be $750. If the interest rate is 4%, what equation would be appropriate to use to determine the...

=+1. NGOs and nonprofits, along with charities, form the social sector.

=+What important functions do these organizations perform that cannot be performed by either governmental or for-profit organizations?

=+2. What potential problems do you see in the rapid growth of nonprofit or nongovernmental organizations? For whom do these groups speak? To whom are they accountable? Particularly in terms of...