The avatar for @nunosempere
Nuño Sempere
Researcher at the Quantified Uncertainty Research Institute
Published
Edited
May 3, 2022
Fork of Quantifying Uncertainty in GiveWell's GiveDirectly Cost Effectiveness Analysis
2
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
donation_size
Insert cell
Insert cell
spending_data = FileAttachment("Copy of GiveWell-s analysis of GiveDirectly financial summary through February 2018 - Sam-s Summary.csv").csv()
Insert cell
sum= arr => arr.reduce((a,b) => a+b,0)
Insert cell
mean_transfer_efficiency = {
let totalMoneyTransfered = sum(
spending_data.map((transfer) => parseFloat(transfer["Money to Transfers"].replaceAll(",", "")))
);
let totalSpending = sum(
spending_data.map((transfer) => parseFloat(transfer["Total spending"].replaceAll(",", "")))
);
let efficiency = totalMoneyTransfered / totalSpending;

return efficiency;
}
Insert cell
nuno_guess_transfer_efficency_going_forward = "0.75 to 0.9"
Insert cell
cell(nuno_guess_transfer_efficency_going_forward)
Insert cell
transfer_efficiency = nuno_guess_transfer_efficency_going_forward
Insert cell
transfer_percentages = spending_data.map(x => parseFloat(x["Percentage on Transfers"]))
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
household_size_data = FileAttachment("household size analysis - Family size by household.csv").csv()
Insert cell
household_sizes = household_size_data.map(x => parseFloat(x["Total household size"])).filter(x => x !== 0)
Insert cell
[Math.min(...household_sizes), Math.max(...household_sizes)] // Just for reference
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.

Insert cell
Insert cell
Insert cell
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more