Objective of this module is simple. In order to perform statistical data analysis, you need both Stat and a tool. This module puts them together. This covers solving common business stat problems in Microsoft Excel.
EXPECTED LEARNING OUTCOME
At the end of the following labs, students will be confident in drawing frequency distributions, 2-way tables, computing summary statistics for measuring central tendency and dispersion, and presenting data using tables and graphs all using Excel spreadsheets.
One 90 minutes webinar lecture session per each lab
One 90 minutes online doubt solving session per each lab
Access to video lessons for Additional References per each lab
One set of carefully selected problem sets per each lab
Searchable and dedicated discussion Forum thread for each lab
Grading and Overall Feedback video for each lab
Lab 1: Slicing and Dicing using Excel
Lab 2: Data Summary using Excel
Lab 3: Charts & Graphs using Excel
3 – 4 Weeks
Conveniently priced on per lab basis for a section of up to 60 students.
2-3 hours per week preferably during evening or weekends
Laptop with Microsoft Office 2007 or later, OR access to college computer lab, AND bandwidth.
SABA Primer (Excel Primer, Maths Primer and Stats Primer, R Primer) are prerequisite to undergo the remote labs courses.