Question
The data below represent the distance (in kilometres) that 50 employees at the Fortinos grocery store travel each day to get to work. Use the
The data below represent the distance (in kilometres) that 50 employees at the Fortinos grocery store travel each day to get to work. Use the data to construct a frequency distribution table with 6 intervals (or classes) to represent the data. NOTE: you will need to follow the steps done in the example we went over in class Lesson #2 and Lesson #3; see PowerPoint and recordings posted. I have inserted a table below as an example of the headings you could use for your table. You will need to determine the boundaries of the intervals (or classes) i.e., for distance to get to work ... again see slides from class lessons mentioned above. 1 4 6 7 12 13 7 6 9 5 18 7 5 15 15 4 17 8 14 5 4 16 4 5 8 6 5 18 5 2 9 11 13 17 4 5 10 11 4 10 11 15 8 10 4 14 7 3 2 6 Frequency Distribution Table: Distance to get to work (km) Frequency PART 2 Construct a histogram in excel using the information in your frequency distribution table from PART 1. Use the information in Lesson 3 to construct your histogram using excel. Please note, hand drawn graphs will not be accepted; part of the assignment is to be able to use excel.
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