Excel 2013 Statistical Analysis #18: Geometric Mean, Average Compounding Rate GEOMEAN & RRI

[@excelisfun]

Excel 2013 Statistical Analysis #18: Geometric Mean, Average Compounding Rate GEOMEAN & RRI
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:09) Intro to Geometric Mean or Average Compounding Rate
2. (00:52) Growth Rate or Percentage Change Formulas and Growth Factor
3. (02:36) Why you should not use the Mean when dealing with Growth Rates
4. (03:15) FV formula
5. (04:48)Geometric Mean or Average Compounding Rate using GEOMEAN function when you are given a list of growth rates or Percentage Changes. Stock Price Example
6. (06:25) Geometric Mean or Average Compounding Rate using Formula 2 and RRI function when you are given a begin amount (PV) and an end amount (FV)) and the number of periods. Stock Price Example
7. (08:08) Investment example
8. (09:00) Population Change example

[@ShavitTube]

The Amount of excellent material you are covering in every lesson is amazing!
Thanks so much for sharing the Excel files (through your link)!

[@excelisfun]

You are welcome!

[@aslamiahalamshah4728]

Im falling in love with excel😍 it makes statistics easy

[@DIGITAL_COOKING]

short, clear, and lot of knowledge ...awesome video

[@excelisfun]

Glad you like it, DIGITAL COOKING!

[@katerina6495]

Great, Mike thank you, I had never had so much fun with statistic

[@excelisfun]

Yes, with a splash of Excel and excitement, Statistics is REALLY fun!!!!

[@popinigis]

Wow, this is beautiful! Most exciting video in this series untul now, in my opinion. Thanks!

[@excelisfun]

+popinigis Glad the video helps!

[@BNomad]

are monthly return rate and growth same ? Please ans, pretty confused

[@Chamchijjige]

Thank you for geo mean. Totally amazing.

[@DougHExcel]

Such a useful functions! Thank for sharing.

[@pphong]

Thanks!

[@Clifffffffffford]

Thanks

[@mamikikeyu]

Thank you.

[@simfinso858]

Rate function is giving same Answer =Rate (13,,-36.41,46.23)=1.8538%

[@ihfijhnihfijhn684]

Do you know how to calculate Geometric Standard Deviation ?

[@md.shahiduzzamanshuvo5027]

Downloaded File Couldn't found in the Link.

[@excelisfun]

click link below video, Ctrl + F, search for "Excel 2013 Statistics Class Series", then get the chapter 3 file.