The tutorial includes a lot of screenshots that show you how to use each function step by step. This course is for anyone who uses MS-Excel to create maps, tables, and technical reports with complex data. It will benefit all readers who use MS-Excel to analyze data on a regular basis.

Course Overview

• 1. Install Data Analysis Add-in For Amazing Excel Statistical Tools
• 2. Download & Install Power Query for Data Transformation Tools
• 3. What Is Are Statistics Download Stock Data Create Information
• 4. Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio
• 5. Frequency Distributions & Column Charts, Categorical Variables
• 6. Subtle Chart Junk
• 7. Frequency Distributions, Histograms, Skew, Quantitative Variable
• 8. Cumulative Frequency Distribution & Chart, PivotTable & Formula
• 9. Description of Dot Plot and Stem and Leaf Charts
• 10. Power Query Import Multiple Text Files, Grade Histogram by Year
• 11. Cross Tabulation & Charts for Two Variables, Simpson’s Paradox
• 12. Scatter Chart & Trendline, X Y Data, 2 Quantitative Variables
• 13. VLOOKUP to Add New Field To Table & Create Cross Tabulation
• 14. Create Dot Plot in Excel Using COUNTIFS and REPT functions
• 15. Location Mean, Median, Mode for Central Location
• 16. Weighted Mean & SUMPRODUCT Function & Accounting Example
• 17. Geometric Mean, Average Compounding Rate GEOMEAN & RRI
• 18. Location Percentile, Quartile, Rank and Percentile Rank
• 19. Standard Deviation How Fairly Does Mean Represent Data Points
• 20. SKEW Function and Asymmetry in a Distribution of Data Points
• 21. Z-Score = # of Standard Deviations, Chebshev’s &Empirical Rule
• 22. Five Number Summary, Outliers and Box Plots
• 23. Numerical Measures Covariance and Correlation Coefficient
• 24. Probability Basics Sample Points, Events & Event Probabilities
• 25. Combinations & Permutations and Listing Sample Points
• 26. Adding Law of Probability for OR Events (12 Examples)
• 27. Multiplication Law of Probability AND Events (16 Examples)
• 28. Create Joint Probability Table from Raw Data & Calc Event Probs
• 29. Bayes’ Theorem to Calculate Posterior Probabilities
• 30. Create Discrete Probability Distribution, Calculate Mean and SD
• 31. Expected Value Standard & Deviation Discrete Prob. Distribution
• 32. Binomial Probability Distributions Tables, Charts, Functions
• 33. POSSION Distribution and POISSON.DIST Function
• 34. Hyper geometric Distribution and HYPGEOM.DIST Function
• 35. Dynamic Binomial Probability Charts (3 Examples)
• 36. Introduction to Continuous Probability Distributions
• 37. Uniform Probability Distribution
• 38. Probabilities for Normal (Bell) Probability Distribution

• 39. Normal (Bell) Probability Distribution Area Chart, X & Z Values
• 40. Answering Probability Questions With NORM.DIST Function
• 41. Exponential Probability Distribution & EXPON.DIST function
• 42. Simple Random Sampling in Excel Process & Theory
• 43. Sampling Distribution of Xbar and the Central Limit Theorem
• 44. Sampling Distribution of Pbar (Binomial Sample Proportion)
• 45. Standard Error Standard Deviation of Xbar Sampling Distribution
• 46. Central Limit Theorem To Compare Sample Mean To Normal Curve
• 47. Introduction to Confidence Intervals
• 48. Create Confidence Intervals Sigma Known Z-Score (3 Methods)
• 49. Distribution Confidence Intervals Sigma NOT Known 3 Examples
• 50. Confidence Intervals for Pbar Sample Proportion
• 51. Determine Sample Size for Sample Mean & Sample Proportion
• 52. 5 Steps Hypothesis Testing P-value & Critical Value Methods
• 53. 1 Tail Left Mean Hypothesis Z Test P-value & Critical Value
• 54. 2 Tail Z Score Mean Hypothesis Testing P-value Critical Value
• 55. NORM.S.DIST = p-value, NORM.S.INV = Critical Value Sigma Known
• 56. 1 Tail Right Mean Hypothesis T Test P-value & Critical Value
• 57. 1 Tail Left T Score Mean Hypothesis Test P-value Critical Value
• 58. 2 Tail Mean Hypothesis T Test P-value & Critical Value
• 59. T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T functions
• 60. Hypothesis Test for Proportions using p-value or Critical Value
• 61. Calculate Slope and Intercept for Regression Line
• 62. Sampling Distribution of Xbar1 – Xbar2 & Standard Error
• 63. Confidence Interval for Population Differences Sigma Known
• 64. Hypothesis Testing for Population Differences Sigma Known
• 65. Confidence Interval for Population Differences Sigma NOT Known
• 66. Hypothesis Testing for Population Differences Sigma NOT Known
• 67. Matched Paired Samples Population Differences Sigma NOT Known
• 68. ANOVA Tables for Comparing More Than 2 Population Means
• 69. Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error
• 70. Inference about Difference Between 2 Pop. Proportions Z Method
• 71. Chi-Square Test For 2 or More Population Proportions (Formulas)
• 72. Chi-Square Test Independence 2 Categorical Var. (PivotTables)
• 73. Joint Probability Tables. What Are They How to Use How to Create using PivotTable. EMT 1719
• 74. PivotTable or FREQUENCY function How They Are Different for Counting Numbers Excel Magic Trick 1720 16