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.
|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.|
|In this lesson you will discover how to use excel's built in statistical functions.|
|In this lesson you will learn how to group data into intervals with a built in function and the data analysis tool.|
|In this video you will learn how to sort data in tables.|
|In this lesson you will learn how to summarize your data by counting your data points.|
|In this video you will explore the three common types of charts featured in excel: collumn, line, and pie.|
|In this lesson you will learn how to use excel's bar and scatter charts.|
|In this video you will dicover how to use Sparklines and PowerView in excel.|
|In this lesson you will discover the statistics on the status bar and quick analysis features in excel.|
|In this video you will learn how to calculate the statistics of central tendancy, also known as, the average, median, mode in excel.|
|Learn all about excel functions to find the variablilty in a set of numbers with this lesson.|
|In this lesson you will learn how to use the mean and standard deviation together.|
|With this video you will become more familiarized with normal distributions.|
|This lesson discusses excel's normal distribution functions in the contecxt of the IQ distribution feature.|
|In this video you will learn how to apply normal distributions and understand the concept of sampling distributions.|
|Finding Confidence Limits For a Mean|
|This video discusses the t distribution function in excel.|
|In this lesson you will discover the connection between hypotheses and sampling distribution in excel.|
|In this video you will learn about practical hypothesis testing.|
|In this lesson you will learn how to test hypothesis about variances.|
Founded in 1807, John Wiley & Sons, Inc. has 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.