BASIC PARAMETRIC TEST USING EXCEL

About this Course

Course Description

In this MOOC, learners will be introduced to fundamental and intermediate techniques of data analysis. The MOOC goes beyond theoretical concepts by exposing learners to practical applications through the utilization of Excel software. This hands-on approach enables learners to engage in the actual process of analysis and interpretation of output. By incorporating Excel software, the MOOC ensures that learners gain practical experience in implementing the methods learned, enhancing their ability to navigate and derive meaningful insights from real-world datasets. Through this comprehensive approach, learners not only acquire a theoretical understanding of statistical methods but also develop practical skills necessary for data analysis in various fields. The emphasis on both theoretical concepts and practical application equips learners with the knowledge and tools required to analyze and interpret data effectively, preparing them for real-world scenarios where data analysis skills are increasingly crucial.

Course Learning Outcomes

1 ) Determine appropriate method to solve given problems related to statistics.
2 ) Demonstrate interpersonal skills in a group work related to statistics.
3 ) Describe the concepts on given problems related to statistics.

Course Details

STATUS : Open
DURATION : FLEXIBLE
EFFORT : 5
MODE : 100% Online
COURSE LEVEL : Beginner
LANGUAGE : English
CLUSTER : Lifelong Learning ( LL )

 Syllabus

Introduction to parametric statistics.
The basic of hypothesis testing.
Statistical functions in Excel.

Introduction to t-test statistics.
One sample t-test.
Two sample t-test.
One/Two sample t-test function in Excel.

Introduction to paired t-test statistics.
Formulation for paired t-test.
Paired t-test function in Excel.

Introduction to Z-test statistics.
One sample Z-test.
Two sample Z-test.
Two sample Z-test function in Excel.

Introduction to ANOVA statistics.
One-way ANOVA test.
Two-way ANOVA test.
ANOVA function in Excel.

Our Instructor

MAHANIM BINTI OMAR

Course Instructor
UiTM Kampus Permatang Pauh

DR. SITI NURLEENA BINTI ABU MANSOR

Course Instructor
UiTM Kampus Permatang Pauh

DR. ROSLIZAWATI BINTI AHMAD

Course Instructor
UiTM Kampus Permatang Pauh

 Frequently Asked Questions

A1 : Basic parametric test statistics: t-test, paired t-test, Z-test and ANOVA.

A2 : Yes, there will be hands-on activity using Microsoft Excel.