Statistics and Data Analysis with Excel, Part 2

Software > Computer Software > Educational Software University of Colorado Boulder

Course Overview

What You'll Learn

  • This course is meant to be a direct continuation of "Statistics and Data Analysis with Excel, Part 1." Therefore, it is not recommended to take Part 2 unless you've also taken Part 1.
  • Building on the topics learned in Part 1 of the course (probability, probability mass and density functions, the normal and standard normal distributions), this course dives into a more applied side of statistics.
  • Topics in Part 2 include sampling distributions; one-sample hypothesis tests on the mean, variance, and binomial proportion; two-sample hypothesis tests (comparison of means, variances, and binomial proportions of samples drawn from two populations); simple (straight-line) regression; multilinear regression; and analysis of variance (ANOVA).

This course is meant to be a direct continuation of "Statistics and Data Analysis with Excel, Part 1." Therefore, it is not recommended to take Part 2 unless you've also taken Part 1. Building on the topics learned in Part 1 of the course (probability, probability mass and density functions, the normal and standard normal distributions), this course dives into a more applied side of statistics. Topics in Part 2 include sampling distributions; one-sample hypothesis tests on the mean, variance, and binomial proportion; two-sample hypothesis tests (comparison of means, variances, and binomial proportions of samples drawn from two populations); simple (straight-line) regression; multilinear regression; and analysis of variance (ANOVA). Statistical techniques are taught with the help of Microsoft Excel, which is an intuitive software package that has many built-in functions and tools for statistical analysis. This course is the second course out of three that comprise the specialization "Statistics and Applied Data Analysis." Course 3 ("Statistics and Data Analysis with R") focuses on statistical analysis in the statistical software package RStudio.

Course FAQs

Is this an accredited online course?

Accreditation for 'Statistics and Data Analysis with Excel, Part 2' is determined by the provider, University of Colorado Boulder. For online college courses or degree programs, we strongly recommend you verify the accreditation status directly on the provider's website to ensure it meets your requirements.

Can this course be used for continuing education credits?

Many of the courses listed on our platform are suitable for professional continuing education. However, acceptance for credit varies by state and licensing board. Please confirm with your board and {course.provider} that this specific course qualifies.

How do I enroll in this online school program?

To enroll, click the 'ENROLL NOW' button on this page. You will be taken to the official page for 'Statistics and Data Analysis with Excel, Part 2' on the University of Colorado Boulder online class platform, where you can complete your registration.