Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
The Statistical Analysis Skills Training (SAST) in Excel
Introduction to the course
Your instructor (1:38)
Lecture 1: Welcome to the course (0:28)
Lecture 2: What will we learn in this course? (3:26)
Lecture 3: Why Excel is a good tool for Statistical Analysis? (1:52)
Lecture 4: What are the limitations of Excel as a tool for Statistical Analysis? (2:01)
Lecture 5: Steps to activate the Statistical Analysis Add-In in Excel (0:33)
Lecture 6: How to activate the Statistical Analysis Add-In in Excel (2:31)
Illustration for this course
Lecture 7: Download the Excel spreadsheet for this course (0:34)
Lecture 8: Lets look at the data for the illustration (1:50)
HISTOGRAM
Lecture 9: Conceptual understanding of Histogram (2:52)
Lecture 10: Illustration for HISTOGRAM analysis in Excel (1:41)
Lecture 11: Calculating the monthly return in Infosys share price (2:33)
Lecture 12: Calculating the Range for the HISTOGRAM analysis (2:18)
Lecture 13: Calculating the measures of central tendency of the data (1:40)
Lecture 14: Calculating the Data Range for the HISTOGRAM analysis (2:34)
Lecture 15: Undertaking the HISTOGRAM analysis in Excel (2:32)
Lecture 16: Decoding the HISTOGRAM analysis (1:24)
Lecture 17: Please provide us your valuable feedback on the course thus far
DESCRIPTIVE STATISTICS
Lecture 18: Conceptual understanding of DESCRIPTIVE STATISTICS (0:49)
Lecture 19: Illustration for the Descriptive Statistics analysis in Excel (0:52)
Lecture 20: Undertaking the DESCRIPTIVE STATISTICS analysis in Excel (2:48)
Lecture 21: Decoding the DESCRIPTIVE STATISTICS analysis (3:20)
Lecture 22: Please provide us your valuable feedback on the course thus far
CORRELATION
Lecture 23: Conceptual understanding of CORRELATION (2:34)
Lecture 24: Illustration for the CORRELATION analysis in Excel (1:24)
Lecture 25: Calculating the monthly return in Infosys share price (3:05)
Lecture 26: Calculating the monthly return in other indices of the data set (2:00)
Lecture 27: Undertaking the CORRELATION analysis in Excel (2:40)
Lecture 28: Decoding the CORRELATION analysis in Excel (5:01)
Lecture 29: Decoding the CORRELATION analysis in Excel contd. (2:34)
Lecture 30: Please provide us your valuable feedback on the course thus far
REGRESSION
Lecture 31: Conceptual understanding of REGRESSION (2:49)
Lecture 32: Illustration for REGRESSION analysis in Excel (1:55)
Lecture 33: Undertaking the REGRESSION analysis in Excel (2:27)
Lecture 34: Decoding the REGRESSION analysis in Excel (4:05)
Lecture 35: Please provide us your valuable feedback on the course thus far
MOVING AVERAGES
Lecture 36: Conceptual understanding of MOVING AVERAGES (1:44)
Lecture 37: Illustration for the MOVING AVERAGE analysis in Excel (0:47)
Lecture 38: Undertaking the MOVING AVERAGE analysis in Excel (2:31)
Lecture 39: Decoding the MOVING AVERAGE analysis (2:07)
Lecture 40: Please provide us your valuable feedback on the course thus far
End of course - what did we learn?
Lecture 41: Quick Recap (2:14)
Practice Assignment: DIFFICULTY LEVEL - MEDIUM
Lecture 42: Download the Practice Assignment for this course
Lecture 1: Welcome to the course