Factor analysis in Excel PDF

Preview

Summary

Download Factor analysis in Excel PDF

Description

8/3/2019

Factor analysis in Excel tutorial | XLSTAT English  Login (/customer/en/login?b_id=9283&return_to=%2Fcustomer%2Fen%2Fportal%2Farticles%2F2062221-factor-analysis-in-excel-tutorial%3Fb_id%3D9283)  

XLSTAT Support Center 

 Home (https://help.xlstat.com) / Tutorials (https://help.xlstat.com/?b_id=9283) / Analyzing data (1/2) (/customer/en/portal/topics/824676-analyzing-data-1-2-/articles?b_id=9283) / Factor analysis in Excel tutor...

Factor analysis in Excel tutorial

2017-11-30

This tutorial will help you set up and interpret aFactor (https://www.xlstat.com/en/solutions/features/factor-analysis) Analysis (http://www.xlstat.com/en/solutions/features/factor-analysis) (FA) in Excel using the XLSTAT software. Not sure if this is the right multivariate data analysis tool you need? Check out this guide (https://help.xlstat.com/customer/en/portal/articles/2115193-what-multivariate-data-analysis-method-to-choose-?b_id=9283).

Dataset for running a Factor Analysis An Excel sheet with both the data and the results can be downloaded by clicking on the button below: DOWNLOAD THE DATA (/CUSTOMER/PORTAL/KB_ARTICLE_ATTACHMENTS/ 114163/ORIGINAL.XLS?1495198254 )

The data are from [Kendall M. (1975). Multivariate analysis. Grin, London] and correspond to 48 applicants for a position in rm who have been judged on 15 variables: Form of letter of application Appearance Academic ability Likeability Self-condence Lucidity Honesty Salesmanship Experience Drive Ambition Grasp Potential Keenness to join Suitability Because many correlations between the variables are high, it was felt that the judge might be confusing some of the variables, or that some variables might be redundant. Therefore a factor analysis was conducted to determine the fewer underlying factors. Several methods are available for computing factor analysis. XLSTAT default method is the Principal factor method applied iteratively. We will apply it here to generate seven factors, and we will do a varimax rotation to facilitate the interpretation of the results.

Setting up a Factor Analysis in XLSTAT After opening XLSTAT, select the XLSTAT / Analyzing data / Factor analysis commanD(see below).

https://help.xlstat.com/customer/en/portal/articles/2062221-factor-analysis-in-excel-tutorial?b_id=9283

1/7

8/3/2019

Factor analysis in Excel tutorial | XLSTAT

Once you've clicked on the button, the Factor analysis dialog box appears. Select the data on the Excel sheet. The Observations labels are also selected in the corresponding eld.

In the Options tab we select the varimax option for the rotation that will be applied to the rst two factors.

The following options have been activated for the outputs and the charts.

https://help.xlstat.com/customer/en/portal/articles/2062221-factor-analysis-in-excel-tutorial?b_id=9283

2/7

8/3/2019

Factor analysis in Excel tutorial | XLSTAT

The computations begin once you have clicked on OK. The results will then be displayed.

Interpreting the results of a Factor Analysis The rst results that are displayed are the summary statistics of the selected variables, and the correlation matrix between the variables. We can see that some of the correlations are quite high (0.883 for Grasp and Lucidity). The standardized Cronbach's alpha is computed for the whole input table. An alpha of 0.914 means that there is some redundancy among the selected variables. The reproduced and residual correlation matrices allow to verify if the factor analysis model is ne or not, and where it fails to reproduce correlations. The next table shows the eigenvalues resulting from the factor analysis. We can see that with 4 factors we keep 75.5 % of the variability of the initial data.

Note: the eigenvalues displayed above are those obtained with the principal factors extraction method. With the principal components analysis we would have obtained the following results:

Next, we can see that the varimax rotation has changed the way each factor explains part of the variance. The varimax rotation makes the interpretation easier by maximizing the variance of the squared factors loadings by column. For a given factor, high loadings become higher, low loadings become lower, and intermediate loadings become either lower or higher.

The next results we want to look at, are the factor loadings after the varimax rotation. These results are used to interpret the meaning of the (rotated) factors.

https://help.xlstat.com/customer/en/portal/articles/2062221-factor-analysis-in-excel-tutorial?b_id=9283

3/7

8/3/2019

Factor analysis in Excel tutorial | XLSTAT

From this table we can see that the rst factor is highly positively related to Ambition, Self-condence, Salesmanship and Lucidity. The second factor is loaded on Form of letter, Experience, and Suitability. From these results, we can understand that the individuals that have high scores on the rst factor are promising salesmen, while for other jobs such as management, individuals with high coordinates on the second and third factors might be more appropriate. The following chart gives the position of the variables on axes F1 and F2. Other charts mixing other factors can be displayed.

The following table gives the factor scores after the varimax rotation, which are the estimated coordinates of the observations on the factor axes.

XLSTAT displays the 2D maps on the selected factors. The chart below represents the map for F1 and F2.

The following video addresses Factor Analysis with an illustration using XLSTAT.

https://help.xlstat.com/customer/en/portal/articles/2062221-factor-analysis-in-excel-tutorial?b_id=9283

4/7

8/3/2019

Factor analysis in Excel tutorial | XLSTAT

#13 Factor Analysis in Excel with XLSTAT

 Getting Started XLSTAT rst steps and statistical learning resources (https://help.xlstat.com/?b_id=9202)

 Tutorials The place where you will master all of XLSTAT features (https://help.xlstat.com/?b_id=9283)

 Ideas Any feature or option you’d like us to develop? (http://ideas.xlstat.com/)

 https://help.xlstat.com/customer/en/portal/articles/2062221-factor-analysis-in-excel-tutorial?b_id=9283

5/7

8/3/2019

Factor analysis in Excel tutorial | XLSTAT

Videos For those of you who prefer video help (https://www.youtube.com/channel/UCHvhQQxGqVepBRELIUeGZew)

Contact Us (/customer/portal/emails/new?b_id=9283) (/customer/portal/emails/new?b_id=9283) (/customer/portal/emails/new?b_id=9283)

(/customer/portal/emails/new?b_id=9283)Email Sales (https://www.xlstat.com/en/contact) Contact our technical support team: [email protected]

The most complete statistical add-in for Microsoft Excel.







(https://www.linkedin.com/groups/XLSTAT2160205?    gid=2160205&mostPopular=&trk=tyah&trkInfo=tarId%3A1415606346733%2Ctas%3Axlst

1-1) (https://plus.google.com/+xlstat/posts) (https://www.youtube.com/channel/UCHvhQQxGqVepBRELIUeGZew) (http://funkystats.tumblr.com/) (https://www.facebook.com/Xlstat) (https://twitter.com/XLSTAT)

Solutions XLSTAT BASE XLSTAT PREMIUM XLSTAT BIOMED XLSTAT MARKETING XLSTAT ECOLOGY XLSTAT QUALITY XLSTAT SENSORY XLSTAT FORECAST XLSTAT PSY

Links HOME PRODUCTS PRICES ORDER

https://help.xlstat.com/customer/en/portal/articles/2062221-factor-analysis-in-excel-tutorial?b_id=9283

6/7

8/3/2019

Factor analysis in Excel tutorial | XLSTAT

NEWS TRAINING & CONSULTANCY

Copyright © 2017 Addinsoft. All Rights Reserved Customer service software (http://www.Desk.com) powered by Desk.com

https://help.xlstat.com/customer/en/portal/articles/2062221-factor-analysis-in-excel-tutorial?b_id=9283

7/7...