SPB Git

spb/wp29_uqo

Public
1.2 KB · 10 lines markdown
1# Data audit2- File: data/firms.csv, SHA-256 34aa682e59ef64cfc56931ea33bb809797cd53eca83edfe370c31aeaa8e8b7df (matches bundle.json)3- 1200 rows (header excluded), 4 columns: firm_id int, skill_index float (standardised; mean -0.0015, range -3.83..2.96), training_hours float (hours/employee; range -7.585..51.77, mean 19.95), productivity_growth float (% change; range -4.04..19.39, mean 7.08).4- There are no dates (the timing is described in TASK.md: skill_index is measured the year before, training happens in the programme year, growth is measured the year after).5- No missing values. No duplicate rows. firm_id values are unique (1001..2200).6- **Anomaly:** 12 rows have training_hours < 0, which is physically impossible. They all have low skill (skill_index between -3.0 and -1.0). Decision: exclude them from the main analysis (recorded in exclusions.csv) and report the full-sample estimate as a sensitivity check.7- Only 4 values are exact integers, so there is no heaping. A few values appear twice, which is consistent with rounding to 3 decimals.8- Correlations: skill vs hours = 0.69, skill vs growth = -0.79, hours vs growth = -0.28. This is strong confounding by skill.9- No input breaks the availability rules.10
Files · 152a55b8fa2830f50fa35e5aed99c0037f713345
Menu

Theme