Statistics for Data Analysis Using Excel
About this course
Get marketable data analytic skills in this course using Microsoft Excel.This course is about Statistics and Data Analysis. The course will teach you the basic concepts related to Statistics and Data Analysis, and help you in applying these concept. Various examples and data-sets are used to explain the application.I will explain the basic theory first, and then I will show you how to use Microsoft Excel to perform these calculations.Many tests covered, including different t tests, ANOVA, post hoc tests, correlation, and regression.Following areas of statistics are covered:Descriptive Statistics - Mean, Mode, MedianVariability - Standard Deviation, Variance, RangePopulation and SamplingProbability Distributions Hypothesis Testing - One Sample and Two Samples - z Test, t Test, p Test, F Test, Chi Square TestANOVA - Perform Analysis of Variance (ANOVA) step by step doing manual calculation and by MS Excel.Learning Objectives:Explain how to calculate simple probability.Review the Excel statistical formulas for finding mean, median, and mode.Differentiate statistical nomenclature when calculating variance.Identify components when graphing frequency polygons.Explain how t-distributions operate.Describe the process of determining a chi-square.Enroll in this course and obtain important marketable data analytic skills
63/100
CourseAsk score
- What the provider tells you
- 39/45
- Who stands behind it
- 8/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- calculate simple probability
- find mean, median, and mode using Excel
- differentiate statistical nomenclature when calculating variance
- graph frequency polygons
- understand t-distributions
- determine a chi-square
Course objectives
- explain basic concepts of statistics
- perform analysis using Excel
- execute various statistical tests including t tests and ANOVA
Price shown by Udemy — confirm on their site.
Enroll on UdemyYou'll be redirected to Udemy to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
Compared on these lists
Where this course ranks against the alternatives.