Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Statistical Analysis Excel 2013 Essentials

Learn the ins and outs of statistical analysis with Excel 2013
4.7
4.7/5
(190 reviews)
1,298 students
Created by

6.5

CourseMarks Score®

0.7

Freshness

9.3

Feedback

9.0

Content

Platform: Udemy
Video: 4h 6m
Language: English
Next start: On Demand

Table of contents

Description

Big Data is Big Business – learn the ins and outs of statistical analysis with Excel.
Learn statistical analysis with Excel 2013 on your own terms with this one-of-a-kind video training course. Big data is big business, and many professionals are turning to Excels data analysis tools to help them make sense of their organizational data.
Now, you can learn the ins and outs of statistical analysis with Excel – from importing data toutilizing Pivot Tables – with Statistical Analysis with Excel 2013 Essentials. Our instructors provide expert, straight-forward, user-friendly training to help you tackle new topics the way you want to learn. Master basic skills, boost your creativity, and challenge yourself in bold new directions.
Understand Excels data analysis capabilities, even if you’ve never taken a statistics course. Work with data, normal distributions, hypothesis testing, variances, rank, and percentiles. Take advantage of formulas, Pivot Tables, dashboards, and reporting tools to display your data Includes 4 hours of statistical analysis with Excel 2013 video training.
This coursem also includes lessons that allow you to practice and master the skills you have learned.
If you’re looking for real-world statistical analysis with Excel 2013 instruction, you’ll find it here.

You will learn

✓ Learn how to locate the built-in functions, how to set-up a shortcut to the functions and how to load the Data Analysis ToolPak.
✓ Learn how to group data into intervals with a built in function and the data analysis tool, sort tables and summarize your data by counting your data points.
✓ Explore the three common types of charts featured in excel: column, line, and pie and scatter.
✓ Discover how to use Sparklines and PowerView in Excel.
✓ Learn how to calculate the statistics of central tendency, also known as, the average, median, mode in Excel. Find the mean and standard deviation together.
✓ Apply normal distributions and understand the concept of sampling distributions.
✓ Discover the connection between hypotheses and sampling distribution in excel and learn how to test hypothesis about variances.
✓ Create and interpret statistics in a business or classroom setting.

Requirements

• Students should have an intermediate knowledge of how to use Excel
• Having access to Excel 2013 is helpful for practicing the skills you have learned

This course is for

• Intermediate through Advanced Excel Users
• For students who want to take advantage of formulas, Pivot Tables, dashboards, and reporting tools
• If you need to effectively and efficiently analyze data within Excel this course is for you.
Video Training
     Founded in 1807,  Wiley, In has long been a valued source of information and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Wiley and its acquired companies have published the works of more than 450 Nobel laureates in all categories: Literature, Economics, Physiology or Medicine, Physics, Chemistry, and Peace. 
     Wiley is a global provider of content and content-enabled workflow solutions in areas of scientific, technical, medical, and scholarly research; professional development; and education. Our core businesses produce scientific, technical, medical, and scholarly journals, reference works, books, database services, and advertising; professional books, subscription products, certification and training services and online applications; and education content and services including integrated online teaching and learning resources for undergraduate and graduate students and lifelong learners. Wiley’s global headquarters are located in Hoboken, New Jersey, with operations in the U.S., Europe, Asia, Canada, and Australia. The Company is listed on the New York Stock Exchange under the symbols JWa and JWb. 
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 4h 6m
Language: English
Next start: On Demand

Students are also interested in