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