Trend Line - Bell Curve

[Guest]

I've got some claims data for various years of insurance liability i.e. a
claims triangulation. The pattern of data is such that say for a policy year
in 2000 you would see a few notifications and as the claims develop in
subsequent years you would see an increase in numbers and then as claims are
settled the experience would run off and if plotted on a graph you would see
the classic bell curve shape.

From what I can see there is no Bell curve trending in Excel just straight
line and a few others. Is there a download?

 

[Leith Ross]

Hello David,

You can probably find all the answers to this question and more at thi
lin
http://www.tushar-mehta.com/excel/charts/normal_distribution/index.htm

Tushar has many tutorials covering a wide range of Excel functions an
subjects. I found his site a few years while looking for ways to grap
a Normal Distribution Curve in Excel. Like you I was amazed to fin
this function wasn't already present.

Sincerely,
Leith Ros