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


DATA ANALYSIS VIDEOS

#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

#68.5 Sparklines to Compare Population & Sampling Distributions


Click on the cluster to view links organized into content clusters, EXCEL SKILLSDATA ANALYSISPROBABILITY, & INFERENCE.   





© Andrew Nelson 2012