Statistics and Data Analysis in Excel
- Offered byFutureLearn
Statistics and Data Analysis in Excel at FutureLearn Overview
Duration | 5 weeks |
Total fee | ₹900 |
Mode of learning | Online |
Credential | Certificate |
Statistics and Data Analysis in Excel at FutureLearn Highlights
- Earn a certificate of completion from CloudSwyft Global Systems, Inc.
Statistics and Data Analysis in Excel at FutureLearn Course details
- On this five-week course, you'll delve into applied statistics and learn how to use the powerful tools built into Excel to explore the core principles of statistics
- Learning from the specialists at CloudSwyft, a leading Learning-as-a-Service platform provider, you'll develop essential data science skills to improve your knowledge and confidence in the field
- On the course, you'll develop an understanding of the concepts of descriptive statistics and basic probability before learning how to apply them
- To develop your statistical skills further, you'll learn about the fundamentals of random variables, sampling, confidence intervals, and hypothesis testing - all key concepts in data analysis
Statistics and Data Analysis in Excel at FutureLearn Curriculum
Descriptive Statistics
About the Course
Defining Data
Histogram and Skewness
Descriptive Statistics with Analysis ToolPak
What is a Boxplot?
Categorical Data, PivotTables, and PivotCharts
Summarizing Heirarchal Data
80-20 Rule and Pareto Charts
Week 1 Test
Basic Probability
Introduction to Probability
Law of Complements
Mutually Exclusive Events and Finding Prob (A or B)
Conditional Probability
Law of Total Probability and Bayes Rule
Basic Probability Review
Week 2 Test
Random Variables
Random Variable Definitions
Mean, Variance, and Standard Deviation of a Random Variable
Mean, Variance, and Standard Deviation for Sum of Random Variables
Binomial Random Variable
Poisson Random Variable
Normal Random Variable
Central Limit Theorem
Z Scores
Week 3 Test
Sampling and Confidence Intervals
Populations and Samples
Point Estimation of a Population Mean and Proportion
The Standard Normal
Confidence Interval Estimation
Sample Size Determination
The Finite Correction Factor
Additional Reading
Week 4 Quiz
Hypothesis Testing
Defining Hypotheses
Type I and Type II Error
One Sample Z-Test
One Sample T-Test
Single Sample Test for Population Proportion
Testing Equality of Variances
Testing the Difference Between Two Population Means
Chi-Squared Test for Independence
Additional Reading
Week 5 Quiz
Wrapping Up the Course
Other courses offered by FutureLearn
Student Forum
Anything you would want to ask experts?