Computer Assignment 1

Needed Statistics functions in EXCEL are listed below:

To Find	Enter*
N	=COUNT(A1:A10)
Sigma	=SUM(A1:A10)
Mean	=AVERAGE(A1:A10)
Median	=MEDIAN(A1:A10)
Mode	=MODE(A1:A10)
	* In each case, the (A1:A10) indicates the data of interest.

Exercise 1:

• Enter the title -Police in Cell F4
• Enter the titlesN= Sigma= Mean= Median= Mode= in Cells F6 through F10.
• Bold the text for Column F and Adjust the column width so all information is visible.
• Enter the corresponding formulas for the above titles (F.) in Cells G6 through G10. BE SURE TO CHANGE THE DATA OF INTEREST TO READ(B2:B51) FOR EACH FORMULA

Example: Cell G6 should contain =Count(B2:B51)

• Enter the title -Robbery in Cell F12
• Enter the titlesN= Sigma= Mean= Median= Mode= in Cells F14 through F18.
• Enter the corresponding formulas for the above titles (F.) in Cells G14 through G18. BE SURE TO CHANGE THE DATA OF INTEREST TO READ(C2:C51) FOR EACH FORMULA

Example: Cell G14 should contain =Count(C2:C51)

• Enter the title -Murder in Cell F20
• Enter the titlesN= Sigma= Mean= Median= Mode= in Cells F22 through F26.
• Enter the corresponding formulas for the above titles (F.) in Cells G22 through G26. BE SURE TO CHANGE THE DATA OF INTEREST TO READ(D2:D51) FOR EACH FORMULA

Example: Cell G22 should contain =Count(D2:D51)

Exercise 2:

How do you answer the items on Computer Assignment 1: Exercise Add the answers in an excel sheet and also below.

1.How many variables are included in your data set?

2. What is the n of variables Police, Robbery, and Murder?

3. The Average of Variable Police is __________.

4. The Average of Variable Robbery is __________.

5. The Average of Variable Murder is __________.

6.The Sum of Variable Murder is __________.

7. The Sum of Variable Robbery is __________

8.The Sum of Variable Police is __________.

9.The Median of Variable Police is __________.

10. The Median of Variable Robbery is __________

11. The Median of Variable Murder is __________.

12. The Mode of Variable Murder is __________.

13.The Mode of Variable Police is __________.