怎样使用excl做因子分析和聚类分析

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

老师要交作业，具体操作步骤是怎样的啊

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏7 回帖

关键词：聚类分析 因子分析 excl 操作步骤

可以通过加载插件进行
http://www.statsci.org/excel.html

Statistical Add-Ins for Excel

Ad Science. Develop StatEL, a statistical analysis add-in for Excel for common statistical testing, medical statistical testing and factor analysis.
Analyse-It. Statistical analysis tool for Microsoft Excel. Orientated towards analysis of clinical experiments. Includes standard statistical techniques up to multiple regression and two-way analysis of variance. A 14-day evaluation version is available.
Daniel's XL Toolbox. Analyze and present data. Free.
dkstatisticalconsulting. Excel templates for some commonly used statistical tests. Free.
ezForecaster. Time series and regression forecasting for business applications.
EZSXL. A statistical package for Excel under Windows designed for auditors and fraud investigators. Free.
Lumenaut. Statistical and decision tree add-in for Excel aimed at business applications. Includes regression, logistic regression, decision trees and some time series.
NeuroXL. Neural network add-ons for Excel.
NumXL. Econometric and time-domain time-series models.
Real Statistics Using Excel. It is a practical guide for how to do statistical analysis in Excel plus a free software platform which extends Excel�s built-in statistical capabilities.
RegressIt. Multivariate descriptive data analysis and multiple linear regression. Free.
SigmaXL. Statistical and graphical analyses, with emphasis on business statistics.
Statistician. Data analysis and statistics add-in for Excel. Includes multiple regression, logistic regression and Poisson regression as well as elementary t-tests. A free lite version is available.
UNISTAT. Works as a stand-alone package or an an Excel add-in. Includes a wide range of statistical methodology including logistic regression, classification and clustering.
XLSTAT. Data analysis and statistics add-in for Excel. Includes logistic and probit regression, nonlinear regression, multiple regression and so on. A full working demonstration version is available.
XLStatistics. Excel workbooks for basic statistical analyses. Rodney Carr, Deakin University.
WinSTAT. Statistics add-in for MS-Excel. R Finch Software.

http://www.xlstat.com/en/learning-center/tutorials/running-a-factor-analysis-with-xlstat.html
通过xlstat

原来EXCEL都有这一功能，太牛了！！！！！！！！

因子分析和聚类分析不应该是SPSS的么

实在是太需要了，非常感谢

还可以直接用SPSS中的聚类和因子分析功能模块。

Excel也太强大了

看你要对什么聚类啦，一般会用到这样的范式，先做因素分析，然后在各因子下（总分或平均值） 对每一个case做聚类。对case分类