Pluralsight_Excel_2013_Analysis_Techniques_and_Random_Numbers

در این آموزش تصویری با تکنیک های آنالیز و اعداد تصادفی در Excel 2013 آشنا می شوید.
این دوره آموزشی محصول موسسه Pluralsight است.

سرفصل های دوره:

  • نحوه مدیریت اکسل
  • نحوه تجزیه و تحلیل داده ها
  • نحوه ساخت فرمول ها
  • نحوه تنظیم برنامه
  • ساخت اعداد تصادفی
  • کار با تابع RAND
  • کار با تابع RANDBETWEEN
  • انتخاب توزیعی اعداد
  • کار با آمار
  • استفاده از توابع آماری در اکسل
  • نحوه تجزیه و تحلیل داده ها
  • نحوه ساخت نمودار
  • نحوه پراکندگی نمودارها
  • ساخت نمودار Histogram
  • کار با جدول مقادیر بحرانی
  • به دست آوردن مقدار P-value
  • کار با آزمون t در اکسل
  • کار با آزمون Chi-square
  • آنالیز واریانس
  • آزمون Chi-square
  • تست فرضیه
  • نحوه استفاده از توابع
  • نحوه تجزیه و تحلیل برنامه
  • آزمون فرضیه با ANOVA
  • نحوه ایجاد نمودار
  • تحلیل رگرسیون
  • محاسبه رگرسیون در اکسل
  • و…

عنوان دوره: Pluralsight Excel 2013: Analysis Techniques and Random Numbers
سطح: متوسط
مدت زمان: 7 ساعت و 25 دقیقه
نویسنده: Brian Eiler


توضیحات:

Pluralsight Excel 2013: Analysis Techniques and Random Numbers

Brian Eiler
7h 25m
Intermediate



Analysis Techniques using What-If, Solver, graphing, functions and statistical features in Excel.

Add-ins for Excel 201
38m 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