Business Statistics

Unit 1 AS2: Frequency distribution
Attached Files:
File CEOTime.xlsxOpen this document with ReadSpeaker docReader (9.159 KB)
AS2 Description:

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

AS2 Instructions:

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

Unit 1 Lab AS: Summarizing data using excel
Attached Files:
File Audit.xlsxOpen this document with ReadSpeaker docReader (8.438 KB)
Unit 1 Lab assignment instructions:

1. Get the “Audit” Data file (attached).

2. Follow the instructions under “using excel to construct a frequency distribution” in Chapter 2 of textbook.

3. Develop Figure 2.9 and add relative frequency and cumulative frequency. Keep in mind that “count of audit time” is frequency only.

4. Upload the final figure showing classes, frequency (count of audit time), relative frequency, and cumulative frequencPLEACH CHECK FILES FOR THE TABLES.