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
Wow, this is beautiful! Most exciting video in this series untul now, in my opinion. Thanks!
+popinigis Glad the video helps!
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!!!!
Such a useful functions! Thank for sharing.
Thank you for geo mean. Totally amazing.
Thank you.
Thanks!
Thanks
are monthly return rate and growth same ? Please ans, pretty confused
Do you know how to calculate Geometric Standard Deviation ?
Rate function is giving same Answer =Rate (13,,-36.41,46.23)=1.8538%
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.