The purpose of this assignment is to learn to organize and present statistical data by using frequency distribution. You need to know how to get the number of class, class interval, and class limits. For quantitative data, get frequency distribution, relative frequency, percent frequency, and cumulative frequency.
1. Get the DataFile of CEOTime (attached).
2. Calculate the number of classes by using class width of two hours.
3. Set the lower class limit of the first class to include the lowest amount of time spent I the data set.
4. Tally the frequency in each class.
5. Get relative frequency, percent frequency, and cumulative frequency
6. Comment on the shape of the distribution. Interpret the pattern of how CEOs spend their day in meetings.
7. Upload the final frequency distribution table.
• Textbook Information:
Anderson, David R., Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, and James J. Cochran. Modern Business Statistics with Microsoft® Office Excel® 7th edition, 2020, Cengage
Student Edition: 9780357131381
Loose Leaf: 9780357131398