Analysis Techniques using What-If, Solver, graphing, functions and statistical features in Excel.
This lesson covers multiple analysis techniques. The What-If and Solver features are first described and them illustrated using examples. Multiple statistical analysis methods are described using Excel functions and data analysis features, including interpretation of Excel output. Formulas are given and differences between Excel and statistical text are explained.
This lesson covers multiple analysis techniques. The What-If and Solver features are first described and them illustrated using examples. Multiple statistical analysis methods are described using Excel functions and data analysis features, including interpretation of Excel output. Formulas are given and differences between Excel and statistical text are explained.