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

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top