Excel Plugin With Over 240 Functions! Making Data Processing
Free Download Excel Plugin With Over 240 Functions! Making Data Processing
Published 6/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 413.47 MB | Duration: 0h 34m
Everyone is a data analyst。Since the software has more than 240 functions in total, in order
What you'll learn
Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
Master unique tips & techniques that you won't find in ANY other course, guaranteed
Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
Professionals can use it faster, and non-professionals can get started quickly.
Requirements
No Excel Experience Required, You'll Learn Everything You Want
Description
Excel plugin with over 240 functions! Making Data Processing Ultra Simple。人人都是数据分析师Everyone is a data analyst。Excel plugin with over 240 functions! Making Data Processing1、快捷查找由于此软件功能总计超240种，为方便查找使用，支持功能快速搜索以及常用项快速查找1. Quick searchSince 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 items2、易于上手根据自身需求对数据执行相关操作都会弹出操作框，每个操作框都有详细的数据参数设置，专业人士使用更快速，非专业人士可快速上手。2. Easy to useIf 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 dataBefore 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 descriptionDescriptive 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 visualizationHistograms, 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 Learningk-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
Overview
Section 1: 介绍
Lecture 1 How_to_create_a_Parallel_Coordinates_Visualization_with_XLSTAT
Section 2: How_to_group_samples_using_k-means_clustering_in_XLSTAT
Lecture 2 How_to_group_samples_using_k-means_clustering_in_XLSTAT
Section 3: How_to_run_a_Multiple_Correspondence_Analysis_(MCA)_with_XLSTAT_
Lecture 3 How_to_run_a_Multiple_Correspondence_Analysis_(MCA)_with_XLSTAT_
Section 4: How_to_run_a_Multiple_Linear_Regression_in_XLSTAT
Lecture 4 How_to_run_a_Multiple_Linear_Regression_in_XLSTAT
Section 5: How_to_transform_a_category_variable_into_a_complete_disjunctive_table_in_XLSTAT
Lecture 5 How_to_transform_a_category_variable_into_a_complete_disjunctive_table_in_XLSTAT
Section 6: How_to_save_and_reuse_the_settings_of_an_analysis_in_XLSTAT_
Lecture 6 How_to_save_and_reuse_the_settings_of_an_analysis_in_XLSTAT_
Section 7: How_to_run_a_Partial_Least_Square_regression_(PLS_regression)_in_XLSTAT_
Lecture 7 How_to_run_a_Partial_Least_Square_regression_(PLS_regression)_in_XLSTAT_
Section 8: How_to_run_an_Agglomerative_Hierarchical_Clustering_(AHC)_with_XLSTAT_
Lecture 8 How_to_run_an_Agglomerative_Hierarchical_Clustering_(AHC)_with_XLSTAT_
Excel plugin with over 240 functions! Making Data Processing Ultra Simple
Homepage
https://www.udemy.com/course/excel-plugin-with-over-240-functions-making-data-processing/Links are Interchangeable - Single Extraction
