Course Materials for SCMA 648
This page last updated on April 7, 2015 by Robert L. Andrews, Instructor
648 Homepage 648 Homework with Solutions 648 data files

Office Mix Files: (login with either a Microsoft account, Facebook or Google to listen.)
Office Mix with Intro to JMP created on 2-2-2015
Office Mix on PivotTables created on 2-9-2015
Office Mix on discussing coverage from chapters 4, 5, 6 & 7 for midterm created on 2-23-2015
Office Mix on using JMP for regression created on 3-16-2015
Office Mix on Intro to Hierarchical Clustering created on 4-6-2015
Office Mix on K-means Clustering & Classification with Decision Trees, Discriminant Analysis and Logistic Regression created on 4-6-2015


KDnuggets poll results on data types analyzed
Analytics Magazine Online

KDnuggets poll results on data types analyzed
Analytics Magazine Online

Chapter 1 PowerPoint Slides for Evans text Foundations of Business Analytics
Problem solving steps (Class Exercises & pg 22 of Evans)

Analytics 2014 Lavastorm Analytics report from an Industry Trends Survey (pdf file)

Traits of a Successful Statistician (pdf file)
Assignment #1 for personal traits assessment & #2 for analytics definition (Excel file)
Summary list for personal traits assessment for Assignment #1 (Excel file for summer 2013)

PowerPoint Slides for Excel 2013 Features Wilma Andrews presentation on 5-21-2014

Chapter 2 PowerPoint Slides for Evans text Analytics on Spreadsheets
Excel Finance Functions (Excel file)
Excel 2010 functions with focus on statistical functions (Excel file)
Purchase Order data (Excel file)

Chapter 3 PowerPoint Slides for Evans text Visualizing and Exploring Data

Chapter 4 PowerPoint Slides for Evans text Descriptive Statistical Measures

Chapter 5 PowerPoint Slides for Evans text Probability Distributions and Data Modeling

Chapter 6 PowerPoint Slides for Evans text Sampling and Estimation

Chapter 7 PowerPoint Slides for Evans text Statistical Inference

Chapter 8 PowerPoint Slides for Evans text Predictive Modeling and Analysis
Chapter 8 Data-Driven Modeling Examples Excel 2010 File

Chapter 9 PowerPoint Slides for Evans text Regression Analysis
Andrews Notes on Regression (Excel document)
Comprehensive Regression Example from section 10.9 of Canavos & Miller 1999 (Excel document)
Regression Examples (Excel document)

Chapter 18 PowerPoint Slides for Evans text Decision Analysis
Additional Decision Analysis notes for the Evans text

Chapter 12 PowerPoint Slides for Evans text Data Mining
Cluster Analysis Illustration Excel File
Demo for Discriminant Analysis (Excel document)
Iris data, 3 species & 4 measurements Excel File
Logistic Regression and example from Sharpe text (Excel document)
Credit Approval Decisions 2010 Excel File with tabs showing XLMiner output (data match those in text)
Credit Approval Decisions Excel File with original data only for chapter 12