#set document(title: "9.1 Interactive Spreadsheets", author: "OpenStax") #set page(width: 8.5in, height: auto, margin: 1in) #import "@preview/cetz:0.5.2" #set text(font: ("STIX Two Text", "Libertinus Serif", "New Computer Modern"), size: 10.5pt, lang: "en") #show math.equation: set text(font: ("STIX Two Math", "New Computer Modern Math")) #set par(justify: true, leading: 0.62em, spacing: 0.9em) #set enum(spacing: 1.1em) // room between list items so tall inline fractions don't collide #set list(spacing: 1.1em) #set table(stroke: 0.5pt + rgb("#c7ccd3")) #let BLUE = rgb("#183B6F") // brand navy — section bars + example/solution labels (white on navy 11.09:1) #let ORANGE = rgb("#A94509") // brand primary-700 — AA-safe deep orange for TEXT (5.93:1 on white; raw brand #F37021 is 2.94:1 and must never carry text) #let RED = rgb("#DC2626") // brand error-600 #let GREEN = rgb("#059669") // brand success-600 (decoration only; small green text uses green-text #007942) #show heading.where(level: 1): it => block(width: 100%, above: 0pt, below: 16pt, fill: gradient.linear(BLUE, rgb("#2C5AA0")), inset: (x: 14pt, y: 12pt), radius: 3pt, text(fill: white, weight: "bold", size: 19pt, it.body)) #show heading.where(level: 2): it => block(width: 100%, above: 18pt, below: 10pt, fill: BLUE, inset: (x: 10pt, y: 6pt), radius: 2pt, text(fill: white, weight: "bold", size: 12pt, it.body)) #show heading.where(level: 3): it => text(fill: ORANGE, weight: "bold", size: 12.5pt, it.body) #show heading.where(level: 4): it => text(fill: BLUE, weight: "bold", size: 10.5pt, it.body) #let examplebox(label, title, body) = block(width: 100%, breakable: true, fill: rgb("#EFF1F5"), stroke: 0.5pt + rgb("#CFDDF0"), radius: 4pt, inset: 10pt, above: 12pt, below: 12pt)[ #block(below: 6pt)[#box(fill: BLUE, inset: (x: 6pt, y: 2pt), radius: 2pt, text(fill: white, weight: "bold", size: 8.5pt, label)) #h(0.4em) #strong[#title]] #body] // rail = decorative left rule (raw brand token); labelcolor = AA-safe label text shade #let notebox(label, rail, labelcolor, tint, body) = block(width: 100%, breakable: true, fill: tint, stroke: (left: 3pt + rail), inset: (left: 10pt, rest: 8pt), radius: (right: 4pt), above: 11pt, below: 11pt)[ #text(fill: labelcolor, weight: "bold", size: 7.5pt, tracking: 0.5pt)[#upper(label)] #linebreak() #body] #let solutionbox(body) = block(above: 4pt, below: 8pt)[ #text(fill: BLUE, weight: "bold", size: 8.5pt)[Solution] #linebreak() #body] #let figph(msg) = block(width: 100%, height: 60pt, fill: rgb("#f6f7f9"), stroke: (paint: rgb("#c7ccd3"), dash: "dashed"), radius: 4pt, inset: 10pt)[ #align(center + horizon, text(fill: rgb("#889"), style: "italic", size: 9pt, msg))] // Standardize inlined figure sizes: measure the natural CeTZ canvas, then scale to a // consistent envelope (aspect-aware; see build_typst.py FIG_* constants). Unlike the // print preamble, dimensions are FLOORED: in an editor a user can trim a figure to a // degenerate 1-D shape (a bare line), and w/h or tw/w would then divide by zero. #let _STD_W = 3.5 #let _WIDE_W = 5.6 #let _MAX_H = 3.4 #let _ASPECT_WIDE = 2.2 #let _UPSCALE_MAX = 1.15 #let stdfig(body) = context { let m = measure(body) let w = calc.max(m.width / 1in, 0.01) let h = calc.max(m.height / 1in, 0.01) let tw = if w / h > _ASPECT_WIDE { _WIDE_W } else { _STD_W } let s = calc.min(tw / w, _MAX_H / h, _UPSCALE_MAX) align(center, box(scale(x: s * 100%, y: s * 100%, reflow: true, body))) } #show figure: set block(breakable: false) #set figure(gap: 8pt) #show figure.caption: set text(size: 8.5pt, fill: rgb("#555")) == 9.1#h(0.6em)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 - Figure 7.1 Interactive Excel Template for the Mann-Whitney U-Test \[XLSX\] === 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\]