Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Statistical Analysis Excel 2013 Essentials
Rating: 4.4 out of 5(193 ratings)
1,305 students

Statistical Analysis Excel 2013 Essentials

Learn the ins and outs of statistical analysis with Excel 2013
Created byJohn Wiley & Sons
Last updated 11/2014
English

What you'll 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.

Course content

6 sections • 21 lectures • 4h 6m total length

  • Built-in Functions and the Data Analysis ToolPak3:22
    In this video you'll 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.
  • Working with the Built-in Statistical Functions5:16
    In this lesson you will discover how to use excel's built in statistical functions.
  • Working with the Data Analysis ToolPak3:25
    In this video you will learn how to use the Data Analysis ToolPak.

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

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.

Who 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.

Report abuse