Download Excel spreadsheets:

Table 2.1 Claims and Fire Losses for Group of Homes in Location A

Table 2.2 Claims and Fire Losses ($) for Homes in Location B

Table 2.3 Opportunity and Loss Assessment Consequences of New Product Market Entry (Value – Severity Assessment)

Table 2.4 Variance and Standard Deviation of Fire Claims of Location A

Table 2.5 Variance and Standard Deviation of Fire Claims of Location B

Additional examples

Coefficient of Variation 

Historical Method