Excel plugin with over 240 functions! Making Data Processing

Excel plugin with over 240 functions! Making Data Processing Ultra Simple。人人都是数据分析师

Everyone is a data analyst。

Excel plugin with over 240 functions! Making Data Processing

1、快捷查找

由于此软件功能总计超240种，为方便查找使用，支持功能快速搜索以及常用项快速查找

1. Quick search

Since the software has more than 240 functions in total, in order to facilitate the search and use, it supports quick search of functions and quick search of commonly used items

2、易于上手

根据自身需求对数据执行相关操作都会弹出操作框，每个操作框都有详细的数据参数设置，专业人士使用更快速，非专业人士可快速上手。

2. Easy to use

If you perform relevant operations on the data according to your own needs, an operation box will pop up. Each operation box has detailed data parameter settings. Professionals can use it faster, and non-professionals can get started quickly.

3、准备数据

在进行数据分析前一般需要对数据进行处理，此插件支持多种功能的处理，如数据管理、缺失值等等。

3. Prepare data

Before data analysis, it is generally necessary to process the data. This plug-in supports the processing of various functions, such as data management, missing values, and so on.

4、数据描述

描述性统计、变量表征、分位数估计、直方图、正态性测试、重采样统计、相似度/相异度矩阵（相关性.…）、二系列相关、多重共线性统计、可靠性分析、列联表（描述性统计）、智能数据透视表等。

4. Data description

Descriptive Statistics, Variable Representation, Quantile Estimation, Histograms, Normality Tests, Resampling Statistics, Similarity/Dissimilarity Matrix (Correlation…), Quadratic Correlation, Multicollinearity Statistics, Reliability Analysis , contingency tables (descriptive statistics), smart pivot tables, and more.

5、数据可视化

直方图、概率图、散点图、运动图、条形竞赛图、平行坐标图、三元图、交叉表的2D图、误差线、语义差异图、词云、带图像的条形图、绘制函数、坐标轴缩放器、Easylabels、重新定位标签、EasyPoints、正交图、调整图表大小、变换绘图、合并图表、XLSTAT-3DPlot等等。

5. Data visualization

Histograms, probability plots, scatterplots, motion plots, bar race plots, parallel coordinates plots, ternary plots, 2D plots of crosstabs, error bars, semantic difference plots, word clouds, bar plots with images, draw Functions, Axes Resizers, Easylabels, Reposition Labels, EasyPoints, Orthographic Plots, Resize Charts, Transform Plots, Merge Charts, XLSTAT-3DPlot, and more.

6、机器学�

k均值聚类、模糊k均值聚类、Gaussian混合模型、一类支持向量机（Support Vector Machine）、DBSCAN、分类和回归树、K最邻近、朴素Bayes分类器、支持向量机（SVM）、分类和回归随机森林、关联规则

6. Machine Learning

k-means clustering, fuzzy k-means clustering, Gaussian mixture models, one-class support vector machine (Support Vector Machine), DBSCAN, classification and regression trees, K nearest neighbors, naive Bayes classifier, support vector machine (SVM), classification and regression random forests, association rules

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 0 votes
• 3 stars: 0 votes
• 4 stars: 0 votes
• 5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!