Skip to content
CourseAsk.
Statistics for Data Analysis Using Excel
Udemy Certificate 0

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

C

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
Data Analysis Statistics & Probability #regression #excel #hypothesis testing #descriptive statistics #variance #data analysis #statistics #probability #data sets #t-test #anova #chi-square #correlation #mean #median #mode
$199.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'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.