Assignment

Unit 3 Application AssignmentPart 1:

Use Microsoft Excel and the following data set of the crimes committed by persons arrested on one day to create a frequency distribution a percentage distribution and a cumulative percent distribution. Make sure you label your distribution and all of the parts correctly. (Hint: Instructions for creating a frequency distribution using Excel are on page 21 in your textbook.)2 4 4 6 2 3 2 0 2 2 0 4 8 1 2 6 9 8Answer:

Frequency Distribution

 

 

Frequency

Percentage (%)

Cumulative Percent

Counts

0

2

11.1

11.1

 

1

1

5.6

16.7

 

2

6

33.3

50

 

3

1

5.6

55.6

 

4

3

16.7

72.2

 

6

2

11.1

83.3

 

8

2

11.1

94.4

 

9

1

5.6

100

 

Total

18

100

 

Part 2: Use the textbook and the Internet to research and briefly address the following:What is frequency ...