Coursera Spring Sale
40% Off Coursera Plus Annual!
Grab it
Master statistical analysis for business and economics applications through this comprehensive 75-video course series covering 23 hours and 52 minutes of Excel-based instruction. Learn to transform raw data into meaningful insights using Excel's powerful statistical tools, starting with fundamental data analysis concepts and progressing through advanced statistical methods. Develop proficiency in Excel formulas, functions, PivotTables, and chart creation while mastering efficient spreadsheet design principles including Excel's Golden Rule. Explore descriptive statistics through both tabular and graphical presentations, calculate numerical measures including averages and variances, and understand the foundations of probability theory. Dive deep into discrete and continuous probability distributions, sampling methods, and sampling distributions before advancing to interval estimation and hypothesis testing techniques. Apply statistical methods to real-world business scenarios through comparisons involving means, experimental design, analysis of variance, proportion comparisons, and tests of independence. Practice with hands-on examples including stock data analysis, grade distributions, cross-tabulation with Simpson's Paradox, scatter plots with trendlines, and various probability calculations. Utilize Excel's Data Analysis Add-in and Power Query for advanced data transformation while learning keyboard shortcuts for efficient analysis of large datasets. Build confidence intervals using both Z-score and t-distribution methods, conduct hypothesis testing with p-value and critical value approaches, and perform ANOVA analysis for comparing multiple population means. Note that while linear and multiple regression are not covered in this series, all techniques learned in Excel 2013 apply to later versions including Excel 2016 and Office 365.
