Excel_Assignment_1

Excel_Assignment_1 - University of Southern California...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: University of Southern California School of Policy, Planning, and Development PPD 404 Name: ____________________ Instructor: Mark Velez Email: ____________________ Email: mvelez@pvestates.org 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#) =min (cell#:cell#)...
View Full Document

Page1 / 3

Excel_Assignment_1 - University of Southern California...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online