Excel and Office Mix Files from spring 2016 for SCMA 643: (For Mix files login with either a Microsoft account, Facebook or Google to listen.)
File from class on January 27, 2016 (Excel document)
Office Mix for JMP Intro (login with either a Microsoft account, Facebook or Google)
File from class on February 3, 2016 (Excel document)
Office Mix for 1st part of class February 24, 2016 (login with either a Microsoft account, Facebook or Google)
Office Mix for 2nd part of class February 24, 2016 (login with either a Microsoft account, Facebook or Google)
Office Mix for 2nd part of class March 30, 2016 (login with either a Microsoft account, Facebook or Google)
Office Mix for MANOVA with SPSS April 6, 2016 (login with either a Microsoft account, Facebook or Google)
Office Mix for Discriminant Analysis with SPSS April 6, 2016 (login with either a Microsoft account, Facebook or Google)
Unfortunately it appears that the Office Mix for Discriminant Analysis with JMP on April 13, 2016 did not record properly with Office Mix
Office Mix for after break using SPSS for Discriminant & Logistic on April 13, 2016 (login with either a Microsoft account, Facebook or Google)
Office Mix for Discriminant Analysis with SPSS for Failed Corporate Enties on April 20, 2016 (login with either a Microsoft account, Facebook or Google)
Office Mix for after break using SPSS for Logistic Regression with SPSS for Failed Corporate Enties on April 20, 2016 (login with either a Microsoft account, Facebook or Google)

Introduction, Overview & prequisite material (Excel document)

Matrices, Data & Foundational Information (Excel document)
Matrix operations, basic descriptive statistics for multivariate data, eigenvalues & eigenvectors for covariance matrices, Euclidean distance between two points

WolframAlpha a computational & knowledge engine (Web page)

Example illustrating centering, standardizing & eigenvalues for data (xlsx Excel revised document)

Principal Components and Factor Analysis (Excel document)

MANOVA 2 variable example (Excel document)

MANOVA: Normality Assumption, Equal Variance Structure & Post Hoc tests (Excel document)

Information for Group Presentations on March 30 (PowerPoint document)

SPSS output for IRIS data (Excel file with analysis using 4 measurements for Iris data)

Overview of chapter 1 & prequisite material (Excel document)

Media Player Files for Statistical Analysis with Excel (Web page)

Matrices, Data & Foundational Information (Excel document)
Matrix operations, basic descriptive statistics for multivariate data, eigenvalues & eigenvectors for covariance matrices, Euclidean distance between two points

Matrices: Addition, Subtracting and Transpose (Media Player File)

Matrices: Multiplication, Determinants and Inverse (Media Player File)

Example illustrating centering and standardizing data (Excel document)

Example illustrating rotation of data (eigen vectors) (Excel document)

Missing Data information using HBAT missing data file (Excel document)

Examples illustrating principle component method for factor analysis of 2 variables using covariance matrix and using correlation matrix.

Factor Analysis of X1-X7 of HATCO data with JMP, SAS & SPSS previous file
Factor Analysis of X1-X7 of HATCO data with JMP & SPSS 2-21-15 file

Multicollinearity in OLS Regression guidelines (Word document)
Multicollinearity in OLS Regression example (Excel document)
SPSS file with data for Multicollinearity in OLS Regression example above & the two Examples A & B in Hair text (SPSS file)

Factor loadings for HBAT200 from 2-28-2011 (Excel 2003 document)
Factoring with different methods HBAT200 (Excel 2003 document)

MANOVA 2 variable example (Excel document)

MANOVA: Normality Assumption, Equal Variance Structure & Post Hoc tests (Excel document)

Demo for Discriminant Analysis (Excel document)

Discriminant Analysis: SPSS Basics & Illustrations for MANOVA data set (Excel document)

Discriminant Analysis: Prior Probability Specification in SPSS (Word document)

Logistic Regression Overview Web page for G. David Garson of North Carolina State University
Note link can take you to another website http://www.statisticalassociates.com/logistic.htm that will provide several options for obtaining a copy, including a pdf via registering for free.

Example illustrating Logistic Regression (Excel document)

Logistic Regression Results for Failed Companies Data (Excel document)

Cluster Analysis overview for SPSS (Word document)

Excel Illustration file for Cluster Analysis (Excel document)

Excel Illustration file for Cluster Analysis 2-21-2015 (Excel document)

Cluster Analysis for 8 country example (SPSS data set)
Cluster Analysis for 8 country example (Excel document)

AutoOnline Excel file with Auto Online data
AutoOnline SPSS file with Auto Online data