## Frequency

babajideoluwaseun
Posts: 2
Joined: Mon Jun 18, 2012 1:12 pm

### Frequency

Hi,

Just few Questions for you..

I have 5 years loss data.

Dates on Column A and Loss data on column B

I noticed that in column A we might have 10 incidents that happens in a day which is my Frequency?

Pivot table can add all this incidents together to give me the number of incidents that happened which is discrete but this will also add all my losses together for that particular date with losses associated with it.

Am i thinking in the right way?

e.g

Date Losses
2/02/2012 £4000
2/02/2012 £3000
2/02/2012 £500

here
frequency will be 3

i.e

3 £12000

for other days, it goes on like that,

Now I just need to find my mean standard deviation to know what type of distribution I need to use?

Am i in the right direction?

Thank you

Posts: 12
Joined: Sat Feb 11, 2012 7:35 pm

### Re: Frequency

Yes you are right. You will fit a distribution on the frequency calculated and similarly on the loss amounts which combined will give you the losses in a particular period.