7,612
edits
Changes
Jump to navigation
Jump to search
Ranking US Cities by Venture Capital (view source)
Revision as of 15:41, 13 January 2021
, 15:41, 13 January 2021→City Growth Rates
A code section was added to E:\project\vcdb3\Ranking.sql to explore city growth rates.
The main problem with estimating the average of <math>\frac{dollars_t - dollars_{t-1} }{dollars_{t-1}}</math>, where dollars is growth VC dollars invested in a city-year, is a truncation issue. <math>dollars_{t-1}</math> is often zero, and it is impossible for the resulting value to be below -100% while it can be above +100%.
I experimented with various ways to limit this issue, including considering:
