Excel_Assignment_1

# Excel_Assignment_1 - University of Southern California...

• Notes
• 3

This preview shows pages 1–3. Sign up to view the full content.

University of Southern California School of Policy, Planning, and Development PPD 404 Name: ____________________ Instructor: Mark Velez Email: ____________________ Email: [email protected] First Excel Assignment Part I. Using the data set (Excel spreadsheet) nations.xls , write formulas to produce the following statistics for the variable MILEXP , the military expenditure per year (expressed in millions of dollars) for each county, whose values are stored in cells L3 through L26: N Mode Median Mean Standard deviation Variance Skewness Kurtosis Maximum value Minimum value Range Q3 Q1 The Inter Quartile Range (IQR) The Z-score for the military expenditure in Norway Note: Excel formulas are NOT “case sensitive” (i.e., capital letters are treated the same as lower-case letters). The Excel formulas for the statistics are: =counta (cell#:cell#) =mode (cell#:cell#) =median (cell#:cell#) =average (cell#:cell#) =stdev (cell#:cell#) =var (cell#:cell#) =skew(cell#:cell#) =kurt (cell#:cell#) =max (cell#:cell#)

This preview has intentionally blurred sections. Sign up to view the full version.

=min (cell#:cell#) =quartile (cell#:cell#,quartile#)) (e.g., quartile# would be 3 for the third quartile, 1 for the fist quartile)
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern