Appendix: Interactive Spreadsheets – Editable
The interactive spreadsheets used throughout this book have been locked except for select cells that allow the student and reader to practice specific concepts by entering, deleting, and then re-entering numbers. It was necessary to do this in order to maintain the integrity of the concepts and formulas being presented.
However, because this textbook is covered by an open license, these spreadsheets must also be available in editable form. Unlocked versions of all spreadsheets used in this textbook are listed below by chapter and figure number, and downloadable in the web version of this textbook.
Chapter 1
Figure 1.1 Interactive Excel Template of a Histogram
Figure 1.2 Interactive Excel Template to Calculate Variance and Standard Deviation
Chapter 2
Figure 2.1 Interactive Excel Template for Cumulative Standard Normal Distributions
Figure 2.2 Interactive Excel Template for Illustrating the Central Limit Theorem
Figure 2.3 Interactive Excel Template of a t-Table
Chapter 3
Figure 3.1 Interactive Excel Template for Determining the t-Values Cut-off Point
Figure 3.2 Interactive Excel Template for Determining the χ2 Cut-off Point
Chapter 4
Figure 4.1 Interactive Excel Template for Test of Hypothesis
Figure 4.2 Interactive Excel Template for Determining Chi-Square Cut-off Point
Chapter 5
Figure 5.1 Interactive Excel Template for Determining Cut-off Point of a t-Table
Figure 5.2 Interactive Excel Template for Paired t-Test
Chapter 6
Figure 6.1 Interactive Excel Template of an F-Table
Figure 6.2 Interactive Excel Template for F-Test
Figure 6.3 Interactive Excel Template for One-Way ANOVA
Chapter 7
Figure 7.1 Interactive Excel Template for the Mann-Whitney U-Test
Chapter 8
Figure 8.4 Interactive Excel Template for Determining t-Value from the t-Table
Figure 8.5 Interactive Excel Template of an F-Table
Figure 8.6 Interactive Excel Template for Simple Regression
Figure 8.8 Interactive Excel Template for Multiple Regression Model