ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to find the Expected Value of a PDF (https://www.excelbanter.com/excel-programming/382361-how-find-expected-value-pdf.html)

[email protected]

How to find the Expected Value of a PDF
 
Hello all,

I'm at a loss of how to find an expected value using Excel for my PDF
of *continuous* data. Basically, I have an f(x) function that has
produced exponential values.

Any ideas?

Thanks!


NickHK

How to find the Expected Value of a PDF
 
PDF ?
You mean UDF ?

If so, still not sure what you are after. Explain further.

NickHK

wrote in message
oups.com...
Hello all,

I'm at a loss of how to find an expected value using Excel for my PDF
of *continuous* data. Basically, I have an f(x) function that has
produced exponential values.

Any ideas?

Thanks!




[email protected]

How to find the Expected Value of a PDF
 
On Jan 31, 7:06 pm, "NickHK" wrote:
PDF ?
You mean UDF ?

If so, still not sure what you are after. Explain further.

NickHK

wrote in message

oups.com...

Hello all,


I'm at a loss of how to find an expected value using Excel for my PDF
of *continuous* data. Basically, I have an f(x) function that has
produced exponential values.


Any ideas?


Thanks!



PDF = Probability Density Function


NickHK

How to find the Expected Value of a PDF
 
Here's one from Google:
http://home.btconnect.com/Farnham/PDFunctions.htm

NickHK

wrote in message
ups.com...
On Jan 31, 7:06 pm, "NickHK" wrote:
PDF ?
You mean UDF ?

If so, still not sure what you are after. Explain further.

NickHK

wrote in message

oups.com...

Hello all,


I'm at a loss of how to find an expected value using Excel for my PDF
of *continuous* data. Basically, I have an f(x) function that has
produced exponential values.


Any ideas?


Thanks!



PDF = Probability Density Function




Mike Middleton

How to find the Expected Value of a PDF
 
p.krembs -

I think you need to provide more details.

Do you have the formula for a probability density function (in which case
you need to use integration to obtain the expected value) ?

And, what do you mean by "an f(x) function that has produced exponential
values" ? Does that mean you have data but not the function that generated
the data?

- Mike
http://www.mikemiddleton.com


wrote in message
oups.com...
Hello all,

I'm at a loss of how to find an expected value using Excel for my PDF
of *continuous* data. Basically, I have an f(x) function that has
produced exponential values.

Any ideas?

Thanks!





All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com