MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Understanding Statistical functions in EXCEL 2010 (Part 1)

### Course Summary

Learn how to compute and apply basic excel statistical functions using EXCEL 2010.

• +

### 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 pre-determined 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)

Course Fee:
USD 99

Self-Study

Active