Скачать или смотреть How to prevent incorrect cell references in your formulas using Reinhart & Rogoff Excel error

Carmen Reinhart and Kenneth Rogoff published a paper in 2010 called Growth In A Time Of Debt where some statistical and spreadsheet errors were discovered by PhD students at the The University of Massachusetts Amherst. This tutorial walks through one of the spreadsheet errors where the average of growth rates did not properly reference all the GDP growth rates in the data table. Skip to parts in the tutorial:

Intro - 0:00
4 debt/GDP buckets - 0:46
Incorrect cell reference for AVERAGE formula - 1:15
Method 1: check summary dropdown - 3:15
Method 2: use checksum formulas - 4:13
Method 3: create PivotTable - 9:40

👉. Copy the Google Sheet: https://docs.google.com/spreadsheets/...
👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast...
👉 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analy...