Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. 17 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. 17 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 COMMI04_Assignment/_F21_04.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. If you need to calculate a standard deviation, round it to 2 decimal places. Do not round any other values. Excel file Ages 19 20 21 22 22 29 30 30 36 54 49 36 21 54 49 31 52 18 40 41 34 53 60 33 Client Ages Frequency ON 18-22 28-32 33-37 48-52 53-57 38-42 Age of client 58-62 [1 mark] What is the shape of the distribution? [3 marks] Are there any extreme values? If so, what are they? If not, why aren't there any extreme values (use the definition of an extreme value in relation to a histogram to help you here)? [1 mark] 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_2

Step: 3

blur-text-image_3

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

Inventory Best Practices

Authors: Steven M. Bragg

2nd Edition

1118000749, 9781118000748

More Books

Students also viewed these Accounting questions

Question

=+v3. Determine if they are targeting the same audience.

Answered: 1 week ago

Question

=+1. Compare the copy on both sites. Are they alike or distinctive?

Answered: 1 week ago

Question

=+What kind of clients would work well in this medium?

Answered: 1 week ago