Statistical Analysis Spreadsheets

2-Sample t-test and CI's based on summary statistics

1-Way ANOVA based on summary statistics

2-Sample z-test and CI's for proportions w/ Relative Risk & Odds Ratio

Chi-Square Test

Simple Linear Regression with CI's for Means and PI's for Individual Outcomes

Relative Risk and Odds Ratios for Stratified Samples

Formulas for Relative Risks and Odds Ratios (PDF)

Normal Probability Calculations

Univariate Summary Statistics and Boxplot

Levene's Test (k<=6 groups, n<=1000 total observations)

Balanced 2-Way ANOVA Based on Means and SD's (Up to 20 levels for each factor)

Cohen's Kappa and Standard Error, CI, Z-test

Randomized Complete Block Design from Summary Stats and t-Statistic for Paired t-test

Confidence Interval for Difference Between a Partial Correlation and Bivariate Correlation, Controlling for 2 Variables



Approximate Power Calculation Spreadsheets

Approximate Power for 1-Sample and Paired sample z-test and t-test

Approximate Power for 1-Way ANOVA

Approximate Power for Pearson Correlation z-test

Approximate Power for Odds Ratios in 2x2 Tables

Power for Test of 2 Proportions


Density Function Spreadsheets

Normal Distributions (Up to 6 at once)

Gamma Distributions (Up to 6 at once)

Beta Distributions (Up to 6 at once)

Bivariate Normal  (Includes 3-D plot that updates with parameter changes)





Miscellaneous Spreadsheets

Deal or No Deal Worksheet