Using Excel Spreadsheets in Statistics
- Page ID
- 18849
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)
- 1 Creating a Frequency Table
- 1.10 Using the Excel Spreadsheet provided - Frequency Table You Bin
- 1.11 Using Excel Spreadsheet Provided - Frequency Table
- 1.12 Using the Excel Spreadsheet - Frequency Table Only
- 1.20 Installing the Data Analysis Tool for Excel
- 1.21 Creating a Frequency Table and Histogram in Excel - Using the Data Analysis Toolpak
- 1.22 Creating a Bar Chart and Frequency Table in Excel
- 3 Discrete Probability
- 3.1 Binomial Distribution using Excel Spreadsheet Provided
- 3.2 Binomial Probability using Excel
- 3.3 Poisson Distribution using Excel Spreadsheet Provided
- 3.4 Poisson Probability using Excel
- 3.5 Geometric Probability Distribution using Excel Spreadsheet
- 3.6 Geometric Probability using the Excel Sheet provided
- 5 Central Limit Theorem and Confidence Intervals
- 5.1 Probability for Means using Excel
- 5.2 Probability for Proportions using the Excel Spreadsheet
- 5.3 Confidence Intervals Means using Excel spreadsheet provided
- 5.4 Confidence Interval for Proportions using Excel Spreadsheet provided
- 5.5 Sample Size - Mean - Using the Excel Spreadsheet provided
- 5.6 Sample Size - Proportion - Using the Excel Spreadsheet provided
- 6 Hypothesis Testing - One Population Mean, Proportion, and Dependent Populations
- 6.1 Hypothesis Test - Single Population Mean using Excel Spreadsheet provided
- 6.2 Hypothesis Testing - Single Population Mean using Excel
- 6.3 Hypothesis Testing - Single Population Proportion using the Excel Spreadsheet provided
- 6.4 Hypothesis Testing - Two Dependent Populations - Using the Excel Spreadsheet provided