Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master statistical analysis for business applications through this comprehensive course playlist featuring 50+ video lessons taught by Excel MVP Mike Girvin from Highline College. Learn essential data analysis concepts starting with fundamental statistics principles including descriptive and inferential statistics, then progress through probability distributions, sampling methods, hypothesis testing, and regression analysis. Develop proficiency in Excel's statistical functions and tools including Power Query, PivotTables, and advanced formulas like spilled arrays (Microsoft 365) and traditional functions (Excel 2013). Explore practical business applications through real-world examples in accounting, finance, and economics while mastering efficient spreadsheet design principles and Excel's Golden Rule. Cover key statistical topics including frequency distributions, measures of central tendency and variability, probability theory, discrete and continuous distributions (binomial, Poisson, normal, exponential), confidence intervals, hypothesis testing with z and t distributions, linear regression, ANOVA, and chi-square tests. Gain hands-on experience with data visualization techniques, cross-tabulation analysis, and advanced Excel features for handling large datasets efficiently through keyboard shortcuts and optimized workflows.
