EMSE Engineering Management and Systems Engineering

Dr. Johan René van Dorp
Professor

Faculty ProfileExpertiseContracts & GrantsJournal & OtherSupervised ResearchTeaching Interests

EMSE 6765

Syllabus

Introduction

Prereq Review

Course Files

R - Files

Python - Files

Solutions

Project Files

<< Courses Home Page

<< Home Page

DATA ANALYSIS FOR ENGINEERS AND SCIENTISTS:

Excel tutorial file: ExcelTutorial.doc Courtesy of Jason Merrick (VCU).


Part 1: Statistics Review

Session 1: Exploratory Data Analysis:
Homework Set 1.pdf

Session 1 Lecture Notes + Files Post - Fall 2012:

Chapter 15: Exploratory Data Analysis: Graphical Summaries. Chapter 15.pdf, Examples Chapter 15.xls

Chapter 16: Exploratory Data Analysis: Numerical Summaries. Chapter 16.pdf, Examples Chapter 16.xls

Chapter 17: Basic Statistical Models: Chapter 17.pdf, Kernel_Density_Duration.xlsm, Kernel_Density_WaitingTime.xlsm, NormalSampleExample.xlsm

Lecture notes for chapters from: "A Modern Introduction to Probability and Statistics, Understanding Why and How" by F.M. Dekking, C. Kraaikamp, H.P. Lopuhaä and L.E. Meester, Springer-Verlag, 2005.

Session 1 Lecture Notes + Files Pre - Fall 2012:
Session1.pdf, Challenger.xls, NormalSample.xls, PowerData.xls, MortgageRate.xls, RopeData.xls, ProbTableExample.xls

Session 2: Estimation + Confidence Intervals:
Homework Set 2.pdf

Session 2 Lecture Notes + Files Post - Fall 2012:

Chapter 19: Unbiased Estimators. Chapter 19.pdf, Examples Chapter 19.xls

Chapter 20: Efficiency and Mean Squared Error. Chapter 20.pdf, Examples Chapter 20 - 1.xls, Examples Chapter 20 - 2.xls

Chapter 23: Confidence Intervals for the Mean. Chapter 23.pdf, Examples Chapter 23.xlsx, NormalConf - Var Known.xlsm, NormalConf - Var UnKnown.xlsm

Lecture notes for chapters from: "A Modern Introduction to Probability and Statistics, Understanding Why and How" by F.M. Dekking, C. Kraaikamp, H.P. Lopuhaä and L.E. Meester, Springer-Verlag, 2005.

Session 2 Lecture Notes + Files Pre - Fall 2012: Session2.pdf, PmfExample.xls, BearingExample.xls, SeatBelt.xls, CustomerExample.xls, EstimatorGraphs.xls, T_CHI_F_PDF_Graphs.xls, Homework2_Part_1.pdf, Homework2_Part_2.pdf


Part 2: Statistical Inference

Session 3: Confidence Intervals and Hypothesis Testing:
Homework Set 3.pdf
, Data_HW3_Q2.csv

Session3.pdf, EstimatorBehavior.xls, Voltage_1.xlsx, VOLTAGE.MPJ,

Session 4: Goodness-of-Fit, Two Sample T-test:
Homework Set 4.pdf, Question4.txt

Session4.pdf, Voltage_2.xlsx, LeanAngle.xlsx, NormalConfandCred100.xls, NormalConfandCred500.xls, JointNormalPDF.xls,


Part 3: Hotelling's T^2 Multivariate Test

Session 5: Review Matrix Algebra, Chapter 2.pdf
Homework Set 5.pdf

Session5.pdf, MatrixVectorMultiplication.xlsx, LeanAngle.xlsx, Height-Weight Data + Matrix Algebra.xlsx

Flow Chart Estimator Distributions.pdf

Session 6: Multivariate Point Estimation, Hotelling T^2 Test
Homework Set 6.pdf, HW_SET_6_Template.xlsx

Session6.pdf, Height-Weight Estimation + Hottelling.xlsx, PowerExample.xlsx, PowerExample - Template.xlsx


Part 4: Midterm

Session 7: Midterm Review
Practrice Exam 6765.pdf, Practice_Exam_Student_Name.xlsx

Practice Exam 6765 Solution.pdf, Practice_Exam_6765 Solution.xlsx

Session 8: Midterm Exam 10/19/2023: PART 1, 2, 3


Part 5: Regression Analysis

Session 9: Simple and Multiple Linear Regression, Chapter 3.pdf, Homework Set 7.pdf, absentee_template.xlsx.

Session9A - Simple Regression.pdf, Height_Weight_regression.xlsx,
Session9B - Multiple Regression.pdf
Leslie_salt_regression_case.xlsx

Height_Weight_regression_Partial_Completed.xlsx

Session 10: Diagnostics and Forecasting
Session10.pdf, Leslie_salt_regression_case.xlsx, Leslie_Salt.mpx


Part 6: Principal Component Analysis

Session 11: Examples and How PCA works, Chapter 4.pdf
Drug_Use_Template.xlsm

Session 11.pdf, Example 41 - COGNITION.xlsx, STOCKS_3_Raw_Data.xlsx, STOCKS_3_PCA.xlsm, Minitab_STOCKS_3.MPX, STOCKS_5_Raw_Data.xlsx, STOCKS_5_PCA.xlsm, Minitab_STOCKS_5.MPJ

Optional Read article: http://jom.sagepub.com/cgi/reprint/21/5/967

Session 12:
PCA Case Study: A comparison of Gross State Products:
Session 12 - PCA.pdf, gsp_raw.xlsm, GSP_RAW.MPX, gsp_share.xlsm, GSP_SHARE.MPX, Drug_Use_Solution.xlsm


Part 7: Analysis of Variance (ANOVA)

Session 13: One-Way ANOVA
Homework9.pdf, Cereal_Template.xlsx

Session 13 - ONE WAY ANOVA.pdf, Tensile_Strength.xlsx, Tensile_Strength - Partially Completed.xlsx, Tensile_Strength.mpx

Session 14: Two-Way ANOVA and 2^k ANOVA

Session 14 - TWO WAY ANOVA.pdf, AdhesionForce.xlsx, ADHESIONFORCE.MPX, Router_Data_To_Minitab.xlsx, Router_Experiment.xlsx, Etch_Example.xlsx, Etch_Example_Solution.xlsx

Session 15:

REGRESSION FINAL PROJECT REPORTS DUE ON 12/7/23.

PCA FINAL PROJECT REPORTS DUE ON 12/14/2023.


School of Engineering and Applied Science
The George Washington University
800, 22nd Street, Suite 2800
Washington, DC 20052
Email:  dorpjr@gwu.edu
Phone: (202) 994-6638