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

Advanced Statistical functions in EXCEL 2010 (Part 2)

Course Summary

Learn how to use advanced statistical functions in EXCEL 2010


  • +

    Course Syllabus

    • Welcome to Statistical functions in EXCEL 2010 (Part 2 -Intermediate and Advanced)
      • What this class is about
      • How to insert functions into EXCEL 2010 main window
    • Functions related to the normal or bell-shaped distribution
      • Normal Distribution NORM.DIST function
      • Finding the standard normal distribution probabilities
      • Finding the inverse of a normal distribution
      • Find the inverse (Z-value) of the standard normal distribution
      • How to plot the standard normal distribution curve
      • Creating a standard normal distribution table
      • How to standardize by computing the Z value
      • Using a Z-test to test an hypothesis about the population mean
      • Computing the margin of error for a large sample size confidence interval about the population mean
    • Functions related to the Student t distribution
      • Obtaining a left-tailed P-value about the population mean with T.DIST
      • Finding the critical table value corresponding to a left-tailed student t distribution
      • Finding the critical table value corresponding to a two-tailed t distribution
      • Finding the right-tailed P-value using for testing a population mean using Student t distribution
      • Finding a two-tailed P-value when testing an hypothesis about the mean using Student t distribution
      • Creating a Student t table with a T.INV function
      • Testing hypothesis about two populations means using Student t-test
      • Computing the margin of error for estimating a population mean using Student t distribution
    • Computing Chi-square distribution probabilities and critical values
      • Finding the left-tailed P-value for testing an hypothesis about the population variance using chi.dist
      • Finding the right-tailed P-value for testing an hypothesis about a population variance using the Ch square distribution
      • Finding the critical table value for testing a left-tailed hypothesis about a population variance using Chi Square distribution
      • Find the critical table value for testing a right-tailed hypothesis about a population variance using the Chi square distribution
      • Testing an hypothesis of independence using the Chi square test
    • Computing F-Distribution probabilities
      • Computing a left-tailed P-value for testing the equality of two population variances using the F distribution
      • Computing a right-tailed P-value for testing the equality of two populations variances using the F-distribution
      • Finding a right-tailed critical value for testing two variances using the F.INV.RT
      • Testing equality of two populations variances with the F-test
    • Other advanced Statistical functions in EXCEL 2010
      • Computing Exponential distribution probabilities
      • Fitting exponential growth models to data with the growth function
      • Evaluating Gamma distribution probabilities
      • Computing factorials with the Gamma related functions
      • Computing probabilities of the Negative binomial distribution
      • Using the Log normal distribution function to compute probabilities
      • Finding the inverse of Log normal distribution
      • Using the Weibull distribution to compute probabilities
    • Practice project files and Quizzes
      • Project and practice files
      • Solving problems using the normal distribution (Part1)
      • Find probabilities under the standard normal distribution
      • Finding the left tailed P-value for a Student t distribution
      • Finding the right-tailed P-value for a Student t distribution
      • Finding the two tailed P-value for a Student t distribution
      • Practice using the inverse of the standard normal distribution
      • Finding the inverse of the Student t distribution
    • Closing remarks and follow up
      • Closing remarks and suggestions


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Quality Assurance & Testing Community

Related Posts:

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