For those who are not familiar with Excel, the first video of the **Excel 2013 Statistical Analysis for Business & Economics Playlist **at Excelsfun is very good.

Start with **Excel 2013 Statistical Analysis #00: Excel Workbooks For This Class ** (2:07 minutes). This short video gives an explanation of how to quickly navigate within the longish Excel 2013 Statistical Analysis #01. This is the Excel workbook that is used for the first two videos: Workbook

Although it is long, **Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)** gives an excellent introduction to Excel, from the very basics of spreadsheets to Pivot Tables and charts.

Next watch video #2 to learn how to activate

the statistical analysis add-in that is very useful for this course:

**Excel 2013 Statistical Analysis #2: Install Data Analysis Add-in For Amazing Excel Statistical Tools** (1:14 minutes) Workbook

If you want shorter videos on the basics of Excel (and more complex topics), try the **Excelsfun video series**. Be sure to watch the 2:30 intro video as it will show you how to quickly navigate the Excelsfun YouTube page to find what you need.

If you are an Excel beginner, the **Excel Basics** series is a great way to start. The following four links will get you started with Excel 2007; there are also similar videos for Excel 2010 and 2013 and soon there should be some for Excel 2016.

• **Excel Basics #1: What is Excel?** (10:35 minutes) Workbook

• **Excel Basics #2: Keyboard Shortcuts** (9:56 minutes) Same workbook as #1

• **Excel Basics #3: Formulas w Cell References** (10:30 minutes) Same workbook as #1

• **Excel Basics #16: Chart Basics – Excel Charts** (10:31 minutes) Same workbook as #1

** Specific topics in statistics:**

• Excel 2013 Statistical Analysis #16:**Location: Mean, Median, Mode for Central Location** Workbook

• Excel 2013 Statistical Analysis #8:** Frequency Distributions, Histograms, Skew, Quantitative Variable** Workbook

• **Descriptive Statistics in Excel** This 2:39 minute video shows use of the Descriptive Statistics tool in the Data Analysis add-in for Excel.

• Excel 2013 Statistical Analysis #25:** Probability Basics: Sample Points, Events & Event Probabilities** Workbook This 31-minute video covers the fundamentals of probability. The first 14:37 minutes show a lecture on probability theory and the remaining work is done in Excel.

• Excel 2013 Statistical Analysis #26:** Combinations & Permutations and Listing Sample Points** Using the same workbook as #25, this 7:35 minute video covers the theory and actual Excel steps.

• Excel 2013 Statistical Analysis #27:** Adding Law of Probability for OR Events (12 Examples)** Using the same workbook as #25, this 25:26-minute video does a great job of explaining the theory (first 7:50 minutes) and actual Excel steps.

• Excel 2013 Statistical Analysis #28: **Multiplication Law of Probability AND Events (16 Examples)** Using the same workbook as #25, this 33:17-minute video does a great job of explaining the theory including conditional probability, independence, and multiplication law (first 13:48 minutes) and actual Excel steps.

• Excel 2013 Statistical Analysis #31: **Create Discrete Probability Distribution, Calculate Mean and SD ** Workbook The first 12:54 goes step by step through the theory and then the remaining 19 minutes shows how to do it in Excel.

• Excel 2013 Statistical Analysis #33: **Binomial Probability Distributions: Tables, Charts, Functions** Workbook 37:50-minute video (first 11:01 are on the theory) Several good examples of problems solved using Excel.

• Excel 2013 Statistical Analysis #39: **Probabilities for Normal (Bell) Probability Distribution** Workbook This 24:07-minute video covers (first 12:19 minutes) the normal distribution theory and explanation of the Excel functions; the last half works through several example problems using Excel. *Really worth watching this video.
*

• Excel 2013 Statistical Analysis #43: **Simple Random Sampling in Excel: Process & Theory** Workbook this 26:56-minute video covers in detail the theory behind sampling distributions (first 14:02 minutes) and then the Excel steps to generate a random sampling of a data set. This is a lead-in to the next video on sampling distributions of the mean.

• Excel 2013 Statistical Analysis #44: **Sampling Distribution of Xbar and the Central Limit Theorem** Using the same workbook as #43, 45:38-minute video goes a great job of explaining the Central Limit Theorem and the sampling distribution of the mean. Several practical examples worked with Excel.

**Confidence Intervals videos: **

• Excel 2013 Statistical Analysis #48: **Introduction to Confidence Intervals **(Workbook)

• Excel 2013 Statistical Analysis #49: **Create Confidence Intervals Sigma Known Z-Score (3 Methods)**

• Excel 2013 Statistical Analysis #50: **t Distribution Confidence Intervals Sigma NOT Known 3 Example**s

• Excel 2013 Statistical Analysis #51: **Confidence Intervals for Pbar Sample Proportion**

**Hypothesis Testing videos:**

• Excel 2013 Statistical Analysis #53: **5 Steps Hypothesis Testing: P-value & Critical Value Methods** Workbook1 Workbook2 through Excel 2013 Statistical Analysis #61: **Hypothesis Test for Proportions using P-value & Critical Value **

• Excel 2013 Statistical Analysis #62: **Calculate Slope and Intercept for Regression Line** Workbook

• Excel 2010 Statistics 87: **Linear Regression #1: Scatter Diagram: Relationship Between 2 Variables?**

• Excel 2013 Statistical Analysis #72:** Chi-Square Test For 2 or More Population Proportions** (Formulas) Workbook

• Excel 2013 Statistical Analysis #73: **Chi-Square Test Independence 2 Categorical Var. (PivotTables)** (same workbook as #72)

## Leave a Reply