Search

Loading [MathJax]/jax/output/HTML-CSS/jax.js

Filter Results
Location
- Campus Bookshelves (1)
Classification
- Article type
  - Book or Unit
  - Chapter
  - Section or Page
  - N/A
  - N/A
- Author
  - David Lane
  - Alexander Aue
  - John H. McDonald
  - OpenStax
  - OpenIntro Statistics
  - Debashis Paul
  - Larry Green
  - Diane Kiernan
  - Alexey Shipunov
  - Peter Kaslik
  - Kathryn Kozak
  - David Lilja
  - Kristin Kuter
  - Foster et al.
  - Jenkins-Smith et al.
  - Grinstead & Snell
  - Russell A. Poldrack
  - Thomas K. Tiemann
  - Danielle Navarro
  - Jonathan A. Poritz
  - Kyle Siegrist
  - Paul Pfeiffer
  - Matthew J. C. Crump
  - Michelle Oja
  - Rachel Webb
  - Alex Reinhart
  - Maurice A. Geraghty
  - Anonymous
  - Erich C Fein, John Gilmour, Tayna Machin, and Liam Hendry
  - Gordon E. Sarty
  - Penn State's Department of Statistics
  - Mark Greenwood
  - Yang Lydia Yang
  - Bill Pelz
  - Valerie Watts
  - Nancy Ikeda
  - Linda R. Cote, Rupa G. Gordon, Chrislyn E. Randell, Judy Schmitt, and Helena Marvin
  - Klaire Somoray
  - Hannah Seidler-Wright
  - Michael R Dohm
  - Christina R. Peter
  - Lumen Learning
  - Roger Clark
  - Mikaila Mariel Lemonik Arthur
  - Mikaila Mariel Lemonik Arthur and Roger Clark
  - Yvonne Anthony
  - Jaeyong Choi
- Cover Page
  - yes
  - TOC Only
  - Compile but don't publish
- License
  - Public Domain
  - CC BY
  - CC BY-SA
  - CC BY-NC-SA
  - CC BY-ND
  - CC BY-NC-ND
  - GNU GPL
  - All Rights Reserved
  - CC BY-NC
  - GNU FDL
- Show TOC
  - yes
  - no
- Embed Jupyter
  - python
  - octave
  - r
  - sagemath
- Transcluded
  - yes
- OER program or Publisher
  - College of the Canyons - Zero Textbook Cost Program
  - ASCCC OERI Program
  - CK-12
  - OpenStax
  - GALILEO
  - OpenSUNY
  - MIT OpenCourseWare
  - Virginia Tech Libraries' Open Education Initiative
  - The Publisher Who Must Not Be Named
  - eCampusOntario
  - WAC Clearinghouse
  - BC Campus
  - Lumen
  - Open Oregon
  - OpenStax CNX
  - PDXOpen
  - Evergreen Valley College
- Autonumber Section Headings
  - title with space delimiters
  - title with colon delimiters
  - title with dash delimiters
- License Version
  - 1.0
  - 1.3
  - 2.0
  - 2.5
  - 3.0
  - 4.0
Include attachments
- Content Type
  - Document
  - Image
  - Other

1.5.1: Using Spreadsheets for Statistics
https://stats.libretexts.org/Courses/Las_Positas_College/Math_40%3A_Statistics_and_Probability/01%3A_The_Nature_of_Statistics/1.05%3A_Computers_and_Calculators/1.5.01%3A_Using_Spreadsheets_for_Statistics
A dollar sign before the number means the row won't change; if you enter " $=B\$1+C1$ " into cell $D1$ and then copy it to cell $D2$ , it will change to " $=B\$1+C2$ ". And a dollar sign before bot...A dollar sign before the number means the row won't change; if you enter " $=B\$1+C1$ " into cell $D1$ and then copy it to cell $D2$ , it will change to " $=B\$1+C2$ ". And a dollar sign before both the column and the row means that nothing will change; if you enter " $=\$B\$1+C1$ " into cell $D2$ and then copy it into cell $E2$ , it will change to " $=\$B\$1+D2$ ". So if you had $100$ numbers in column $B$ , you could enter " $=B1-\text {AVERAGE}(B\$1:B\$100)$ " in cell $C1$ , copy i…

Search

Text Color

Text Size

Margin Size

Font Type

Support Center

How can we help?