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
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
The Amount of excellent material you are covering in every lesson is amazing!
Thanks so much for sharing the Excel files (through your link)!
You are welcome!
Im falling in love with excel😍 it makes statistics easy
short, clear, and lot of knowledge ...awesome video
Glad you like it, DIGITAL COOKING!
Great, Mike thank you, I had never had so much fun with statistic
Yes, with a splash of Excel and excitement, Statistics is REALLY fun!!!!
Wow, this is beautiful! Most exciting video in this series untul now, in my opinion. Thanks!
+popinigis Glad the video helps!
are monthly return rate and growth same ? Please ans, pretty confused
Thank you for geo mean. Totally amazing.
Such a useful functions! Thank for sharing.
Thanks!
Thanks
Thank you.
Rate function is giving same Answer =Rate (13,,-36.41,46.23)=1.8538%
Do you know how to calculate Geometric Standard Deviation ?
Downloaded File Couldn't found in the Link.
click link below video, Ctrl + F, search for "Excel 2013 Statistics Class Series", then get the chapter 3 file.