WE1 Using MS Excel

1. Open Insurance data in MS Excel

2. Assess the normality of the following variables: claim amount, coverage, hoursehold income, and deductible (explain whether or not the variables are normally distributed, are distribution symmetrical or skewed). Explain your findings and support with descriptives (numerical and/or graphical). Hint:

3. Is there a statistical relationship between claim amount and income? Explain your findings and support with descriptives (numerical and/or graphical)

4. Is there a statistical relationship between the type of claim and marital status?