This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
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
Complete and Continue