Sunday, November 29, 2020

Statistics & Graphics Tools     


This page contains Microsoft Excel files with instructions (and examples) to create various graphical representations of data and do various statistical computations and analyses. To best utilize these instructional files, download them to your computer.  To do this, right click on the link and click on Save Target As".  Next, specify a destination file on your computer and complete the download.  You can then open that file, follow the step-by-step instructions, and replace the example data with your data for statistical analysis or graphing. Credit to other authors has been given where their spreadsheets have been used.


bulletCreating graphical representations of data  & computing simple statistics  

bulletComputing independent t-tests, correlated t-tests, and one-way ANOVA's

bulletComputing bivariate and multiple regression equations

bulletDetermining sample size or power for independent or correlated t-tests  

bulletComputing intraclass correlations coefficients for reliability assessment

bulletConstructing Bland-Altman Plots to determine instrument agreement

bulletCalculating Cohen's d for effect size