Excel 2016 – Statistical Analysis
A: Decision Models
- How to build a decision model in Excel (10:10 minutes)
- Using the Excel Decision Analysis Tool Pac to find regression Equations for a Decision Model (3:20 minutes) https://youtu.be/bYZgiR8GUs4?list=PL-p-X15e8UeAiMBuPckvEAKDcxo2MJB84
- How to set up a data table in Excel – BUS 430 Module 5
- Short video on how to set up and use the Excel Data Table tool for BUS 430 Module 5
- https://youtu.be/oTWnuIJiqoA?list=PL-p-X15e8UeAiMBuPckvEAKDcxo2MJB84
- Two Variable Data Table in Excel – Evans Chapter 9 (3:25 minutes)
- Using an Excel Data Table for Two Variables to Solve a Decision Model
- https://youtu.be/HCM1eroVmF8?list=PL-p-X15e8UeAiMBuPckvEAKDcxo2MJB84
- How to use Excel Goal Seek, Solver, and Scenario Manager to solve a business decision model. (7:28 minutes)
- Review of M5A1 using Excel What If and Solver (5:49 minutes)
- Review of one solution to the homework problem M5A1 that is done using Excel’s What If and Solver tools.
- https://youtu.be/w9MawCPCCd8
- How to set up a linear optimization problem using Excel Solver 2016 (9:11 minutes)
- A detailed explanation of how to identify the objective function and constraints in a word problem, build a decision model, and use Excel and Solver to find the optimum solution. Note: I am reviewing the student’s model, showing the basics of optimizing using Solver, but that student’s model has a weakness. See if you can find it.
- https://youtu.be/5TPbj-fzhG0?list=PL-p-X15e8UeAiMBuPckvEAKDcxo2MJB84
- Using Solver with Excel 2016 for Linear Optimization Problems – Part 2 -Evans Chapter 13 (25 minutes)
B. Comparing Variables using Pivot Table