web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Percentile Interpolato...
Power Apps
Unanswered

Percentile Interpolator Calculator based off 25th, 50th, 75th, 90t

(0) ShareShare
ReportReport
Posted on by

I have a percentile calculator in excel but I was wondering if I could replicate this in PowerApps so I can put it on SharePoint and make it web based. 

We do not have to put in the Hourly Rate in there.  The most important thing is the value in yellow.

wherdzik_1-1702041469005.png

This is the formula that is in i11 which creates the percentile interpolation.

 

=NORMSDIST(TREND(NORM.S.INV(SMALL(LEFT(E10:H10,2)/100,IFNA(MIN(MATCH(D11,E11#),3),1)+{0,1})),SMALL(E11#,IFNA(MIN(MATCH(D11,E11#),1),3)+{0,1}),D11))*100

 

Categories:
  • AARON_C Profile Picture
    2,235 Most Valuable Professional on at

    Hi @wherdzik,

     

    Could you please provide the actual calculation you need done instead of the formula you have used in Excel.

     

    How are you thinking about getting these values in power apps? Would they just be user input or from a sharepoint list?

  • wherdzik Profile Picture
    on at

    Yes the data source would be SharePoint list. It would allow you to select a medical specialty which would bring in all of these percentiles for the selected specialty.  

     

    This is what the formula is doing to get the percentile.

    • Converts Percentiles: Converts percentile labels to numbers for comparison (e.g., "25th" becomes 0.25).
    • Benchmark Selection: Chooses salary figures just above and below your target salary to use as references.
    • Z-Score Calculation: Transforms these reference salaries into z-scores, which indicate how many standard deviations away from the mean these salaries are.
    • Trend Analysis: Uses linear regression to predict where your salary fits into the overall distribution.
    • Percentile Conversion: Converts the predicted z-score back into a percentile to show where your salary stands in comparison to the market.
    • Percentage Formatting: Multiplies the percentile by 100 to display it as a standard percentage.

     

    All I want it to do is give me where my entered value is expressed as a percentile given the 25th, 50th, 75th and 90th percentiles.  I want it to make an estimation given known data and interpolate the percentile based off of this known data.  

  • AARON_C Profile Picture
    2,235 Most Valuable Professional on at

    @wherdzik 

     

    Could you provide the calculations you did to get $255,000 from the current data that is underneath each percentile. I do not understand much statistics so need I would like to see a worked out example.

     

    Just also wanting to clarify the situation. So I see that this is a calculator in your Excel file, what values are user inputs in this if any?

     

    Is the (Market) Percentile Data always those values under the 25th, 50th, 75th, 90th percentiles?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard