LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BJBenton
 
Posts: n/a
Default Polynomial approximation

I am trying to put together a spreadsheet to calculate the pricing of
financial options. However I need a column for the value of N(x) which using
polynomial approximation gives the probability that a normally distributed
variable with a mean of zero and a standard deviation of 1 is less than x. Is
this a possible function on EXCEL and if so how do i use it?
 
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
Increaseing Precision in polynomial trendline equations KevinW Charts and Charting in Excel 9 January 6th 06 06:41 PM
Polynomial regression - how does Excel do it? (under "Trendline") JH Charts and Charting in Excel 2 January 5th 06 05:07 PM
trend for polynomial curve fitting by regressing vijaya Excel Worksheet Functions 7 November 11th 05 03:51 PM
Polynomial Formula Incorrect? DCLittlejohn Charts and Charting in Excel 1 June 27th 05 08:50 PM
How do you use solver to solve a polynomial DW Excel Discussion (Misc queries) 1 June 7th 05 12:36 PM


All times are GMT +1. The time now is 02:21 AM.

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"