Excel 2013: Analysis Techniques and Random Numbers Год выпуска: 02/2016 Производитель: Pluralsight Сайт производителя: pluralsight.com/courses/excel-2013-analysis-techniques Автор: Brian Eiler Продолжительность: 7:25 Степень сложности: средняя Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: This lesson covers multiple analysis techniques. The What-If and Solver features are first described and them illustrated using examples. Multiple statistical analysis methods are described using Excel functions and data analysis features, including interpretation of Excel output. Formulas are given and differences between Excel and statistical text are explained. Этот урок охватывает несколько методов анализа. На что-если и Решатель объекты сначала описал и проиллюстрировал их с помощью примеров. Множественные статистические методы анализа описываются с помощью функции Excel и возможности анализа данных, включая интерпретацию вывода в формате Excel. Даются формулы и различия между Excel и статистических текста объясняются.
Содержание
Add-ins for Excel 2013 8m 28s Managing Excel Add-ins 8m 28s What-if Analysis, Goal Seek, Scenarios, and Solver 52m 1s Goal Seek Simple Formula 4m 51s Goal Seek Simple Formula in Excel 3m 4s Goal Seek Payment Example 3m 18s Goal Seek Payment Example in Excel 4m 18s Scenarios 4m 53s Scenarios Example in Excel 11m 25s Solver Set-up Working with an Example 9m 41s Solver Example in Excel with and Without Applying Constraints 9m 41s Summary 0m 46s Random Number Generator 37m 9s Introduction and Definitions 7m 8s The RAND Function 7m 4s The RANDBETWEEN Function 3m 48s Input Arguments for the Random Number Generation Tool 6m 20s Random Number Generation Tool Demonstration 4m 20s Distributional Choices 6m 17s Summary 2m 8s Descriptive Statistics 32m 32s Descriptive Statistics 8m 51s Descriptive Statistics Functions and Their Excel Arguments 4m 51s Using Descriptive Statistics Functions in Excel 9m 18s Descriptive Statistics and the Data Analysis Feature 2m 30s Calculating Descriptive Statistics Using Data Analysis Feature 5m 53s Summary 1m 7s Graphing Data 40m 3s Graphing Data / Scatter Plots 6m 35s Creating a Scatter Plot in Excel 5m 6s Histograms 3m 46s Creating a Histogram in Excel 5m 22s BoxPlots 6m 34s Create a BoxPlot in Excel 11m 58s Summary 0m 38s Z-tests 43m 27s Z-tests 3m 46s STEP ONE Hypotheses Statements 2m 33s STEP TWO Critical Value 3m 14s STEP THREE Determine Test Statistic 2m 33s STEP FOUR Calculate Test Statistic and Obtain P-value 5m 44s STEP FIVE Draw Conclusions 1m 29s Z-test Example 3m 57s Z-test 5m 31s Two Sample Z-test 7m 17s Demo: Two Sample Z-test 6m 3s Summary 1m 16s T-tests 55m 33s Introduction 6m 10s T-tests 6m 55s One Sample T-test 4m 43s Example: One Sample T-test in Excel 5m 7s Two Sample T-test 5m 26s Example: Two Sample T-test 4m 8s Paired T-test 4m 32s Two Sample T-test in Excel 1m 24s Example: Two Sample T-test in Excel 5m 24s Example: Paired T-test in Excel 3m 38s Two Sample T-Test 1m 46s Example: Two Sample T-test Data Analysis in Excel 3m 6s Example: Paired T-test Data Analysis in Excel Analysis 2m 25s Summary 0m 43s Variance Tests Chi-square Test and F-test 1h 17m Variance Tests 4m 43s Description of a Chi-square Test 5m 26s Hypothesis Testing for a Chi-square Test 7m 50s Chi-square Example 3m 24s Calculating a Chi-square Test Statistic and Drawing Conclusions 2m 49s Two-tailed Chi-square Test Demonstration in Excel 7m 13s One-tailed Chi-square Test Demonstration in Excel 2m 48s F-test Description and Hypothesis Testing 5m 42s Hypothesis Testing for a Two-tailed F-test 9m 10s Hypothesis Testing for a One-tailed F-test 2m 43s F-test Using Excel Functions for a Two-tailed Test 4m 54s F-test Using Excel Functions for a One-tailed Test 2m 42s Excel F-test Analysis Features 2m 49s F-Test Function Demonstration in Excel 3m 38s F-test Analysis Feature 2m 47s Using F-test Analysis Feature Demonstration in Excel 7m 15s Summary 1m 8s ANOVA: Analysis of Variance 56m 37s Description of ANOVA 3m 25s Hypothesis Testing with ANOVA 7m 49s Single Factor ANOVA Example 6m 0s Single Factor ANOVA on Excel 5m 14s ANOVA: Two-factor without Replication Example 5m 50s Two-factor ANOVA Without Replication in Excel 5m 45s ANOVA: Two-factor with Replication Example 9m 14s ANOVA: Two-factor with Replication in Excel 5m 10s Creating Graphs and Numerical Summaries for Two-factor ANOVAs 7m 27s Summary of ANOVA Lesson 0m 41s Regression 42m 42s Structure and Calculation of a Regression Analysis 9m 24s Regression Assumptions 4m 40s Fuel Consumption Example Calculations 8m 16s Drawing Conclusions and Checking Assumptions 6m 37s Set-up and Calculation of Regression Example in Excel 4m 0s Drawing Conclusions, Assumption Checking, and Regression Equation 9m 0s Summary of Regression Lesson 0m 43s
Об авторе
Brian is an energetic trainer and consultant with nearly 20 years of technical experience in datacenter management and design. As a virtualization instructor, Brian spends much of his time discussing the impact and intricacies of Software Defined Data Centers (SDDC), Software Defined Networking (SDN), and Software Defined Storage (SDS).
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}