Header image  
Decision Analysis (Math Models for Business)  
  [ HOME ]




Welcome Video How to Register and Log On to MyMathLab using D2L




FINAL EXAM PAGE - Contains files and information for the final exam



TEXTBOOK (Online Sections) 


  • Statistics for Managers using Microsoft Excel 7th ed by Levine, Stephan, Szabat (winter 2017)

  • Statistics for Economics, Accounting and Business Studies, 5th or 6th ed by Michael Barrow (fall 2016 and earlier)


Video Lessons


The following links are to a series of short video lectures I
found useful in understanding key concepts covered in the textbook and homework   Using Excel and Stat Pro Videos

Combinations and Permutations (Notation is C(n,r) and P(n,r)


Normal distribution, Z, T, and P values

Confidence Intervals

Hypothesis Testing


Chi Squared, F, Poisson and Exponential (e) distributions and Tests

Regression and testing for significance, Autocorrelation etc.

Forecasting with multiple regression in Excel

This 3 part lesson uses moving average and deseasonalizes data to run a forecast.

Forecasting with Dummy Variables and Holt-Winters

  1. Adding Stat Pro to Excel
  2. Adding Data Analysis Toolpack AND building a HISTOGRAM
  3. Simple Random Sampling
  4. Sampling Histograms and Averages of Simple Random Samples
  5. Proportional Stratified Sampling
  6. Scatterplots
  7. Correlation Matrices
  8. Simple Regression with Excel
  9. Multiple Regression using Excel
  10. Interpreting Multiple Regression in Excel
  11. Regression
  12. Creating Dummy Variables: Excel & Statpro
  13. Creating Dummy Variables in Excel (No StatPro)
  14. Multiple Regression with Dummies
  15. Autocorrelations
  16. Autoregression
  17. Deseasonalizing
  18. Holt's Method with Statpro and Solver
  19. Holt Winters Method
  20. Random Walk Method

MyMathLab Videos

Question 4 Correlation and Regression II

 & formula sheet for question 4