Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,560
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trend Line Equation Coefficients Jake Excel Discussion (Misc queries) 4 April 17th 06 08:46 PM
Quantify trend line Brisbane Rob Excel Discussion (Misc queries) 3 March 5th 06 07:45 PM
Getting values from a trend line Andrew Excel Discussion (Misc queries) 3 February 22nd 06 06:27 PM
trend for polynomial curve fitting by regressing vijaya Excel Worksheet Functions 7 November 11th 05 03:51 PM
trend line does not appear JB Charts and Charting in Excel 1 January 26th 05 08:24 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"