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 Examples
• 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)
