# Erlang distribution-integral problem

#### hafizahzulkipli88

##### New Member
Hi. I have problem regarding the Erlang distribution. I have an equation like below:

Code:
`` \integrate from Q to infinity of [(x-Q) f(x)] dx``
. f(x) follow pdf of erlang distribution.
Can I solve this equation using vba?
I don't know if excel has any build in Erlang p.d.f like normal p.d.f e.g(WorksheetFunction.NormDist(x, Av, StD, False).

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### Eric W

##### MrExcel MVP
Welcome to the forum.

I can point you to 2 links which may help.

First, check out the GAMMA.DIST function:

https://support.office.com/en-us/article/GAMMA-DIST-function-9b6f1538-d11c-4d5f-8966-21f6a2201def

According to the last remark:

When alpha is a positive integer, GAMMA.DIST is also known as the Erlang distribution.
Second, here is a link to a macro that shg provided that does numerical integration.

https://www.mrexcel.com/forum/excel...ual-basic-applications-solving-integrals.html

Hope this helps.

Last edited:

1,101,802
Messages
5,482,986
Members
407,371
Latest member
Ernest F Mink

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...