EMSE Engineering Management and Systems Engineering

Dr. Johan René van Dorp
Professor

Faculty ProfileExpertiseContracts & GrantsJournal & OtherSupervised ResearchTeaching Interests

EMSE 171/271 -
EMSE 4765/6765

Syllabus

Introduction

Course Files

Solutions

<< Courses Home Page

<< Home Page

DATA ANALYSIS FOR ENGINEERS AND SCIENTISTS:

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

Part 1: Statistics Review

Session 1: Exploratory Data Analysis and Laws of Probability
Session1.pdf, Challenger.xls, NormalSample.xls, PowerData.xls, MortgageRate.xls, RopeData.xls, ProbTableExample.xls,Homework1.pdf
Session 2: Distribution Theory
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
Session 3: Confidence Intervals and Hypothesis Testing
Session3.pdf
, EstimatorBehavior.xls, Voltage.xls, VOLTAGE.MPJ, Homework3.pdf
Session 4: Goodness-of-Fit, Two Sample T-test
Session4.pdf, NormalConfandCred100.xls, NormalConfandCred500.xls, LeanAngle.xls, JointNormalPDF.xls, Homework 4_1.pdf, Question2.txt

Part 2: Hotelling's T^2 Multivariate Test

Session 5: Review Matrix Algebra
Session5.pdf, MatrixVectorMultiplication.xls, women.xls, Homework 4_2.pdf
Session 6: Multivariate Point Estimation, Hotelling T^2 Test
Session6.pdf, PowerExample.xls,Homework5.pdf, Homework_5.xls, Homework_5_Solution_Template.xls

Part 3: Regression Analysis

Session 7: Simple Linear Regression
Session7.pdf, women_regression.xls, Homework6.pdf, absentee_template.xls.

Session 8: EXAM 1 (PART 1 - PART 2)

Session 9: Multiple Linear Regression
Session8.pdf, leslie_salt.xls, PRICEANALYSIS.MPJ, LESLIESALTSMALL.MPJ, LESLIESALTLARGE.MPJ.

Part 4: Principal Component Analysis

Session 10: Examples and How PCA works
Session10.pdf, pca_example_no_mechanics.xls,
PCA_EXAMPLE.MPJ, Stock.xls, STOCK.MPJ, COGNITION.MPJ, Example 41.xls, Table 44.xls, , Homework7.pdf, Optional: pca_example_with_mechanics.xls.Read article: http://jom.sagepub.com/cgi/reprint/21/5/967

Session 11:
PCA Case Study: A comparison of Gross State Products Session11.pdf, gsp.xls, GSP_RAW.MPJ, GSP_SHARE.MPJ, Homework8.pdf, government.xls, druguse.xls, STOCK.MPJ

Part 5: Analysis of Variance (ANOVA)

Session 12: One Way ANOVA
Session12.pdf,Tensile_Strength.xls, Tensile_Strength.MPJ, Tensile_Strength_Stacked.MPJ, Homework9.pdf, Cereal.xls

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

Session14.pdf, ADHESIONFORCE.MPJ, Router_Experiment.xls, Etch_Example.xls

Session 14: EXAM 2 (PART 4, PART 5 and PART 6)

Files for Data Analysis Project

Regression Project:

PCA Project:

ANOVA Project:

Data Analysis Project is due May 5th, 2011


School of Engineering and Applied Science
The George Washington University
1776 G Street NW, Suite 110
Washington, DC 20052
Email:  dorpjr@gwu.edu
Phone: (202) 994-6638