Statistics with Excel Part Two Год выпуска: 2016 Производитель: Lynda Сайт производителя: lynda.com/Tableau-tutorials/Statistics-Excel-Part-Two/455718-2.html Автор: Joseph Schmuller Продолжительность: 2:0 Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Understanding statistics is more important than ever. Statistical analysis, in particular, is the basis for decision making in many fields, including business and academia. In this course, part two of a series, Professor Joseph Schmuller teaches you how to use statistics concepts and tools to perform analysis in Microsoft Excel. He explains how to organize and present data and how to draw conclusions using Excel's functions, charts, and 3D maps and the Solver and Analysis ToolPak add-ons. Learn to calculate mean, variance, standard deviation, and correlation; visualize sampling distributions; and test differences with analysis of variance (ANOVA). Then find out how to use linear, multiple, and nonlinear regression testing to analyze relationships between variables and make predictions. Joseph also shows how to perform advanced correlations, variable frequency testing, and simulations. Понимание статистики является более важным, чем когда-либо. Статистический анализ, в частности, является основой для принятия решений во многих областях, включая бизнес и научные круги. В этом курсе, второй части цикла, профессор Джозеф Шмюллер расскажет вам, как использовать статистические концепции и инструменты для проведения анализа в Microsoft Excel.
Содержание
00 - Introduction Welcome Need to know Exercise files 01 - Excel Statistics Essentials Use Excel statistical functions Use the Analysis Toolpak Use statistical charts Use 3D maps 02 - Visualize Sampling Distributions Simulate the central limit theorem Visualize the standard normal and t Visualize F and chi square 03 - ANOVA: A Closer Look Analyze between groups ANOVA Perform simple comparisons Perform complex comparisons Perform unplanned comparisons Perform repeated measures ANOVA 04 - ANOVA: A Complex Look Perform two-way analysis of variance Perform comparisons after two-way ANOVA 05 - Linear Regression: A Closer Look Visualize scatter plot and regression line Analyze the regression line 06 - Multiple Regression Perform multiple regression 07 - Nonlinear Regression Define natural logs and exponentials Perform exponential regression analysis Perform logarithmic regression analysis Perform power regression analysis Perform polynomial regression analysis 08 - Time Series Forecast and make predictions 09 - Advanced Correlation Perform correlation Compare two correlation coefficients Perform multiple correlation Perform partial correlation 10 - Frequency Hypothesis Testing Test independence of two variables Test goodness of fit 11 - Simulation Perform Monte Carlo simulation Perform business simulations 12 - Conclusion Next steps Exercise Files
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
