Introduction to statistics (in Excel)

Course Description

This course is designed specifically for beginners who are taking their first steps into the world of statistics. We’ll introduce you to key statistical concepts using examples in Microsoft Excel, making it easier to understand and apply these principles in everyday scenarios. Whether you’re working in business, research, or just curious to learn, this course will provide a solid foundation. Let’s EXCELerate your brainpower and make statistics fun!

Course Content:

Introduction:

• Choosing a Sample Size: Learn how to determine the appropriate sample size for your study to ensure reliable results.
• Measurement Accuracy: Understand the importance of accuracy in measurements and its impact on statistical results.

Basic Statistical Measures:

• Get to grips with measures such as mean, median, mode, and variance, and learn how to calculate them in Excel.

Data Plots:

• Visualizing data is key to understanding it. We will cover how to create effective charts and graphs in Excel to represent your data clearly.

Hypotheses and Testing:

• P-value: Learn what a p-value is and how to use it in hypothesis testing.
• Confidence Interval: Understand the concept of confidence intervals and how to calculate them in Excel.
• Statistical Power: Gain insights into statistical power and why it matters for the validity of your tests.

Correlation:

• Explore how two variables relate to each other, and use Excel to measure the strength and direction of their relationship.

Regression:

• Discover the basics of regression analysis and how to create linear regression models in Excel to predict outcomes based on input data.

This course is perfect for anyone who is new to statistics and wants to understand the basic concepts in a user-friendly environment like Excel. So, if you’ve ever wanted to make sense of all those numbers and charts, this is the perfect place to start. Let’s turn Excel into your personal data analysis tool and have some fun along the way!