PAD $121$ PROBLEM SET $2$:

Excel Functions and Descriptive Data Analysis ${?}^1$

This exercise is a follow$-$up to Module $9$: Data Analysis in Excel $-$ Excel Functions. In this problem set, we are going to analyze the data created in Problem Set $1$ using Excel functions. In doing so$,$ we will learn how to find patterns in data and summarize data with Excel in order to create information useful for making decisions. Please read the following rules carefully before starting:

The assignment should be completed in Excel and submitted as individual work through the tab titled "Problem Set $2"$ on Blackboard.

You may discuss the assignment with others in the class, but the work that you turn in must be your own work.

Sharing and copying any Excel files related to the assignment will be considered

plagiarism.

The assignment should be submitted electronically by the given due date.

Create a copy of the file that you created in Excel for Problem Set $1$ called "Problem Set $2($your full name$)."$

Go to the worksheet named "Major Felony Offenses" in which you created the table of seven major felony offenses in NYC from $2000$ through $2011.$

$2\mathrm{.}1$ Using an Excel function, calculate the AVERAGE number of offenses for the crimes of murder and nonnegligent manslaughter, rape, robbery, felony assault, burglary, grand larceny, and grand larceny of motor vehicle in Column O$.$