Free YouTube Excel for Statistical Analysis in Business & Economics Course

Excel 2013 Statistical Analysis #00: Excel Workbooks For This Class

Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)

Excel 2013 Statistical Analysis #2: Install Data Analysis Add-in For Amazing Excel Statistical Tools

Excel 2013 Statistical Analysis #03: Download & Install Power Query for Data Transformation Tools

Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information

Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio

Excel 2013 Statistical Analysis #06: Frequency Distributions & Column Charts, Categorical Variables

Excel 2013 Statistical Analysis #07: Subtle Chart Junk

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

Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula

Excel 2013 Statistical Analysis #10: Description of Dot Plot and Stem and Leaf Charts

Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year

Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Paradox

Excel 2013 Statistical Analysis #13: Scatter Chart & Trendline, X Y Data, 2 Quantitative Variables

Excel 2013 Statistical Analysis #14: VLOOKUP to Add New Field To Table & Create Cross Tabulation

Excel 2013 Statistical Analysis #15: Create Dot Plot in Excel Using COUNTIFS and REPT functions

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

Excel 2013 Statistical Analysis #17: Weighted Mean & SUMPRODUCT Function & Accounting Example

Excel 2013 Statistical Analysis #18: Geometric Mean, Average Compounding Rate GEOMEAN & RRI

Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank

Excel 2013 Statistical Analysis #20: Standard Deviation: How Fairly Does Mean Represent Data Points?

Excel 2013 Statistical Analysis #21: SKEW Function and Asymmetry in a Distribution of Data Points

Excel 2013 Statistical Analysis #22: Z-Score = # of Standard Deviations, Chebshev’s &Empirical Rule

Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots

Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient

Excel 2013 Statistical Analysis #25: Probability Basics: Sample Points, Events & Event Probabilities

Excel 2013 Statistical Analysis #26: Combinations & Permutations and Listing Sample Points

Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)

Excel 2013 Statistical Analysis #28: Multiplication Law of Probability AND Events (16 Examples)

Excel 2013 Statistical Analysis #29: Create Joint Probability Table from Raw Data & Calc Event Probs

Excel 2013 Statistical Analysis #30: Bayes’ Theorem to Calculate Posterior Probabilities

Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD

Excel 2013 Statistical Analysis #32: Expected Value Standard & Deviation Discrete Prob. Distribution

Excel 2013 Statistical Analysis #33: Binomial Probability Distributions: Tables, Charts, Functions

Excel 2013 Statistical Analysis #34: POSSION Distribution and POISSON.DIST Function

Excel 2013 Statistical Analysis #35: Hypergeometric Distribution and HYPGEOM.DIST Function

Excel 2013 Statistical Analysis #36: Dynamic Binomial Probability Charts (3 Examples)

Excel 2013 Statistical Analysis #37: Introduction to Continuous Probability Distributions

Excel 2013 Statistical Analysis #38: Uniform Probability Distribution

Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution

Excel 2013 Statistical Analysis #40: Normal (Bell) Probability Distribution Area Chart, X & Z Values

Excel 2013 Statistical Analysis #41: Answering Probability Questions With NORM.DIST Function

Excel 2013 Statistical Analysis #42: Exponential Probability Distribution & EXPON.DIST function

Excel 2013 Statistical Analysis #43: Simple Random Sampling in Excel: Process & Theory

Excel 2013 Statistical Analysis #44: Sampling Distribution of Xbar and the Central Limit Theorem

Excel 2013 Statistical Analysis #45: Sampling Distribution of Pbar (Binomial Sample Proportion)

Excel 2013 Statistical Analysis #46 Standard Error: Standard Deviation of Xbar Sampling Distribution

Excel 2013 Statistical Analysis #47: Central Limit Theorem To Compare Sample Mean To Normal Curve

Excel 2013 Statistical Analysis #48: Introduction to Confidence Intervals

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

Excel 2013 Statistical Analysis #52: Determine Sample Size for Sample Mean & Sample Proportion

Excel 2013 Statistical Analysis #53: 5 Steps Hypothesis Testing: P-value & Critical Value Methods

Excel 2013 Statistical Analysis #54: 1 Tail Left Mean Hypothesis Z Test: P-value & Critical Value

Excel 2013 Statistical Analysis #55: 2 Tail Z Score Mean Hypothesis Testing P-value Critical Value

Excel 2013 Statistical Analysis #56: NORM.S.DIST = p-value, NORM.S.INV = Critical Value Sigma Known

Excel 2013 Statistical Analysis #57: 1 Tail Right Mean Hypothesis T Test P-value & Critical Value

Excel 2013 Statistical Analysis #58: 1 Tail Left T Score Mean Hypothesis Test P-value Critical Value

Excel 2013 Statistical Analysis #59: 2 Tail Mean Hypothesis T Test: P-value & Critical Value

Excel 2013 Statistical Analysis #60: T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T functions

Excel 2013 Statistical Analysis #61: Hypothesis Test for Proportions using p-value or Critical Value

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

Excel 2013 Statistical Analysis #63: Sampling Distribution of Xbar1 – Xbar2 & Standard Error

Excel 2013 Statistical Analysis #64: Confidence Interval for Population Differences Sigma Known

Excel 2013 Statistical Analysis #65: Hypothesis Testing for Population Differences Sigma Known

Excel 2013 Statistical Analysis #66: Confidence Interval for Population Differences Sigma NOT Known

Excel 2013 Statistical Analysis #67: Hypothesis Testing for Population Differences Sigma NOT Known

Excel 2013 Statistical Analysis #68: Matched/Paired Samples Population Differences Sigma NOT Known

Excel 2013 Statistical Analysis #69: ANOVA Tables for Comparing More Than 2 Population Means

Excel 2013 Statistical Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error

Excel 2013 Statistical Analysis #71: Inference About Difference Between 2 Pop. Proportions Z Method

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

Excel 2013 Statistical Analysis #73: Chi-Square Test Independence 2 Categorical Var. (PivotTables)

Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719

PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720

11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745

Average Excluding Min and MAX Values. TRIMMEAN function. 6 Formula Examples. EMT 1744