|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-statistical-optimization-using-ms-excel/
课程评论：没有评论
课程名称：Excel高级分析 - 数据分析工具包/求解器 课程概述： 本课程旨在演示如何使用“数据分析工具包”，通过具体的商业场景展示如何应用统计程序分析给定的数据。此外，课程还讲解了如何使用目标求解（Goal Seek）和求解器（Solver）解决线性优化问题。学员将了解在统计程序输出中最重要的部分，并学会如何根据面临的问题进行解读。 课程标签： Excel中的统计分析、Excel中的线性优化、数据分析工具包（Excel附加组件）、统计分析案例研究、数据分析实例、使用Excel进行数据分析。 课程材料： 所有视频中使用的Excel文件均可下载，这些文件包含数据，学生可以自行练习。 课程完成时间： 大约需要10小时来练习和掌握所有程序。 课程结构： 该课程首先解释商业背景和数据，然后演示如何使用数据分析工具包进行统计程序。进一步讲解如何利用求解器解决线性编程问题，并示范如何使用目标求解。 课程内容包括： - 数值数据分析 - 类别数据分析 - 独立性卡方检验 - 简单线性回归/多重线性回归 - 方差齐性F检验 - 两样本均值比较的T检验 - 配对T检验 - 单因素方差分析（ANOVA） - 带/不带重复制的双因素方差分析 - 生成均匀/正态/泊松分布的随机数 - 排名和百分位 - 直方图和帕累托图 - 目标求解 - 求解器示例的线性规划问题 选择本课程的原因： 快速了解如何使用Excel进行统计分析，掌握统计程序输出的重要部分及其在特定上下文中的解读。此外，理解如何在求解器中制定线性编程案例并获得解决方案。
What is this course all about? This course demonstrates how to use "Data Analysis ToolPak". It explains the business scenario and then shows application of statistical procedure using data analysis tool pack on the given data. The course also shows how to use Goal Seek and Solver (to solve linear optimization problems) It gives clue about what is the most important portion of statistical procedure output and how to interpret it with respect to problem at hand. Tags Statistical Analysis using Excel Linear optimization using Excel Data Analysis toolpak (Excel Add-in) Statistical Analysis case studies Data Analysis examples Data analysis using Excel What Kind of Material is included All the excel files that has been used in videos are available to download. These excel contains data files, so that students can practice it on their own. How long it should take to complete the course It should take roughly 10 hours to practice and master all the procedure. How is the course structured The course first explains a business context and the data. Then it demonstrates how to use statistical procedure using data analysis tool pack. It Also explains how to solve linear programming problem using solver. It demonstrates how th use goal seek. The content of the course will be Numeric data Analysis Categorical data Analysis Chi square test of independence Simple Linear regression / Multiple linear regression F test for equality of variances T- Test for Comparing two sample means Pair t test ANOVA - single factor ANOVA - two factor with / without replication Generating random numbers with uniform / normal / poison distr. Rank and Percentile Histogram and pareto charts Goal seek Linear programming problem - Solver example Why Take this course To quickly understand how to perform statistical analysis using excel. The understand, which are the most important portion of statistical procedure output and how to interpret it for a given context. To understand the process of formulating linear programming cases in solver and getting solution.
