Statistics / [ref.bus.308.as.1001]

Advertisement: Interested in tutoring assistance? Contact tutoringservices1000@gmail.com.

APA Reference Style (How to Avoid Plagiarism)

Prof. Ed's videos

Installing the Data Analysis Add-in in Excel 2016
Week Two Assignment Question 1 Walk Through: Descriptive Statistics (13:22)
Week Two Assignment Question 2 Walk Through:  Probabilities (7:28)
Descriptive Statistics versus Inferential Statistics (image)
Computing Averages Using Excel (Example using Average Sales Per Product) (4:53 min:sec)  
Installing Excel AddIns with Office Excel 2007 (2:07)  
Descriptive Statistics - Illustration of How to Use it with Excel 2007 (part of Assignment 1, although it may be outdated) (2:46)
Descriptive Statistics - Using Analysis Tool Pack (Assignment 1 first part) (5:40) *
Descriptive Statistics - Average, Standard Deviation, Minimum, Maximum (Example using Airline Passenger Information) (4:44)
Combination Rule - Probability of Selecting Face Cards from a Full Deck of Cards (6:49)
Probability of a z-score Falling Within a Given Range (3:20)
Correlation Coefficient, Scattergraph and Coefficient of Determination (7:11)
Frequency Distribution and Histogram (9:55)
Excel Ttest (4:16) Excel Ttest Using Analysis Pak (t-values) (3:15)
Finding the Frequency of Occurrence Using Excel (5:49)
Probabilities and Z-Scores (2:36) Mean, Sample Variance, Standard Deviation, Z-score (3.22) (13:35)
Finding z-values, using an online z-value calculator (1:56)
Probability Distribution - Discrete Random Variables (5.12) (7:58)
Confidence Intervals - Known Sample Mean (8.8) (4:16)
Confidence Intervals - Approach to Use (image only)
Hypothesis Testing (9:13) (4:36) *
Hypothesis Testing When the Population Mean is Known (5:45)
Linear Regression - Excel Statistics Data Provided (image only)
Linear Regression - Estimating Confidence Intervals (image)
Multiple Linear Regression - Excel Example Using 3 independent variables (7:09)  
Additional resources from the Excel Master Series:

Other videos:

Overview of Normal Distribution - http://blog.excelmasterseries.com/2014/06/overview-of-normal-distribution_3.html
 
Overview of the t Distribution - http://blog.excelmasterseries.com/2014/06/overview-of-t-distribution.html
 
1-Sample z-Tests in Excel - http://blog.excelmasterseries.com/2014/06/1-sample-z-test-in-excel-2010-and-excel.html
 
1-Sample t-Tests in Excel - http://blog.excelmasterseries.com/2014/05/1-sample-t-test-in-excel-2010-and-excel.html
 
2-Sample Pooled t-Tests in Excel - http://blog.excelmasterseries.com/2014/05/2-sample-pooled-t-test-in-excel-2010.html
 
Paired t-Tests in Excel - http://blog.excelmasterseries.com/2014/05/paired-t-test-in-excel-2010-and-excel_28.html
 
Pearson Correlation in Excel - http://blog.excelmasterseries.com/2014/05/pearson-correlation-in-excel-2010-and.html
 
Spearman Correlation in Excel - http://blog.excelmasterseries.com/2014/05/spearman-correlation-coefficient-in.html
 
Simple Linear Regression in Excel - http://blog.excelmasterseries.com/2014/05/simple-linear-regression-example-in.html
 
Multiple Regression in Excel - http://blog.excelmasterseries.com/2014/05/multiple-linear-regression-example-in.html
 
Single-Factor ANOVA in Excel - http://blog.excelmasterseries.com/2014/05/single-factor-anova-example-in-excel.html
 
Two-Factor ANOVA With Replication in Excel - http://blog.excelmasterseries.com/2014/05/two-factor-anova-with-replication-in.html
 
Two-Factor ANOVA Without Replication in Excel - http://blog.excelmasterseries.com/2014/05/two-factor-anova-without-replication-in.html
 
Repeated-Measures ANOVA in Excel - http://blog.excelmasterseries.com/2015/01/single-factor-repeated-measures-anova.html
 
ANOVA With Randomized Block Design in Excel - http://blog.excelmasterseries.com/2015/01/randomized-block-design-anova-in-excel.html
 
Chi-Square Independence Test in Excel - http://blog.excelmasterseries.com/2014/05/chi-square-independence-test-in-excel.html
 
Chi-Square Goodness-of-Fit-Test For Normality in Excel - http://blog.excelmasterseries.com/2014/05/chi-square-goodness-of-fit-normality.html

Elementary Statistics Video Lectures and Examples:

Intro to Statistics - Overview (1:08) Intro to Statistics - Types of Data (4:47)
Intro to Statistics - Design of Experiments (4:47)
Describing Data - Frequency Distribution (4:38)
Describing Data - Visualizing Data (6:06)
Measures of Center (Mean, Mode, more) (7:19)
Mesures of Relative Standing (5:24) Probability - Fundamentals (6:26)
Probability - Addition Rules (4:44)
Probability - Multiplication Rule (7:59) Probability - Multiplication Rule - Example  (7:59)
Probability - Counting (7:43) Probability - Counting - Example (1:44)
Probability Distribution - Random Variables (8:58) Probability Distribution - Example (6:38)
Probability Distribution - Expected Value - Example (2:56) Probability Distribution - Binomial Distributions (10:48)
Probability Distribution - Binomial Distributions - Example (6:38)
Normal Probability Distributions - Standard Normal (14:14)
Normal Probability Distributions - Standard Normal - Example (5:32)
Normal Probability Distributions - Central Limit Theorem (7:33)
Normal Probability Distributions - Central Limit Theorem - Example (8:27)
Estimates and Sample Sizes - Population Proportion (11:04)
Comparing Multiple Sample Means (18:41)
Estimates and Sample Sizes - Population Mean - Sigma Known  (7:55)
Estimates and Sample Sizes - Finding a Z-Confidence Interval (2:51)
Estimates and Sample Sizes - Populiation Mean - Sigma Unknown (10:55)
Estimates and Sample Sizes - Finding a t-Confidence Interval (3:28)
Hypothesis Testing - Basics (13:01) Hypothesis Testing - Testing a Claim About a Proportion (5:49)
Hypothesis Testing - Testing a Claim About a Proportion - Example (3:08)
Hypothesis Testing - Testing a Claim About a Mean - Sigma Known (3:22)
Hypothesis Testing - Testing a Claim About a Mean - Sigma Known - Example (2:38) T
Type I and Type II Errors explained - see http://en.wikipedia.org/wiki/Type_I_and_type_II_errors       

Statistic Lectures: