Excel and Office Mix Files from spring 2017 for SCMA 643: (For Mix files login with either a Microsoft account, Facebook or Google to listen.)
In-class exercise for centering and standardizing data 1-25-2017 (Excel spreadsheet)
Office Mix for the 2nd part of class 1-25-2017 for eigenvalues & eigenvectors (login with either a Microsoft account, Facebook or Google)

Redo of Office Mix for the 1st part of class 2-1-2017 for eigenvalues & eigenvectors (login with either a Microsoft account, Facebook or Google)
Office Mix for the 2nd part of class 2-1-2017 for eigenvalues & eigenvectors (login with either a Microsoft account, Facebook or Google)
Spreadsheat with tabs for 2-1-2017 class and the Office Mix Redo for 1st part (Excel spreadsheet)

Office Mix for the 1st part of class 2-8-2017 (login with either a Microsoft account, Facebook or Google)
Office Mix for the 2nd part of class 2-8-2017 (login with either a Microsoft account, Facebook or Google)
Spreadsheat with tabs for 2-8-2017 class and the Office Mixes (Excel spreadsheet)

Office Mix for the 1st part of class 2-15-2017 (You can skip from 1:40 to 5:25)
Office Mix for the 2nd part of class 2-15-2017 (You can skip from 53:10 to 55:35)
Word document with Expectations for Test 1 (Word document)

Office Mix for the 1st part of class 3-1-2017 Discussion of Factor Analysis
Office Mix for the 2nd part of class 3-1-2017 Using SPSS for Factor Analysis

Office Mix for the 1st part of class 3-15-2017 Using SPSS for Factor Analysis of a covariance matrix
Office Mix for the 2nd part of class 3-15-2017 Multicollinearity measures in SPSS

Office Mix for the 1st part of class 3-22-2017 Summated Scores from Factor Analysis and Canonical Correlation
Office Mix for the 2nd part of class 3-22-2017 Brief introduction to MANOVA

Office Mix for the 1st part of class 3-29-2017 Current Trends for Data Analysis Presentations
(Unfortunately Mix captured the presentation view, what the presenter sees on the computer that has the notes and the next slide, rather than showing what is on the projector.)
Office Mix for the 2nd part of class 3-29-2017 MANOVA using JMP & SPSS

Office Mix for the 1st part of class 4-5-2017 Introduction to Discriminant Analysis
Office Mix for the 2nd part of class 4-5-2017 Discriminant Analysis of Iris data using SPSS

Office Mix for the 1st part of class 4-12-2017 Discriminant Analysis of Iris data in JMP
Office Mix for the 2nd part of class 4-12-2017 JMP Discriminant 4 categories + Intro to K-means clustering

Office Mix for the 1st part of class 4-19-2017 JMP for Failed corporate entities, Summated Scales, Cluster, MANOVA & Discriminant.
Office Mix for the 2nd part of class 4-19-2017 Intro to Binary Logistic, then using SPSS to repeat 1st part done with JMP

Office Mix for the 1st part of class 4-26-2017 Adjusting priors & Misclassification costs for discriminant + SPSS Hierarchical Cluster
Office Mix for the 2nd part of class 4-26-2017 Using JMP for clustering

Office Mix for the 1st part of class 5-3-2017 Oral discussion of procedures and assumptions for the procedures that will be covered for final exam

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)

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

Principal Components and Factor Analysis (Excel document)

Multicollinearity in OLS Regression guidelines (Word document)
Multicollinearity in OLS Regression example (Excel document)
SPSS file for hospital variables (SPSS file)

Summated Scales from Factor Analysis and Canonical Correlation (Excel document)

MANOVA 2 variable example (Excel document)
Sample Data set for MANOVA (SPSS file) MANOVA significant for group 1 but ANOVAs not significant for variables X, Y & Z. Accompanies Excel file above & below
MANOVA with JMP & SPSS and Assuptions appling to MANOVA & Discriminant Analysis (Excel document)
Demo for Discriminant Analysis (Excel document)
MANOVA & Discriminant Analysis: JMP & SPSS Basics for MANOVA data set (Excel document)

Example illustrating Logistic Regression (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