Spreadsheet to help class do the spreadsheet assignment. This video shows you how to calculate a compound annual growth rate (CAGR) in Excel. Note that another name for CAGR is the geometric mean.
I use the growth in Progressive's market share to demonstrate. Also data bars and sparklines.
Timestamps:
0:00 Getting started (overview of CAGR)
8:02 Progressive Auto Insurance
10:02 Creating data bars using conditional formatting
13:29 Inserting sparklines
15:50 Calculating CAGR for the auto insurance companies
18:08 Creating the Win / Loss bars (data bars using conditional formatting)
19:14 How to double-check your work
22:00 Common mistakes and how to fix them
23:28 Adidas & Google
***************************************************
#excel #exceltutorial #dataanalysis #statistics
30 сен 2024