Excel 2010 Videos: Courtesy of Slaying Excel Dragons (Michael Girvin, Highland CC)

These links are in numerical order of presentation.  Click on the cluster to view links organized into content clusters, EXCEL SKILLS, DATA ANALYSIS, PROBABILITY, & INFERENCE.   

ALL VIDEOS IN NUMERIC ORDER

 #2 Data Analysis Add-on

#3 Calculations, Formulas, Functions, Math & Comparative Operators

#4 Number Formatting

#5 Data Sets Set-up &Terminology

#6 Sorting & Pivot Tables

#7 Chart Basics: Pie, Column, Bar, Line, X-Y Scatter 

#8 Cell References in Formulas: Relative & Absolute

#9 Proportions, Probabilities & Percentages: Formulas & Formatting 

#10 Percentage Change & Ending Balance Formulas 

#11 What is Statistics?

#12 Data Sets, Excel Tables For Formulas & Charts, Cross Sectional, Time Series

#13 Scales Of Measurement: Nominal, Ordinal, Interval & Ratio 

#14 Descriptive & Inferential Statistics

#15 Frequency Distributions, Histograms, Column Charts

#16 Relative & Percent Frequency Distributions & Pie Chart & Histogram

#17  Ogive Chart Formula, Pivot Table, Data Analysis Toolpak Add-on & Pareto

#18 Frequency Distribution Shape, Histogram Skew & Sparklines

#19 Dot Plot Chart With With REPT and COUNTIFS Functions

#20 Stem and Leaf Chart With LEPT and COUNTIFS Functions

#21 Cross Tabulation With Pivot Table Frequencies & % Column & % Row

#22 Cross Tabulation With Formulas 

#23 Scatter Plot to Show Relationship Between Two Quantitative Variables 

#24 Conditional Formatting Cell Chart Histogram

#25 Typical Values: Mean, Median, Mode

#26 Location: Mean, Median, Mode, Percentile, Quartile, Percentile Rank

#27 Excel 2010 For Percentile, Quartile, and Rank

#28 Box & Whisker Plot: Stacked Bar With Mean Point Plotted & Outlier Lines

#29 Means: Weighted, Trimmed, From Grouped Data, Geometric Mean 

#30 Standard Deviation: How fairly does the mean respresent its data points?

#31 Z-Score, Chebyshev's Theorem & Empirical Rule

#32 Detecting Outliers

#33 SKEW Function, Relationship Between Mean, Median & Mode, and Skew

#34 Data Analysis Add-In Descriptive Statistics Tool

#35 Probability Basics (Written Notes)

#36 Probability Basics With Excel  

#37 Probability Laws - Adding, Multiplying & More (Handwritten Notes)

#38 Probability Laws In Excel - Adding, Multiplying & More

#39 HYPGEOM.DIST and Conditional Probabilities 

#40 Joint Probability (Two-Way) Table & More

#41 Joint Probability Table With PivotTable

#42 Bayes Theorem Posterior Probabilities & SUMPRODUCT

#43 Further Explanation of Bayes' Theorem & Posterior Probabilties

#44 Discrete Probabilty Distributions Basics (Hand Written Notes)

#45 Build Discrete Probability Distribution

#46 Discrete Probability Chart With Two Data Sets

#47 Discrete Probability Mean & Standard Deviation

#48 Accounting & Finance Examples of Expected Value & Standard Deviation

#49 Binomial Experiment, Probabilities, Chart & BINOM.DIST Function 

#50 BINOM.DIST Function (3 Examples) Mean & Standard Deviation for BD

#51 How Shape of Binomial Distribution Changes as n and p Change?

#52 Cumulative BINOM.DIST Chart with IF Function

#53 POISSEN.DIST function Poissen Probability Distribution

#54 Continuous Probability Distributions (Hand Written Notes)

#55 Uniform Probability Distributions

#56 Normal (Bell) & Standard Normal Characteristic (Hand Written Notes)

#57 NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV Functions Bell Curve

#58 Charting Normal Bell Curve in Excel With X and Z Values  & Dynamic Ranges

#59 Normal Bell Probabilities Above X and Area Charts To Show Area Above X

#60 Normal Bell Probabilities Between 2x or Z Values Area Charts & Functions

#61 Find X Given Normal Probabilties NORM.INV & NORM.S.INV Functions

#62 Calculating Bell Normal Distribution Probabilities & X Values 10 Examples

#63 Exponential Probability EXPON.DIST Function

#64 Relationship Between Poissen & Exponential Probablility Distributions

#65 Sample Mean Xbar and Probability, Not X Values

#66 Simple Random Sample Using RAND Function, Sort and Copy Paste

#67 Formula To Extract A Simple Random Sample

#68 Construct Sampling Distribution of Sample Means (Xbar)

#68.5 Sparklines to Compare Population & Sampling Distributions

#69 Probability That Sample Mean Occur With Given Margin of Error (3 Examples)

#70 Standard Error & Correction Factor For Finite Populations

#71 Sampling Distribution of Xbar As Sample Size Increase Probability Increase

#72 Sampling Distribution of Sample Proportion

#73 Introduction to Confidence Intervals

#74 Confidence Intervals (Population Standard Deviation KNOW: NORM.S.INV, CONFIDENCE.NORM

#75 Confidence Intervals (Population Standard Deviation UNKNOWN Known): T.INV, CONFIDENCE.T

#76 Confidence Interval To Estimate Population Proportion: NORM.S.INV

#77 Determine Sample Size

#78 Hypothesis Testing Population Mean, P-Value & Critival Value, One Tail Right

#79 One Tail Left Z Distribution Mean Hypothesis Testing P-Value Critical Value

#80 Two Tail Left Z Distribution Mean Hypothesis Testing P-Value Critical Value

#81 NORM.S Functions Hypothesis Tesing P-Value & Critical Values

#82 One Tail Right T  Distribution Mean Hypothesis Testing P-Value Critical Value

#83 One Tail Left T  Distribution Mean Hypothesis Testing P-Value Critical Value

#84 Two Tail  T  Distribution Mean Hypothesis Testing P-Value Critical Value

#85 T  Functions Hypothesis Testing P-Value Critical Value

#86 Confience Intervals For Proportions

#87 Sample Size For Confidence Intervals

#88 Confidence Interval & Hypothesis Tests

#89 Hypothesis Tesing With Critical Value & P-Value

#90 NORMSINV For Critical Value NORMDIST For P-Value (Six Examples)

#91 TINV  & TDIST Functions For Critical  Value & P-Value (Six Examples)

#92 Hypothesis Test T Distribution

#93 Hypothesis Test  Proportions





© Andrew Nelson 2012