Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. [7 marks] A large bank is interested in examining the distribution of client ages. They have millions of clients. Although they know the age

image text in transcribed

image text in transcribed

4. [7 marks] A large bank is interested in examining the distribution of client ages. They have millions of clients. Although they know the age of each client, it would take too long to produce graphs that contain the entire population. They instead take a simple random sample of 25 customers and create the histogram of ages shown below. The data for the histogram are given in Excel file COMM104_Assignment1_S22_Q4.xlsx on Canvas. You can access it by going to PAWS > Canvas > COMM 104 > Assignments > Assignment 1. You will need the Excel file to answer the last two parts of this question. Comment on the histogram. Recall that to comment on a histogram you need to answer four questions, given below. Histogram of customer ages 18-22 28-32 33-37 38-42 43-47 48-52 53-57 58-62 Age group [1 mark] What is the shape of the distribution? [2 marks] Are there any extreme values? If so, what are they? If not, why aren't there any Frequency 9876543 2 1 0 extreme values (use the definition of an extreme value in relation to a histogram to help you here)? [2 marks] What is the centre of the distribution? Provide the appropriate measure of centrality. Show your work: show the Excel formula you use to find your answer. [2 marks] What is the spread of the distribution? Provide the appropriate measure of variability, rounded to the nearest whole number. Show your work: show the Excel formula you use to find your

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

Accounting Comes Alive The Color Accounting Parable

Authors: Mark Robilliard ,Peter Frampton, Chang Chang, Mark Morrow, John Gorman

1st Edition

1450769608, 978-1450769600

More Books

Students also viewed these Finance questions

Question

explain the rationale for capital budgeting

Answered: 1 week ago