Skip to content
Dr. Dawn Wright
  • Home
  • About Dawn
  • Excel Calculators
  • BUS 233/503 Video Matrix
  • Doc’s Blog
Menu
  • Home
  • About Dawn
  • Excel Calculators
  • BUS 233/503 Video Matrix
  • Doc’s Blog

Excel 2016 – Statistical Analysis

A: Decision Models

  • How to build a decision model in Excel (10:10 minutes)
    • https://youtu.be/FtNNEA95-8k
  • 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)
    • https://youtu.be/LOfJ2OyLkzs?list=PL-p-X15e8UeAiMBuPckvEAKDcxo2MJB84
  • 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)
    • https://youtu.be/r2A5G-WfcZY

 

B. Comparing Variables using Pivot Table

  • Creating a frequency distribution for one variable [pivot table basics]
  • Creating a crosstabulation pivot table for one variable
  • Creating a pivot chart with a single variable

Popular Posts

  • How to State the Conclusion about a Hypothesis Test
  • Tail of the Test: Interpreting Excel Data Analysis t-test output
  • Use Excel to Calculate MAD, MSE, RMSE & MAPE
  • Why is the Standard Error Equal to Sigma Divided by the Square Root of n?
  • No Standard Deviation? How do I get the standardized test statistic?
  • "Easy" Excel Inverse Triangular Distribution for Monte Carlo Simulations Redux
  • Playing Card Probability
  • What are d-bar and s sub d?
  • Discrete or Continuous?
  • Chebyshev's Theorem Excel Calculator

Creative Commons

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.
Copyright © 2023 Dawn Wright, Ph.D. | Powered by Dr. Dawn