> RQ \pAntonina Redko Ba==Z;"8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* ""_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* ""??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* ""??_);_(@_) + ) , * (@ @ (8@ @ 8@ @ (0 0@ @ p@ @ x@ @ @ @ (0@ @ (x@ @ @ x@ @ `F
Full TableweTable for PaperT Eamb_aversion"ambiguity aversion. =1 if p3 == 1.b_trust0nearly all households trust basix. e31.1 + e31.2bua )membership in borewater users association cr_basix =1 if household cited lack of collateral, high interest rates etc. as reason why they did not have one more loan (based on q K3a [and qK3b). see sec_credit.dodrought_cropHwere crops affected by drought (current year). derived from question c46edu 'highest education level, household headhhsize size of householdi_why'1=security, 2=advice, 3=product, 4=lucki_whynot
impatience
know_inabsJBased on e1 through e7 (understanding of insurance payouts): see sec_rain.ins_difweather >1 if household has some insurance other than weather insurance Pct of cultivated irrigated landleader )household is considered to be progressivelog_agehead log of age of head
log_value lownVamount of owned land in acres. note, missing for two households, =0 for one household. memberGP ;HH member is Gran Pranchayet representative (town council?)patiencep2/100
pct_gnut03(max) pct_gnut03pessimism U1 if they thought harvest would start late? I don t know what it is, need to find outrisk_aversion3 41 if they didn t like any risky gambles, 0 otherwisesampBnB '1 if they bought insurance, 0 otherwisesav0
Savings in MKsexhead
1 if male?DescriptionSource within SurveyProgram/dataset that created itStata Variable Name
Variable nameAmbiguity aversionsec_games.do; from GAMES.dtasec_rain.do; from RAINFALL3.dta
Member of BUA!sec_network.do; from NETWORK1.dtaPrevious loans from Basixsec_credit.do; from CREDIT2.dta/1 if previous credit from basix? If source==4.cred_constrCredit constraintTrust in insurance providersec_credit.do; from CREDIT.dtaCrop damage by drought)sec_agriculture.do; from AGRICULTURE5.dta Household head's education level&sec_house.do; from HOUSEHOLDROSTER.dtaHousehold sizeMotivation for buying insurance#Motivation for not buying insurancea1=Product, 2=No need, 3=No cash, 4=Rgauge far, 5=No payout, 6=Not understand, 7=No trust, 8=Othersec_rain.do; from RAINFALL.dta
Impatience%Ability to understand insurance planssec_saving.do; SAVING4.dta'Presence of other nonweather insurancelcultirrpct$Percent of cultivated irrigated land<sec_agriculture.do; from AGRICULTURE1.dta & AGRICULTURE2.dtaProgressive household sec_network.do; from NETWORK.dtaLog of household head's ageAcres owned)sec_agriculture.do; from AGRICULTURE1.dtaMember of Gran Pranchayet!sec_house.do; from BHOUSEHOLD.dtaPatience$Percent of groundnut planted in 2003
Risk aversionBuyer identifiersec_saving.do; SAVING2.dta%Value of savings in Mrigashira KartisSex of the household head%Log of household value (house + land) Pessimism??Significance of variableSection P: Games, Question 3*Section E: Rainfall Insurance, Question 31+Section I: Networks, Question 8 second partSection K: Credit, Question 4%Section K: Credit, Question 3a and 3b#Section C: Agriculture, Question 46(Section A: Household Roster, Question 16'Section A: Household Roster, Question 1+Section E: Rainfall Insurance, Question 14b Coded as 1 for Security = answers 6, 8, 9 & 10; 2 for Advise = answers 3, 4 & 5; 3 for Product = answers 1, 2 & 7; 4 for Luck = answer 4*Section E: Rainfall Insurance, Question 25Coded as 1 for Product = answers 1, 2, 4, 6 & 12; 2 for No need = answer 8; 3 for No cash = answer 3; 4 for Rgauge far = answer 5; 5 for No payout = answer 7; 6 for Not understand = answer 9; 7 for No trust = answer 10; 8 for Other = answer 13Section P: Games, Question 2Hderived from p2: original measure is (100/p21)*100. (I don't use this)7Section E: Rainfall Insurance, Questions 1, 2, 3, 5 & 7The variable is a number between 0 and 1. The correct answer to each question gets 1 point (respectively: no, yes, no, yes, no) and then that sum is divided by 5 to get an average measure of ability to understand insurance plans+Section L: Savings & Insurance, Question 101Section C: Agriculture, Question 2, 5, 8, 10 & 17Section I: Networks, Question 8'Section A: Household Roster, Question 4dSection B: General Household Characteristics, Question 13; Section C: Agriculture, Question 2, 5 & 7&Section C: Agriculture, Question 2 & 58Section B: General Household Characteristics, Question 5(Section C: Agriculture, Question 47 & 48Section P: Games, Question 1"E. Rainfall Insurance, Question 16*Section L. Savings & Insurance, Question 5'Section A: Household Roster, Question 3lifevillage
log_hhsizelog_own
log_wealth
pct_cast03m_attendsec_house.do; BHOUSEHOLD.dtaJSection B: General Household Characteristics, Question 7, tick if all lifeLived in village whole lifeLog of household sizeLog of acres owned
Log of wealthYsec_saving.do; sec_livestock.do; sec_house.do; SAVING2.dta; LIVESTOCK.dta; BHOUSEHOLD.dtaSection B: General Household Characteristics, Question 13; Section F: Livestock, Question 3; Section L: Savings & Insurance, Question 5!Percent of castor planted in 2003**Note: unless specified, all datasets are in: \data\2004 survey\original household data\ and all do files are in \codes\hh\!\codes\james\insurance_reasons.do'\data\2004 survey\survey_hh\dat_res.dta\codes\james\analysis.do\codes\james\newvariables.dosec_house.do; HOUSEHOLDROSTER.dta; sec_house.do codes sexhead as 1 for male, 2 for female; \codes\james\newvariables.do recodes sexhead as 1 for male, 0 for female.\codes\james\newvariables.do creates "log_value"; sec_agriculture.do creates lownval; sec_house.do creates houseval; from BHOUSEHOLD.dta & AGRICULTURE1.dtaR\codes\james\newvariables.do creates "log_agehead"; sec_house.do creates "agehead"*Section E: Rainfall Insurance, Question 13!Attend rainfall insurance meeting]Dummy variable equal to 1 if respondent trusts KBS Bank, BASIX, and the insurance salesperson8Dummy variable equal to 1 if respondent chooses Bag One.DDummy variable equal to 1 if any household member belongs to BUA/WUGDDummy variable equal to 1 if household has received loans from BasixxDummy variable equal to 1 if household cites lack of collateral as a reason for not having loans despite asking for themCDummy variable equal to 1 if the reason for crop damage was droughtaDummy variable equal to 1 if household has crop insurance, life insurance, and/or other insuranceODummy variable equal to 1 if household head has lived in village for whole lifeDDummy variable equal to 1 if the household bought insurance for 2004"Dummy variable equal to 1 for maleEducation codeDCounts the number of household members that are listed in the roster5Dummy variable equal to 1 if household is progressiveLog(age of head of household)Log(1+Household size)Log(1+Acres owned)iAcres (q2 if q8=1 or q10 is not blank) of irrigated land (q17=2, 3, or 4) / total land owned (q2 if q5=1)((100/q2)1)*100Log(1+savings in Mrigashira Kartis+market value+house value); savings in Mrigashira Kartis = sav0 in sec_saving.do; market value = marketvalue in sec_livestock.do; house value = houseval (b17cost in sec_house.do)kvalue of house and land; house value = houseval in sec_house.do; loan value = loanval in sec_agriculture.doLog(1+savings in Mrigashira Kartis+market value+house value); savings in Mrigashira Kartis (Section L) = sum over q5; market value (Section F) = q3; house value (Section B) = q13Log(100+house value+land value). Land value (Section C) = acres*cost (q2*q7) if own=1 (q5=yes); house value (Section B) = q13 Q2 if q5 = 1TDummy variable equal to 1 if attended meeting to explain and sell rainfall insuranceLDummy variable equal to 1 if any household member belongs to Gran PranchayetQ2/100BTotal acres of castor planted in 2003 / total area planted in 2003ETotal acres of groundnut planted in 2003 / total area planted in 2<003:Dummy variable equal to 1 if respondent selects choice "A"Sum of q3 across all categories%Section O: Risk Response, Question 15;Section J: Networks and sources of information, Question 11Section G: Credit, Question 4%Section G: Credit, Question 3a and 3b'Section A: Household Roster, Question 8FSection M: Knowledge about products and willingness to pay, Question 2)Section C: Agriculture, Question 2, 3 & 5YAcres (q2) of irrigated land (q5=1, 2, 3, 4 or 5) / total land owned (q2 if q3=1, 2 or 3):Section J: Networks and Sources of Information, Question 70Section B: Household Characteristics, Question 1The variable is a number between 0 and 1. The correct answer to each question gets 1 point (respectively: no, yes and 200MK.) and then that sum is divided by 3 to get an average measure of ability to understand insurance plans&Section C: Agriculture, Question 2 & 3' Log(1+Acres owned= q2 if q3=1, 2 or 3)&q2 if q3=1, 2 or 3%Section O: Risk Response, Question 18Value of savings*Section H. Savings & Insurance, Question 3Progressive farmer2Dummy variable equal to 1 if farmer is progressiveDistance to rainfall gauge:Section J: Networks and sources of information, Question 8 q8 in Km.:Section J: Networks and sources of information, Question 9)Difference rain in plot compared to gaugekDummy variable equal to 1 if rain is different in the plot compared to the rainfall gauge (1 if q9= 3 or 4)Knowledge of institutions;Section J: Networks and sources of information, Question 10iDummy variable (for each institution) equal to 1 if respondent knows OIBM, MRFC and/ or Insurance Company$Willingness to pay for the insuranceFSection M: Knowledge about products and willingness to pay, Question 30Section N: Personality and Attitudes, Question 1Good health*Dummy variable equal to 1 if q1= 1, 2 or 37Section N: Personality and Attitudes, Question 6, 7 & 8The variable is a number between 0 and 1. The answer that shows that the respondent trusts people gets 1 point (respectively: 1, 2 and 1) and then that sum is divided by 3 to get an average measure0Section N: Personality and Attitudes, Question 5The variable is a number between 0 and 1. Add up the answers of questions a), b) and c) and then substract 3 and divide by 15, that is: (q5.a + q5.b + q5.c  3) / 15 .Stress0Section N: Personality and Attitudes, Question 2
Bad healthThe variable is a number between 0 and 1. Add up the answers of questions a) and b), then substract 2 and divide by 6, that is: (q2.a + q5.b  2) / 6.0Section N: Personality and Attitudes, Question 9`The value of the variable is the amount that the respondent is willing to pay for the insurance.;Dummy variable equal to 1 if respondent selects choice "A".ExtraversionAgreeblenessConcientiousnessEmotional StabilityOpen to experiences1Section N: Personality and Attitudes, Question 10The variable's values go from 2 to 14. To compute the variable, add up the answers from the subquestions b) and j) in the following way: question b) is positive scoring and question j) is reverse scoring. Then add up the positive scores of b) and the reversed scores of j).The variable's values go from 2 to 14. To compute the variable, add up the answers from the subquestions d) and h) in the following way: question d) is positive scoring and question h) is reverse scoring. Then add up the positive scores of d) and the reversed scores of h).The variable's values go from 2 to 14. To compute the variable, add up the answers from the subquestions c) and f) in the following way: question c) is positive scoring and question f) is reverse scoring. Then add up the positive scores of c) and the reversed scores of f).The variable's values go from 2 to 14. To compute the variable, add up the answers from the subquestions e) and g) in the following way: question e) is positive scoring and question g) is reverse scoring. Then add up the positive scores of e) and the reversed scores of g).}Total acres of maize planted from September 2005 to September 2006 / total area planted from September 2005 to September 2006Total acres of groundnut planted from September 2005 to September 2006 / total area planted from September 2005 to September 2006,Percent of maize planted in Season 200520060Percent of groundnut planted in season 20052006=Section C: Agriculture, Question 2 and Section D: Question 1Relation with VH9Section B: General Household Characteristics, Question 10\Dummy variable equal to 1 if the Club member is related to VH (if q10 is different from 10).!Previous loans from formal sourceReduction in income$Section O: Risk Response, Question 36Dummy variable equal to 1 if respondent answers "yes".GDummy variable equal to 1 if household responds options 3, 4, 5, 6 or 7Trust in Rainfall MeasurementTrust in Insurance CompaniesTrust in NASFAM, OIBM and MRFCUnderstanding of 60 mmFSection M: Knowledge about products and willingness to pay, Question 1Difference 60 mmWillingness to pay for creditFSection M: Knowledge about products and willingness to pay, Question 5YThe value of the variable is the amount that the respondent is willing to pay for credit.Trusting The variable's values go from 8 to 16. To compute the variable, add up the answers from the 4 subquestions in the following way: questions a) and d) are positive scoring and questions b) and c) are reverse scoring. That means that the values of questions b and c need to be reversed: if the respondent answers 0, it needs to be coded as 4; if answer is 1, coded as 3; if answer is 2, it stays as 2; if answer is 3, code it as 1; and if answer is 4 code it as 0. Then add up the positive scores of a) and d) and the reversed scores of b) and c).:The variable's values go from 2 to 14. To compute the variable, add up the answers from the subquestions a) and i) in the following way: question a) is positive scoring and question i) is reverse scoring. That means that the values of question i) need to be recoded: if the respondent answers 1, it needs to be coded as 7; if answer is 2, code as 6; if answer is 3, code as 5; if answer is 4, it stays as 4; if answer is 5, code it as 3; if answer is 6, code it as 2; and if answer is 7, code it as 1. Then add up the positive scores of a) and the reversed scores of i).Section O: Games, Question 13 and Question 14Compute the discount of the respondent as follows: if he accepts MK 1,250 (that is, he chooses 2 in part a) then the discount will be = ((12501000)/1000)*100. If he chooses 2 in part b, then the discount will be ((15001000)/1000))*1009Dummy variable equal to 1 if respondent answers letter B.dThe variable takes values from 0 to 10, depending on the level of trust in the rainfall measurement.cThe variable takes values from 0 to 10, depending on the level of trust in the insurance companies.The variable takes values from 0 to 10, depending on the level of trust in NASFAM, OIBM and MRFC (compute the mean of the trust in these 3 institutions).Log of land valueqDifference in mms. between what the respondent answers (measure in mms the distance of each letter) and the 60mm."Section C: Agriculture, Question 4D Log(100+land value). Land value (Section C) = q4 if q3=(1, 2 or 3) ./LSection I: Livestock, Question 5; Section H: Savings & Insurance, Question 4hLog(1+savings+ livestock market value); savings (Section H) = sum over q4; market value (Section I) = q5C]o 8a
*h1]
&/o8 w@
d!O
\%G#%;"#`&p(*),.#02*>5
9:c8<Bpcc
#VZd,e
dMbP?_*+%Mr\\DRGPRINT\mc3454hp4100C
odXXLetterDINU"4`ݕ:
TRJPHAAADMINISTRATORBAPHAA"dXX??U}I
}m}I}I}}Stata Variable Name# @
@
2
/
`
1
.
0
3
a
4
=
b
5
6
c
7
8
d
:
9
<
e
;
>
?
f
@
A
g
B
C
h
B
D
i
j
G
E
k
l
F
5
H
m
n
4
K
q
J
I
o
p
G
M
r
L
N
O
s
P
}
Q
t
h
~
v
]
u
R
v
S
T
w
U
V
m
!
4
x
W
x
"
#
@
^
_
$
%
_
X
y
&
'
4
Y
z
(
)
[
{
*
+
ZDlTTTTTTTTTTTdTTTTPTPPTTTPTTPTPTT "
\

,

"T>@?7
,u}
dMbP?_*+%Mr\\DRGPRINT\mc3454hp4100C
odXXLetterDINU"4`ݕ:
TRJPHAAADMINISTRATORBAPHAAHP LaserJet 4100 Series PCL"dXX??U}m}I}m7,
!!
2
/
`
C
h
h
\

Q
t
A
"
"
"
M
R
<
I
Dl******************************* !!!"#$%&'()*+
^
!
!
!
"
"
"
#
#
#
$
$
$
%
%
%
&
&
&
'
'
'
(
(
(
)X
)
)
*3
*
*
+H
+
+***********>@ 7
Oh+'0HPl
Sarita SubramanianxgineMicrosoft Excel@/]W@tI@ Mk՜.+,0 PXx
Federal Reserve SystemFull TableTable for PaperWorksheets
!"#$%&'()*+,./0123456789:;<=>?@BCDEFGHJKLMNOPRoot Entry Fy>tWorkbook<SummaryInformation(ADocumentSummaryInformation8I