Share via

Weibull Inverse Function

Anonymous
2022-07-08T19:07:51+00:00

Good day, I use probability distributions in excel frequently, and I noticed that all the distributions have inverse functions (NORM.INV / LOGNORM.INV / GAMMA.INV) except the Weibull, which is missing its inverse function.

The Weibull distribution is defined as Probability=WEIBULL.DIST(X,alpha,beta,cumulative), I was able to define and validate the inverse function to be: X=(Beta*(-LN(1-"Probability"))^(1/$Alpha))

Is that something the developers are planning on adding in the near future?

Thank you,

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-09T19:23:31+00:00

    Thank you, Neha!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-07-09T06:40:05+00:00

    Dear BMarr87,

    Greetings! Thank you for posting in Microsoft forum.

    Regarding your request, please consider posting your feedback in Excel Feedback portal and let the Product group know about your requirement. The Feedback portal is the best way to give feedback to Product Group as it’s actively monitored by them.

    Thank you for your understanding and co-operation. Stay safe and stay healthy.

    With sincerest regards,

    Neha Singh | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments