Business and Management Statistics Using Excel

所在平台: Udemy

课程主页: https://www.udemy.com/course/statistics-for-business-and-management-using-excel/

课程评论:没有评论

第一个写评论        关注课程

课程简介

课程名称:使用Excel进行商业与管理统计 课程概述:统计学是分析数据和做出明智决策的方法。然而,为了能够恰当地运用统计方法,必须对现有的统计方法有深入的理解,并在此基础上不断学习。因此,统计学是当今数据驱动世界中商业经理、工程师、政治科学家以及医学和生物研究人员所需的重要工具。随着信息技术的不断发展,数据和“大数据”在各个领域的角色也在不断扩展,尤其是在商业、市场营销和医学等领域。庞大的数据量若不能有效地总结和可视化,将无法被合理利用。商业分析提供了可以让决策者有效使用大数据集的方法论,这些数据集通过其他方式可能无法有效处理。熟悉可视化工具如Tableau的用户,通常会遇到基于统计的分析。 本课程教授数据分析和总结统计的基础知识、数据可视化、数据透视表、概率、假设检验、方差分析(ANOVA)和回归分析等内容。例如,回归模型可用作销售、成本、疾病传播等基本预测工具。我们使用的工具是微软Excel。在大多数情况下,一旦数据经过其他工具(如SQL)提取后,Excel便成为主要分析平台。

课程评论(0条)

课程详情

Statistics consists of ways to analyze data and make informed decisions. However, to be able to deploy statistical methods appropriately and properly, one needs to have a firm understanding of the available statistical methodologies and continuously build on the basic information acquired from classes like this one. Therefore, statistics is a powerful tool needed by business managers, engineers, political scientists, medical and biological researchers in the data-driven world of today. Recent and evolving advances in information technology have expanded the role of data and "big data," in all areas of endeavor, especially in the business, marketing, and medicine, among others. Huge volumes of the available data cannot be utilized properly unless they are summarized and visualized effectively. Business analytics provides methodologies that enable decision makers to effectively use large data sets that would not be practical by any other means. Those who are familiar with visualization tools like Tableau routinely encounter analysis that are statistics-based. This course teaches the basics of data analysis and summary statistics, visualization of data, pivot table, probabilities, hypothesis testing, ANOVA, and regression analysis. For instance, regression models may be used as basic tools of forecasting sales, costs, spread of diseases, among other uses. The tool we use is MS Excel. In most situations, once data are extracted using other tools such as SQL, Excel becomes the main platform for analysis.

课程标签

0人关注该课程

主题相关的课程