Notice: The called constructor method for WP_Widget in collapsCatWidget is deprecated since version 4.3.0! Use
__construct()
instead. in /var/www/vhosts/121/242034/webspace/siteapps/WordPress-56954/htdocs/wp-includes/functions.php on line 4718
Excel Dashboard Training | Brendan Moran

↑ Return to Excel Training

Excel — Statistics

In this course I will intro­duce you to the use Excel Sta­tis­ti­cal Func­tions and free Excel Sta­tis­ti­cal Add-ins. Excel has a huge range of sta­tis­ti­cal func­tions and add-ins avail­able.

We will also cov­er the major sta­tis­ti­cal for­mu­las from first prin­ci­ples includ­ing:

  • Mean
  • Stan­dard Devi­a­tion
  • Nor­mal Dis­tri­b­u­tions
  • Cen­tral Lim­it The­o­rem
  • t‑Distribution
  • Regres­sion Analy­sis
  • Cor­re­la­tion
  • ANOVA Test­ing

I have prac­ti­cal Excel worked exam­ples for each of these areas.

Among the for­mu­las and areas cov­er will be:

  • Sum­Sq
  • SumProd­uct
  • Array Func­tions
  • Aver­age (Mean)
  • Vari­ance — Var.p entire pop­u­la­tion and var.s with N‑1 for pop­u­la­tion
  • Stan­dard Devi­a­tion — stdev.p entire pop­u­la­tion
  • Cor­re­la­tion Coef­fi­cient — CORREL
  • Stan­dard Scores — STANDARDIZE

 

Excel — Sta­tis­ti­cal Graphs

  • Scat­ter­plot
  • Regres­sion Analy­sis
  • Line and Bar Charts

 

Excel’s Analy­sis Tool­pak Addins Instal­la­tion

  • Mean
  • Stan­dard Error
  • Medi­an
  • Mode
  • Stan­dard Devi­a­tion
  • Sam­ple Vari­ance
  • Kur­to­sis
  • Skew­ness
  • Range
  • Min­i­mum / Max­i­mum
  • Sum
  • Count / Obser­va­tions

We will also look the 4 Dif­fer­ent Data Types

  • Nom­i­nal
  • Ordi­nal
  • Inter­val
  • Ratio

We will also cov­er Inde­pen­dent and depen­dent vari­ables

  • Prob­a­bil­i­ty
  • Com­pound Events
  • Fac­to­r­i­al
  • Com­bi­na­tions
  • Per­mu­ta­tions
  • Con­di­tion­al Prob­a­bil­i­ty
  • Bayesian Prob­a­bil­i­ty
  • Cen­tral Ten­den­cy
  • Mean
  • Medi­an
  • Mode — Sin­gle and mul­ti­ple
  • Dis­tri­b­u­tions
  • Nor­mal Dis­tri­b­u­tions
  • Fre­quen­cy
  • Fre­quen­cy Poly­gon graphs
  • Sam­pling Dis­tri­b­u­tions
  • Stan­dard Error
  • Cen­tral Lim­it The­o­rem
  • t‑Distribution
  • Esti­ma­tion
  • Con­fi­dence Lim­its
  • Hypoth­e­sis test­ing includ­ing z‑test and t‑test
  • Chi-Square dis­tri­b­u­tion
  • Inde­pen­dent Sam­ples includ­ing z‑test and t‑test for inde­pen­dent sam­ples
  • Matched Sam­ples Hypoth­e­sis Test­ing
  • Analy­sis of Vari­ance includ­ing ANOVA Test­ing
  • Regres­sion Analy­sis
  • Cor­re­la­tion