Perform Basic Statistical Analysis in Microsoft Excel

Focused View

Amruta Mahajan

14:32

0 View

01. Introduction to Statistical Analysis.mp4

02:29

02. Understanding Your Data.mp4

01:03

03. Calculating the Mean.mp4

01:02

04. Demo - Calculating the Mean.mp4

01:19

05. Calculating the Median.mp4

01:09

06. Demo - Calculating the Median.mp4

01:25

07. Calculating the Mode.mp4

01:03

08. Demo - Calculating the Mode.mp4

01:34

09. Calculating the Standard Deviation.mp4

01:17

10. Demo - Calculating the Standard Deviation.mp4

02:11

exercise.zip

Description

Learn the essentials of statistical analysis in Microsoft Excel. This course will teach you how to calculate the mean, median, mode, and standard deviation using Excel functions, enabling you to analyze and interpret data effectively.

What You'll Learn?

Understanding basic statistical analysis is crucial for interpreting data effectively.

In this course, Perform Basic Statistical Analysis in Microsoft Excel, you'll learn how to calculate mean, median, mode, and standard deviation using Excel functions. You'll explore new functions like MODE.MULT, MODE.SNGL, and STDEV.S to enhance your data analysis skills.

When you’re finished with this course, you’ll have a better understanding of how to use Excel to perform fundamental statistical analysis, enabling you to analyze and interpret data to gain meaningful insights.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Amruta Mahajan

Instructor's Courses

Amruta is an experienced Data Analyst with over 12 years of experience in interpreting and analyzing data to drive successful business outcomes. She loves tackling hard problems using data manipulation as her superpower and has worked with market leaders from various fields including Standard & Poors, McDonalds, Mondelez International, General Electric, AMD and Beam Suntory. Amruta is passionate about both teaching and learning and believes “The purpose of life is to discover your gift. The work of life is to develop it. The meaning of life is to give your gift away”. Amruta has an undergrad in Statistics and a Masters in Computer Science. She speaks English, Hindi and Marathi and codes in VBA, Python and R

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.