# Appendix: Interactive Spreadsheets - Editable

- Page ID
- 6229

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

## 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