Downloads

---

· Teaching

· Research

· Administration

· Professional

· Downloads

· Personal

· Home

QMM 241 - Fall 2012 General Information Useful Excel Formulas Array Functions in Excel Chi-Square Tests Mini-Lecture on Chi-Square Tests AOL Mini-Project (Presidents) Example: Web Survey Normality Tests Example: U.S. Cities Crime Data Example: CEO Compensation Example: IRS Tax Data Two-Sample Tests Using t and F Mini-Lecture on Two-Sample Tests Example: Coffee Temperature Example: 5K Run Times More F Tests Analysis of Variance Mini-Lecture on ANOVA Simulated Normal Populations Example: 5K Run Times Time Series (Trends, Smoothing) Mini-Lecture on Forecasting Company Data Files Example: Amazon Exponential Smoothing Example: Stock Prices Exponential Smoothing Weights Regression and Correlation Mini-Lecture on Simple Regression Mini-Lecture on Multiple Regression Mini-Lecture on Regression Assumptions Simple Regression Using LINEST Example: Voting in 50 States Example: Correlation Matrix Example: Microprocessor Speed Example: Senior Olympic Swim Example: Car Specs Example: Birth Weight (Simple) Example: Birth Weight (Multiple) Example: Birth Weight (Assumptions) Example: Assault Rates (Simple) Example: Assault Rates (Multiple) Causal Reasoning Database for 50 States

QMM 510 - Fall 2012 General Information Weekly Mini-Lectures Demonstrations Descriptive Statistics Example: U.S. Cities Crime Data Example: CEO Compensation Example: Voting Example: IRS Tax Data Example: North Carolina Births Frequency Array Functions Useful Excel Formulas Hypothesis Tests Using Student’s t and F Coffee Temperature (Indep t) Quiz Scores (Paired t) More F Tests (two samples) Simulated Normal Populations (F) Time Series (Trends, Smoothing) Company Data Files Example: Amazon Exponential Smoothing Example: Stock Prices Exponential Smoothing Weights Chi-Square Tests Example: Web Survey Regression and Correlation Simple Regression Using LINEST Example: Microprocessor Speed Example: Senior Olympic Swim Example: Voting in 50 States Example: Correlation Matrix Example: Birth Weight (Simple) Example: Birth Weight (Multiple) Example: Birth Weight (Assumptions) Example: Assault Rates (Simple) Example: Assault Rates (Multiple) Database for 50 States