Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started