Excel and Office Mix Files from spring 2018 for SCMA 643: (For Mix files login with either a Microsoft account, Facebook or Google to listen.)
Office Mix for January 22 (Unfortunately the recording I tried to make in class would not save and this is a brief overview of what I did in class)
Office Mix for January 24 (Again the recording I tried to make in class would not save and this is a brief overview of what I did in class)

Office Mix for January 29 (Again the recording from class would not save and this is a brief overview of what I did in class)
Office Mix for Part 1 of class on January 31 (Illustration that the 1st eigenvector defines the direction with the maximum variance)
Office Mix for Part 2 of class on January 31 (This is what I did in class for JMP)

Office Mix for February 5 Using JMP for Principal Components Analysis and Intro to Factor Analysis
Office Mix for February 7 This is a replacement showing Principal Components Analysis of the Covariance Matrix

Office Mix for February 12 This is a replacement showing Principal Component & Factor Analysis of the Home Data
File with output from 2 analyses (all data values vs. excluding 2 non-indicative values) (Excel document)
Office Mix for February 14 Factor Analysis of the SENIC hospital Data

Office Mix for February 17 Class recording for the review for the test
Knowledge Expectations for Test on February 21, 2018 2018 (Word document)
Excel File used for the review for Test 1 (Excel document)

Office Mix for February 26 Class recording for intro to SPSS that included Principal Component & Factor Analysis of the JMP Data

Office Mix for March 14 Class recording for intro to Cluster Analysis and uses both JMP & SPSS

Office Mix for March 19, part I Creating Summated Scale and clustering of cases using Summated Scales with SPSS
Office Mix for March 19, part II Clustering of variables
MP4 for March 19, part II Clustering of variables
PowerPoint for March 19, part II Clustering of variables

Office Mix for March 21 Class recording for intro to MANOVA
PowerPoint for March 21 Intro to MANOVA MANOVA with JMP & SPSS

PowerPoint for March 26 MANOVA with JMP & SPSS
PowerPoint for March 28 MANOVA with Assumptions

PowerPoint for April 2 MANOVA homework & Intro to Discriminant Analysis
PowerPoint for April 4 Cluster analysis of variables and checking normality in SPSS

PowerPoint for April 9 Intro Discriminant Analysis, JMP & SPSS
PowerPoint for April 11 Discriminant Analysis, JMP & SPSS

PowerPoint for April 16 Discriminant Analysis for RVA Houses with SPSS
PowerPoint for April 18 Intro to Logistic, JMP & SPSS

PowerPoint for April 23 Logistic Regression for Failed firms and SENIC hospital data
Excel File for Failed Corp data, created a sheet for adjusting cutoff point after class (Excel document)
PowerPoint for Part 1 on April 25, 2018 using Excel File for Failed Corp data above
PowerPoint for Part 2 on April 25, 2018 modeling with Census Data for Assignment 1 on the class data webpage

PowerPoint for April 30 Semester Review and answering questions
Project presentations on May 2
Final Exam 4-6:45 PM on Wednesday, May 9

Overview of significance testing (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