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
Get step-by-step solutions from verified subject matter experts
