Data Analysis: Summary Statistics

Sample Data: mean [Excel] or mean [csv]

Excel functions

• function: compute or determine a result from the input
• in Excel, functions are essentially predefined procedures coded in Excel
• DO: enter =, name of function, (, list of arguments, )
• Excel functions

Fill down a formula

• copy a formula to other cells, adjusting rows and columns as needed
• absolute vs relative cell reference
• Windows fill down a formula
• Mac: fill down a formula

calculate the mean

• function: compute or determine a result from the input
• COUNT function
• SUM function
• Calculate the mean directly: AVERAGE function

calculate the standard deviation

sample data

• STDEV.S function
• SQRT function