1
Excel 2010 Statistics 01: Introduction To Excel 2010 For Statistics
19:05
2011-06-17
2
Excel 2010 Statistics 02: Excel 2010 Data Analysis Add-in
1:38
2011-06-17
3
Excel 2010 Statistics 03: Calculations, Formulas, Functions, Math & Comparative Operators
29:31
2011-06-17
4
Excel 2010 Statistics 04: Number Formatting As Façade Accounting Percentage Proportion Probability
15:12
2011-06-17
5
Excel 2010 Statistics 05: Data Sets How They Are Setup & Terminology In Statistics & Data Analysis
4:16
2011-06-17
6
Excel 2010 Statistics 06: Data Analysis: Sorting and PivotTables
23:14
2011-06-17
7
Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatter
31:49
2011-06-17
8
Excel 2010 Statistics 08: Cell References In Formulas: Relative and Absolute
11:24
2011-06-17
9
Excel 2010 Statistics 09: Proportions, Probabilities and Percentages: Formulas and Formatting
10:31
2011-06-17
10
Excel 2010 Statistics 10: Percentage Change and Ending Balance Formulas
10:19
2011-06-22
11
Excel 2010 Statistics 11: What Is Statistics?
12:31
2011-06-22
12
Excel 2010 Statistics 12 Data Sets, Excel Tables For Formulas & Charts, Cross Sectional, Time Series
24:20
2011-06-22
13
Excel 2010 Statistics 13: Scales Of Measurement: Nominal, Ordinal, Interval, Ratio
14:14
2011-06-22
14
Excel 2010 Statistics 14: Descriptive & Inferential Statistics
9:04
2011-06-22
15
Excel 2010 Statistics #15: Frequency Distributions, Histograms, Column Charts (11 Examples)
1:18:29
2011-06-30
16
Excel 2010 Statistics #16: Relative & Percent Frequency Distributions & Pie Chart & Histogram
17:21
2011-07-01
17
Excel 2010 Statistics #17 Ogive Chart Formula PivotTable Data Analysis Toolpak Add-in & Pareto Chart
35:11
2011-07-01
18
Excel 2010 Statistics #18: Frequency Distribution Shape & Histogram Skew & Sparklines
15:06
2011-07-01
19
Excel 2010 Statistics #19: Dot Plot Chart with REPT and COUNTIFS functions
10:38
2011-07-01
20
Excel 2010 Statistics #20: Stem and Leaf Chart with REPT and COUNTIFS functions
8:22
2011-07-01
21
Excel 2010 Statistics #21: Cross Tabulation With PivotTable Frequencies and % Column & % Row
15:13
2011-07-01
22
Excel 2010 Statistics #22: Cross Tabulation With Formulas
5:00
2011-07-01
23
Excel 2010 Statistics #23: Scatter Diagram to show Relationship Between Two Quantitative Variables
9:28
2011-07-01
24
Excel 2010 Statistics #24: Conditional Formatting Cell Chart Histogram
2:57
2011-07-07
25
Excel 2010 Statistics #25: Typical Values: Mean, Median, Mode
27:51
2011-07-07
26
Excel 2010 Statistics #26: Location: Mean, Median, Mode, Percentile, Quartile, PercentileRank
12:53
2011-07-07
27
Excel 2010 Statistics #27: Excel 2010 Functions for Percentile, Quartile and Rank
23:36
2011-07-07
28
Excel 2010 Statistics #28: Box & Whisker Plot: Stacked Bar with Mean Point Plotted and Outlier Lines
22:48
2011-07-07
29
Excel 2010 Statistics #29: Means: Weighted, Trimmed, From Grouped Data, Geometric Mean
15:33
2011-07-07
30
Excel 2010 Statistics #30: Standard Deviation: How fairly does the mean represent its data points?
41:35
2011-07-07
31
Excel 2010 Statistics #31: z-Scores, Chebyshev's Theorem and Empirical Rule
28:11
2011-07-07
32
Excel 2010 Statistics #32: Detecting Outliers
6:12
2011-07-07
33
Excel 2010 Statistics #33: SKEW function, Relationship between Mean Median & Mode and Skew
6:23
2011-07-07
34
Excel 2010 Statistics #34: Data Analysis Add-in Descriptive Statistics tool
2:54
2011-07-07
35
Excel 2010 Statistics #34.5: Z-Score IF, Standard Deviation IF, Mean IF, Mode IF, Median IF
15:42
2011-07-11
36
Excel 2010 Statistics #35: Probability Basics (by hand notes)
23:39
2011-07-12
37
Excel 2010 Statistics #36: Probability Basics with Excel
31:18
2011-07-12
38
Excel 2010 Statistics #37: Probability Laws (by hand notes) Adding, Multiplying and More
16:29
2011-07-12
39
Excel 2010 Statistics #38: Probability Laws in Excel, Adding, Multiplying, Conditional Probability
11:24
2011-07-12
40
Excel 2010 Statistics #39: HYPGEOM.DIST and Conditional Probabilities New Excel 2010 Function
9:58
2011-07-12
41
Excel 2010 Statistics #40: Joint Probability Table and More!
11:54
2011-07-12
42
Excel 2010 Statistics #41: Joint Probability Table with PivotTable
9:11
2011-07-12
43
Excel 2010 Statistics 42: Bayes' Theorem Posterior Probabilities & SUMPRODUCT
6:26
2011-07-12
44
Excel 2010 Statistics 43: Further Explanation of Bayes' Theorem & Posterior Probabilities
11:36
2011-07-12
45
Excel 2010 Statistics 44: Discrete Probability Distributions (Basics)
18:59
2011-07-15
46
Excel 2010 Statistics 45: Build Discrete Probability Distribution
20:09
2011-07-15
47
Excel 2010 Statistics 46: Discrete Probability Chart with 2 Data Sets
6:46
2011-07-15
48
Excel 2010 Statistics 47: Discrete Probability Mean & Standard Deviation
18:07
2011-07-15
49
Excel 2010 Statistics 48: Accounting & Finance Examples of Expected Value & Standard Deviation
17:25
2011-07-15
50
Excel 2010 Statistics 49: Binomial Experiment, Probabilities, Chart and BINOM.DIST Function
31:56
2011-07-15
51
Excel 2010 Statistics 50: BINOM.DIST Function (3 Examples) Mean & Standard Deviation for BD
29:08
2011-07-18
52
Excel 2010 Statistics 51: How Shape Of Binomial Distribution Changes As n And p Change
3:36
2011-07-15
53
Excel 2010 Statistics 52: Cumulative BINOM.DIST Chart with IF Function
16:37
2011-07-15
54
Excel 2010 Statistics 53: POISSON.DIST function Poisson Probability Distribution
15:38
2011-07-15
55
Excel 2010 Statistics 54: Continuous Probability Distributions (Basics)
17:06
2011-07-19
56
Excel 2010 Statistics 55: Uniform Probability Distributions
14:01
2011-07-19
57
Excel 2010 Statistics 56: Normal (Bell) & Standard Normal Characteristics
13:40
2011-07-19
58
Excel 2010 Statistics 57: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV Functions Bell Curve
16:31
2011-07-19
59
Excel 2010 Statistics 58: Charting Normal Bell Curve In Excel With X and Z Values & Dynamic Ranges
20:17
2011-07-19
60
Excel 2010 Statistics 59: Normal Bell Probabilities Above X & Area Charts To Show Area above X
15:45
2011-07-19
61
Excel 2010 Statistics 60: Normal Bell Probabilities Between 2 X or Z Values Area Charts & Functions
17:48
2011-07-19
62
Excel 2010 Statistics 61: Find X Given Normal Probabilities NORM.INV & NORM.S.INV Functions
7:13
2011-07-19
63
Excel 2010 Statistics 62: Calculating Bell Normal Distribution Probabilities & X Values 10 Examples
13:27
2011-07-19
64
Excel 2010 Statistics 63: Exponential Probability EXPON.DIST function
8:15
2011-07-19
65
Excel 2010 Statistics 64: Relationship Between Poisson & Exponential Probability Distributions
14:02
2011-07-22
66
Excel Magic Trick 839: Standard Deviation At Each New Value In Column
6:04
2011-12-15
67
Excel Magic Trick 841: One Standard Deviation Above Mean, Count & Conditional Format Values
4:44
2011-12-15
68
Excel 2010 Statistics 65: Sample Mean Xbar and Probability, Not X values
5:08
2012-02-04
69
Excel 2010 Statistics 66: Simple Random Sample Using RAND Function, Sort and Copy Paste
6:47
2012-02-04
70
Excel 2010 Statistics 67: Formula To Extract Simple Random Sample
8:29
2012-02-04
71
Excel 2010 Statistics 68: Construct Sampling Distribution Of Samples Means (Xbar)
27:00
2012-02-04
72
Excel 2010 Statistics 68.5: Sparklines to Compare Population and Sampling Distributions
1:38
2012-02-04
73
Excel 2010 Statistics 69: Probability That Sample Mean Occur w/ Given Margin Of Error (3 Examples)
16:24
2012-02-04
74
Excel 2010 Statistics 70: Standard Error and Correction Factor For Finite Populations
5:52
2012-02-04
75
Excel Magic Trick 861: Conditional Format 50 Columns w Format Painter +/- 1 Standard Deviation
10:23
2012-01-18
76
Excel 2010 Statistics 71: Sampling Distrib. Of X Bar As Sample Size Increase Probability Increase
8:40
2012-02-04
77
Excel 2010 Statistics 73: Introduction To Confidence Intervals
14:50
2012-02-21
78
Excel 2010 Statistics 72: Sampling Distribution of Sample Proportion
9:57
2012-02-04
79
Excel 2010 Statistics 74: Confidence Intervals Sigma Known: NORM.S.INV, CONFIDENCE.NORM Functions
11:03
2012-02-21
80
Excel 2010 Statistics 75 Confidence Intervals Sigma NOT Known T.INV, CONFIDENCE.T & Analysis Add-in
22:00
2012-02-21
81
Excel 2010 Statistics 76: Confidence Interval To Estimate Population Proportion: NORM.S.INV Function
12:28
2012-02-21
82
Excel 2010 Statistics 77: Determine Sample Size
7:17
2012-02-21
83
Excel 2010 Statistics 78: Hypothesis Testing Population Mean, P-value & Critical Value, 1 Tail Right
41:22
2012-03-13
84
Excel 2010 Statistics 79: 1 Tail Left z Distribution Mean Hypothesis Testing P-value Critical Value
13:44
2012-03-15
85
Excel 2010 Statistics 80: Two Tail z Distribution Mean Hypothesis Testing P-value Critical Value
13:29
2012-03-15
86
Excel 2010 Statistics 81: NORM.S Functions Hypothesis Testing p-value & Critical Values 7 Examples
9:30
2012-03-15
87
Excel 2010 Statistics 82: 1 Tail Right t Distribution Mean Hypothesis Testing P-value Critical Value
13:57
2012-03-15
88
Excel 2010 Statistics 83: 1 Tail Left t Distribution Mean Hypothesis Testing P-value Critical Value
9:45
2012-03-15
89
Excel 2010 Statistics 84: Two Tail t Distribution Mean Hypothesis Testing P-value & Critical Value
11:08
2012-03-15
90
Excel 2010 Statistics 85: T Functions Hypothesis Testing for p-value & Critical Values 11 Examples
11:42
2012-03-15
91
Excel 2010 Statistics 86: Hypothesis Test for Proportions using p-value or Critical Value
10:38
2012-03-15
92
Excel 2010 Statistics 87: Linear Regression #1: Scatter Diagram: Relationship Between 2 Variables?
17:00
2012-06-04
93
Excel 2010 Statistics 88: Linear Regression #2: Scatter Plot with Trendline & X and Y Mean Lines
12:04
2012-06-04
94
Excel 2010 Statistics 89: Linear Regression #3: Sample Covariance & Coefficient of Correlation
19:59
2012-06-04
95
Excel 2010 Statistics 90: Linear Regression #4: Calculate Slope, Y-Intercept, Estimated Equation
18:37
2012-06-04
96
Excel 2010 Statistics 91: Linear Regression #5: Coefficient of Determination: Goodness of Fit
18:03
2012-06-04
97
Excel Magic Trick 1035: Calculate Median with 1 condition with AGGREGATE & PERCENTILE.INC function
5:56
2013-08-05
98
Excel Magic Trick 1046: Linear Regression Estimate & Add Many Predicted Y-Values Single Cell Formula
1:53
2013-08-17
99
Highline Excel 2013 Class Video 46: Statistics: Histogram Formulas & Chart in Excel 2013
12:35
2013-12-22
100
Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently
13:06
2014-05-23
101
Excel Magic Trick 1117: Calculate Average For Each Sample: AVERAGEIFS, PivotTable, or OFFSET
11:03
2014-05-23
102
Excel Magic Trick 1135: Rank Values From Two Columns: RANK.AVE, RANK.EQ & RANK Functions
7:43
2014-07-28
103
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
9:49
2014-07-30