Name File Type Size Last Modified
Database Household Refundable Insurance.xlsx application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 42 KB 03/18/2024 04:18:AM

Project Citation: 

Mármol, Maite. Spanish households: Car insurance with deductibles. Ann Arbor, MI: Inter-university Consortium for Political and Social Research [distributor], 2024-03-18.

Project Description

Summary:  View help for Summary This databases is used to investigate the expected utility of Spanish households if they take out a refundable insurance that covers the deductible that must be assumed if a car accident occurs. Using data from the Spanish Survey of Household Finances and market data, this database provides novel empirical evidence on the relationship between wealth and level of risk aversion, as well as the effect of taking out a refundable insurance on the expected utility of households (Household Refundable Utility)

Scope of Project

Subject Terms:  View help for Subject Terms auto insurance; spanish households; deductible
Geographic Coverage:  View help for Geographic Coverage Spain
Time Period(s):  View help for Time Period(s) 1/1/2019 – 12/31/2019
Collection Date(s):  View help for Collection Date(s) 1/1/2019 – 12/31/2019
Universe:  View help for Universe Spanish households with auto insurance including deductible
Data Type(s):  View help for Data Type(s) administrative records data
Collection Notes:  View help for Collection Notes After analyzing the five imputed datasets there are no remarkable differences between them and it is decided to use the first imputed dataset (EFF-derived DATOSIMP1 and databol1 files).
Together there are 6,313 surveys representing 18,821,645 households according to the weights of the facine3 variable in the databol1 file.
First, we select how many families have any vehicle, and we obtain that of the 6,313 surveys, a total of 5,074 surveys correspond to households that have any vehicle (in the population as a whole, they represent 14,042,117 households). Secondly, those households with negative or null wealth are discarded, since in order to apply the formulations it is necessary for this variable to have a positive value. Overall,
413 surveys representing 1,398,145 households are discarded for the entire survey. Finally, we calculate how many households have any vehicle and have positive wealth, obtaining a total of 4,774 surveys, representing 13,203,356 households.
Next we generate a vector containing the total number of vehicles in the total population, for this we multiply the number of vehicles that each household in the survey has by the number of households that each one represents in the total population (weight).
We obtain a total of 20,571,785 vehicles, of which we must randomly choose 28.41%, i.e. 5,844,444 vehicles, which are those that will be franchised.
In total we selected 5,851,932 vehicles, corresponding to vehicles from 984 different surveys (households). As in some households we have selected more than one vehicle we check how many surveys we have ended up selecting, which are 873 surveys.


Sampling:  View help for Sampling
The constructed database contains 856 households and each of them represents  a number of households in Spain according to the weights. Specifically 4,712,025 households.

Data Source:  View help for Data Source Spanish Spanish Survey of Household Finances 2020
Weights:  View help for Weights The weights are included in the database.
Unit(s) of Observation:  View help for Unit(s) of Observation Spanish households
Geographic Unit:  View help for Geographic Unit Spain

Related Publications

Published Versions

Export Metadata

Report a Problem

Found a serious problem with the data, such as disclosure risk or copyrighted content? Let us know.

This material is distributed exactly as it arrived from the data depositor. ICPSR has not checked or processed this material. Users should consult the investigator(s) if further information is desired.