ref.bus.308.as.1001 Statistics

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



Ed's Multimedia Presentations:


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:
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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:         

Descriptive Statistics (4:16 min:sec)

Normal Frequency Distribution (2:48)

Correlation (5:19) Regression (3:17)

Standard scores (Z-scores) (2:24)

Student's t-test (2:58) Chi-square test (2:56)

Microsoft Excel Analysis Tool-Pak (2:28)  




Comments