Trend Line - Bell Curve
 

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?
--
David

Trend Line - Bell Curve
 

Hello David,

You can probably find all the answers to this question and more at this
link
http://www.tushar-mehta.com/excel/ch...tion/index.htm

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

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=564032