#Microsoft data analysis with excel series#

Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project - 58. The Poisson and Exponential Random Variable - 56. The Binomial and Hypergeometric Random Variables - 55. An Introduction to Random Variables - 54. Forecasting in the Presence of Special Events - 53.

#Microsoft data analysis with excel series#

Using Moving Averages to Understand Time Series - 51. Randomized Blocks and Two-Way ANOVA - 50. Analysis of Variance: One-Way ANOVA - 49. Modeling Nonlinearities and Interactions - 48.

Incorporating Qualitative Factors into Multiple Regression - 47. Introduction to Multiple Regression - 46. Using Correlations to Summarize Relationships - 45. Estimating Straight Line Relationships - 42. Summarizing Data with Database Statistical Functions - 38. Summarizing Data with Descriptive Statistics - 36. Importing Data from the Web into Excel - 33. Importing Text or Microsoft Word Data into Excel - 32. Using Solver for Financial Planning - 30. Using Solver to Schedule Your Workforce - 28. Using Solver to Solve Transportation or Distribution Problems - 27. Using Solver to Determine the Optimal Product Mix - 26. An Introduction to Optimization with the Excel Solver - 25. The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions - 20. Creating and Using Spinners for Sensitivity Analysis - 19. Using the Scenario Manager for Sensitivity Analysis - 18. Sensitivity Analysis with Data Tables - 16. Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions - 11. Evaluating Investments with Net Present Value Criteria - 9. Well known consultant, statistician, and business professor Wayne Winston teaches by example the best ways to use Microsoft Excel for data analysis, modeling, and decision making within real-world business scenariosДЎ.