University of Colorado Boulder - Statistics and Data Analysis with Excel, Part 1
- Offered byCoursera
Statistics and Data Analysis with Excel, Part 1 at Coursera Overview
Duration | 16 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Statistics and Data Analysis with Excel, Part 1 at Coursera Highlights
- Earn a certificate from Coursera
- Learn from industry experts
Statistics and Data Analysis with Excel, Part 1 at Coursera Course details
- Calculate descriptive statistics (traditional and robust estimators)
- Understand probability and apply probability rules
- Utilize statistical functions in Microsoft Excel
- Visualize univariate and bivariate data in Microsoft Excel
- Designed for students with no prior statistics knowledge, this course will provide a foundation for further study in data science, data analytics, or machine learning
- Topics include descriptive statistics, probability, and discrete and continuous probability distributions
- Assignments are conducted in Microsoft Excel (Windows or Mac versions). Designed to be taken with the follow-up course, Statistics and Data Analysis with Excel, Part 2
Statistics and Data Analysis with Excel, Part 1 at Coursera Curriculum
WELCOME!
Welcome to the Course!
How the Course Works
Introduction to Statistics
The Importance of a Course Certificate and the Future of Higher Education
Auditing the Course vs. Purchasing a Course Certificate
Do Your Excel Skills Need Work?
What Version of Excel Do You Need for This Course?
Is It "Data Are" or "Data Is"?
Week 2 Excel Files
Week 1 Graded Quiz
Unlock Quiz for Week 2 Files
What About You?
Descriptive Statistics and Graphical Representation of Data
Difference Between Population and Sample
What is the Summation Symbol?
Descriptive Statistics
Quartiles and Percentiles
Univariate vs. Bivariate Data
Categorical vs. Numerical Data
Histograms
Scatter Plots in Excel, Part 1
Scatter Plots in Excel, Part 2
Column and Pie Charts in Excel
Time Series Plots
Box Plots
Cleaning Data in Excel
Data Transformations
Robust Estimators
Removing Outliers
Guided Workshop 2: Creating a Histogram in Excel
Week 2 Cheat Sheet
Guided Workshop 2
Week 2 Practice Quiz
Guided Workshop 2 Submission
Week 2 Graded Quiz
Probability
Introduction to Probability: Part 1
Introduction to Probability: Part 2
Sample Spaces and Events
Permutations and Combinations
How to Use the PERMUT and COMBIN Functions in Excel
Probability Rules
Conditional Probability
Multiplication Rule
Total Probability Rule
Bayes' Theorem
Guided Workshop 3: Bayes' Theorem and Diagnostic Testing
Week 3 Cheat Sheet
Guided Workshop 3
Week 3 Practice Quiz
Guided Workshop 3 Submission
Week 3 Graded Quiz
Discrete Probability Distributions
Introduction to Discrete Probability Distributions
Probability Distributions
The Binomial Distribution
The Geometric Distribution
The Negative Binomial Distribution
Excel's NEGBINOM.DIST Function
The Hypergeometric Distribution
The Multinomial Distribution
The Poisson Distribution
Joint and Marginal Probability Distributions
Conditional Probability Distributions
Closing the Loop
Guided Workshop 4: Modeling Traffic Data
Excel Functions For Discrete Distributions
Week 4 Cheat Sheet
Guided Workshop 4
Week 5 Excel Files
Week 4 Practice Quiz
Guided Workshop 4 Submission
Week 4 Graded Quiz
Continuous Probability Distributions
Introduction to Continuous Distributions
Continuous Variables and Distributions
The Uniform Distribution
The Normal Distribution
Standardizing and Z-Values, Part 1
Standardizing and Z-Values, Part 2
Inverse Normal Distribution Calculations
Exponential Distribution
Other Continuous Distributions
Example: Beta-PERT Distribution
Probability Plots
How to Use the "Probability plot.xlsx" File
Closing the Loop
Guided Workshop 5: Fitting Data to the Gamma Distribution
Excel Functions For Continuous Distributions
Percentage Points of the Standard Normal Distribution (Table)
Week 5 Cheat Sheet
Guided Workshop 5
Week 5 Practice Quiz
Guided Workshop 5 Submission
Week 5 Graded Quiz
Final Graded Quiz
Statistics and Data Analysis with Excel, Part 1 at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?
Data ScienceData Science BasicsStatistics for Data ScienceStatistics and Data Analysis with Excel, Part 1