Normal Distribution Function

[Thomas]

Hi,

One short question: “Is in Optuma the Excel function “NORMSDIST” available?”

For example: NORMSDIST(-0.5333-(0.633*A1)).

The values -0.5333 and -0.633 are constants.

Thanks,
Thomas

[Mathew]

Hi Thomas,

No, we don’t have that. I’m curious as to how you would use that in Optuma. Do you see it having value as a time series data set?

All the best

Mathew

[Thomas]

Hi Mathew,

thanks for your replay. The reason why I am interested in this function is an article from the Fed of New York about how to calculate the probability of a recession. See page three in “The Yield Curve as a Leading Indicator: Some Practical Issues”.

Here are the links:
…https://www.newyorkfed.org/research/capital_markets/ycfaq.html#/
…https://www.newyorkfed.org/research/current_issues/ci12-5.html

At the moment I make the calculations in Excel and create a csv file to display the data in Optuma. I have no problem with that but thought perhaps it is possible to do the calculations directly in Optuma.

Here is a chart about how I use the recession probability:

Best wishes,
Thomas

[Mathew]

Hi Thomas,

I’ll have a read and see what we can do for Optuma 2.1.

In the mean time have you seen this https://twitter.com/mathewverdouw/status/1322400468530683906

All the best

Mathew

[Author]

Posts