Understanding Statistical functions in EXCEL 2010 (Part 1)
Udemy
Course Summary
Learn how to compute and apply basic excel statistical functions using EXCEL 2010.

+
Course Description
You will learn how to use many excel statistical functions for obtaining descriptive statistics, correlations, probabilities, histograms, fitting a linear regression, obtaining XY plots, bar graphs, frequencies, percentiles, quartiles, ranking data, etc. Over 56 videos with details explanations using real data to illustrate the concepts. Course can be completed in 810 weeks depending of background, assiduity and interest. Quizzes and a final project to test your understanding with real world problems Carefully selected examples in the videos to increase your understanding of each topic. Take this Excel Statistical course now and have a depth understanding Excel Statistical Functions.</p>

+
Course Syllabus
 Welcome to Statistical functions in EXCEL 2010
 About Statistical functions in EXCEL 2010, (Part 1)
 About the statistical functions that we will cover
 Using EXCEL 2010 main window to insert functions
 Enabling the Analysis ToolPak in EXCEL 2010
 Computing descriptive Statistical functions in EXCEL 2010
 Computing a standard deviation
 Computing Descriptive Statistics using EXCEL Analysis ToolPak library
 Using the Analysis ToolPak Descriptive Statistics Library
 Measures of central tendency of the data: Mean, median and mode
 Obtaining the Trimmed mean of the data
 Obtaining the Harmonic mean of the data
 Finding average rate of speed with the harmonic mean
 Obtaining the Geometric mean of the data
 Finding the average rate of growth with GEOMEAN
 Computing the Mean Average Deviation (MAD)
 Computing the sum of squares deviations from the mean
 Computing the sample variance of the data
 Computing the population variance of the data
 Sample standard deviation of the data
 Population standard deviation of the data
 Grouping the data with the Frequency function
 Computing the coefficient of skewness of the data
 Computing Pearson's coefficient of skewness
 Calculating the Kurtosis of a sample data
 Obtaining the kth smallest measurement of the data where k=1,2,...n
 Obtaining the kth largest measurement of the data where K=1,2,..
 Obtaining the sum of the measurements in a dataset
 Obtaining percentiles with Percentiles.INC
 Obtaining percentiles with Percentiles.EXC
 Calculating the Percentile Rank of an observation
 Finding percentiles rank
 Application of Quartiles in data screening
 Obtaining quartiles with Quartiles.EXC
 Ranking data using Rank.EQ function
 Ranking data using Rank.AVG function
 Obtaining the Sum of Squares of Data
 Obtaining the Minimum with the Min function
 Obtaining the Maximum with the Max function
 Analysis using Correlation, regression and forecasting functions
 Using Pearson's correlation coefficient function
 Calculating the sample covariance between two quantitative variables
 Computing the sample correlation coefficient with CORREL
 Forecasting data using the trend function
 Forecasting future data with the Forecast function
 Fitting a linear regression to data using XY Plot with options
 Obtaining RSQUARE for the linear regression
 Fitting the linear regession with LINEST function.
 Using Discrete Probability Distribution functions
 Computing the number of combinations of r elements among n elements
 Using combinations in practice
 Using the Permutation function
 Finding the number of permutations
 Using permutations to solve problems
 Computing Binomial Probability Distribution Probabilities
 Using the Probability function for discrete probability distributions tables
 Calculating Hypergeometric Distribution Probabilities
 Calculating Poisson Distribution Probabilities
 Using the Factorial function to obtain the number of permutations of elements
 Obtaining a random number in a fixed interval
 Generating Random numbers
 Graphical display of data
 Creating a frequency bar graph
 Creating a basic pie chart
 Using Friedman and Diaconis technique to determine an optimal number of BINS
 Creating a Histogram using some predetermined BINS
 Creating a relative frequency bar graph
 Final project and EXAM
 Applying the concepts to real world examples
 Obtaining Descriptive Statistics with the Analysis ToolPak
 Important files for practice and final exam material
 Thank you for taking the class and follow up
 Thank you and next steps about the class: Statistical Functions (Part 2)