SAMLab Tip Sheets Please direct comments, problems, or suggestions to ll317@u.washington.edu

Tip Sheets 1-10 focus on Excel; Tip Sheet 11 focuses on G*Power

Tip Sheet #1 "Translating Mathematical Formulas into Excel"

Tip Sheet #2 "Shortcuts to Performing an Operation Multiple Times"

Tip Sheet #3 “Using Excel’s Function Library”

Tip Sheet #4 “Creating a Histogram”

Tip Sheet #5 “Creating Graphs”

Tip Sheet #6 “Calculating the Variance and Standard Deviation”

Tip Sheet #7 “Computing a Pearson r”

Tip Sheet #8 “The Linear Regression Equation and

the Standard Error of the Estimate”

Tip Sheet #9 “The Single-Sample z Test”

Tip Sheet #10 “The Single-Sample t Test”

Tip Sheet #11 “Calculating Power Using G*Power”