9.1 Interactive Spreadsheets
The interactive Excel workbooks used throughout this book are hosted with this web edition. Each file below is the author's unlocked, editable version: every formula, input cell, and chart is open to inspection and change. Download a workbook to follow a chapter's figures, or use the “Try it in XYZ Crunch” callouts beside each figure to work the same calculation in the browser.
In the original edition these worksheets were embedded from a personal third-party file-sharing account. This edition hosts the files directly so the links cannot rot, and pairs each workbook with an XYZ Crunch equivalent where one exists.
Chapter 1
- Figure 1.1 Interactive Excel Template of a Histogram [XLSX]
- Figure 1.2 Interactive Excel Template to Calculate Variance and Standard Deviation [XLSX]
Chapter 2
- Figure 2.1 Interactive Excel Template for Cumulative Standard Normal Distributions [XLSX]
- Figure 2.2 Interactive Excel Template for Illustrating the Central Limit Theorem [XLSX]
- Figure 2.3 Interactive Excel Template of a t-Table [XLSX]
Chapter 3
- Figure 3.1 Interactive Excel Template for Determining the t-Values Cut-off Point [XLSX]
- Figure 3.2 Interactive Excel Template for Determining the χ2 Cut-off Point [XLSX]
Chapter 4
- Figure 4.1 Interactive Excel Template for Test of Hypothesis [XLSX]
- Figure 4.2 Interactive Excel Template for Determining Chi-Square Cut-off Point [XLSX]
Chapter 5
- Figure 5.1 Interactive Excel Template for Determining Cut-off Point of a t-Table [XLSX]
- Figure 5.2 Interactive Excel Template for Paired t-Test [XLSX]
Chapter 6
- Figure 6.1 Interactive Excel Template of an F-Table [XLSX]
- Figure 6.2 Interactive Excel Template for F-Test [XLSX]
- Figure 6.3 Interactive Excel Template for One-Way ANOVA [XLSX]
Chapter 7
Chapter 8
- Figure 8.4 Interactive Excel Template for Determining t-Value from the t-Table [XLSX]
- Figure 8.5 Interactive Excel Template of an F-Table [XLSX]
- Figure 8.6 Interactive Excel Template for Simple Regression [XLSX]
- Figure 8.8 Interactive Excel Template for Multiple Regression Model [XLSX]
Adapted from Introductory Business Statistics with Interactive Spreadsheets — 1st Canadian Edition, by Mohammad Mahbobi (Thompson Rivers University) and Thomas K. Tiemann (Elon University), published by BCcampus, licensed under CC BY 4.0. Changes were made: reformatted as an accessible XYZ web edition with interactive XYZ-tool worksheets. The cover image (CC BY-NC 2.0, third party) is excluded from this edition. License: CC-BY-4.0.