Watch Statistical Analysis with Excel 2013 Essentials

Statistical Analysis with Excel 2013 Essentials is a comprehensive and user-friendly course produced by John Wiley & Sons, Inc. that teaches the essentials of statistical analysis using Microsoft Excel 2013. The course is designed for both beginners and experienced users who want to learn how to analyze numerical data and produce accurate and meaningful statistical results. It is ideal for students, researchers, analysts, and business professionals who need to use Excel for data analysis and decision making.

The course consists of six sections that cover the most important statistical techniques used in Excel: Descriptive Statistics, Probability Distributions, Sampling and Estimation, Hypothesis Testing, Correlation and Regression Analysis, and Time Series and Forecasting. Each section is divided into several modules, all of which are presented in video format by a knowledgeable and engaging instructor.

The course begins with an overview of the Excel environment and how to format data, create charts and tables, and use Excel functions to perform basic calculations. The first section on Descriptive Statistics covers how to summarize numerical data using measures of central tendency and variation, such as mean, median, mode, range, and standard deviation. The section also explains how to create histograms, bar charts, and other graphical displays of data.

The second section on Probability Distributions introduces the concept of probability and how to use Excel to calculate probabilities for discrete and continuous random variables, such as binomial, Poisson, normal, and exponential distributions. The section also covers how to simulate random events using Excel's random number generator and how to create probability plots and frequency tables.

The third section on Sampling and Estimation explains how to use Excel to draw random samples from populations and estimate population parameters such as mean, variance, and proportion. The section covers sampling distributions, confidence intervals, and margin of error, and provides practical examples and exercises to help users apply these concepts in real-world situations.

The fourth section on Hypothesis Testing teaches users how to test hypotheses about population parameters using Excel's t-tests, z-tests, and chi-square tests. The section covers null and alternative hypotheses, p-values, Type I and Type II errors, and provides practical examples and exercises to help users master these concepts.

The fifth section on Correlation and Regression Analysis covers how to use Excel to analyze the relationship between two or more variables using scatterplots, correlation coefficients, and linear regression models. The section includes examples of simple and multiple regression models and shows how to interpret the results of these models using Excel's built-in regression analysis tool.

The final section on Time Series and Forecasting introduces users to the concepts of time series analysis and forecasting using Excel. The section covers how to create time series plots, calculate moving averages and exponential smoothing, and use Excel's forecasting tools to predict future values of time series data.

Overall, Statistical Analysis with Excel 2013 Essentials is an excellent course that provides a thorough and accessible introduction to statistical analysis using Excel. The course is well-structured, easy to follow, and provides ample opportunities for users to practice and apply what they have learned. Whether you are a beginner or an experienced Excel user, this course is highly recommended for anyone who needs to analyze data and make informed decisions based on statistical evidence.