Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trend Line Equation Coefficients | Excel Discussion (Misc queries) | |||
Quantify trend line | Excel Discussion (Misc queries) | |||
Getting values from a trend line | Excel Discussion (Misc queries) | |||
trend for polynomial curve fitting by regressing | Excel Worksheet Functions | |||
trend line does not appear | Charts and Charting in Excel |