Math Models for Business  
  [ HOME ]
 
 

OPMT 5751 DAY SCHOOL

and PTS Albright Text Resources

OPMT 5751 ONLINE Section

Chapter Slides

Term Project for ONLINE Section:

Textbook Chapters

STATPRO Videos

The following links are the Lecture Slides that accompany Barrow and are for the ONLINE version of OPMT 5751

Day students can download data file (zipped) for a copy of StatPro

Instructions file (watch video first)

Data and Add-ins (zipped)

Right click on link and select "save target as.." (See video)

VIDEO for getting started on the term project

How to download, install and run Statpro. It also reviews the 3 data files used in the project.

Additional Materials

Statistics Manual (Faculty Notes)

Part I Descriptive Statistics

Part II Sampling and Regression

Advanced Topics

Introduction to Panel Data (Lecture)

Panel Data Models (Lecture)


Resources for ONLINE Section ONLY   Barrow 5th Ed Statistics for Economics, Accounting and Business Studies

Course Outline

Example videos:

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

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

Statpro Addin for Excel

(Right Click and choose "Save Target as..." to save file)