Question: Frequency distribution table form the data available on an Excel worksheet. https://www.macleans.ca/economy/money-economy/canadas-richest-communities-2019/ There are data from 100 richest cities in Canada. First, you have to

Frequency distribution table form the data available on an Excel worksheet.

https://www.macleans.ca/economy/money-economy/canadas-richest-communities-2019/

There are data from 100 richest cities in Canada.

First, you have to calculate the number of classes by using 2 to the k rule.

Second, calculate the class interval and don't forget to smooth out the edge and round up.Formula is (Max value-Min Value)/ numbers of classes.Then, list down classes and the frequencies in a table. You have the frequency distribution table.

Extra: Creating a histogram on Excel is optional for you as it is different and difficult than creating a bar chart. I am sharing a link to a video with details. You are encouraged to histogram using the data of 100 richest cities.

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!