Erlang distribution-integral problem

hafizahzulkipli88

New Member
Joined
Jan 26, 2017
Messages
2
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).
 

Some videos you may like

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
Joined
Aug 18, 2015
Messages
9,870
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:

Watch MrExcel Video

Forum statistics

Threads
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...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top