Solved

Percentile or 60% of the quotes

Posted on 2015-02-24
2
73 Views
Last Modified: 2015-02-26
Hi All,

I have list of quotes and actual discount and threshold for the same ( refer attachment)

Quotes      Actual Disc      Threshold      Quarter
1                 97%                  55%               14-Q1
2                 76%                  55%               14-Q1
3                 25%                  55%               14-Q1
4                  25%                 55%               14-Q1
5                  25%                60%               14-Q2
6                  25%               60%                14-Q2
7                 45%              60%                         14-Q2
8                 25%             60%                         14-Q2
9               35%             60%                         14-Q2
10               25%             60%                          14-Q2
11               65%           60%                         14-Q2
12              25%                  60%                        14-Q2
13             25%                 60%                        14-Q2


I would like to calculate the actual discount availed for 60% of quotes.

I have used the percentile formula mentioned below.

=PERCENTILE(B3:B15,0.6) and the answer is 27%
Does it mean that 60% of the quotes are availing discount at 27% or is there any other  way to calculate it?

Basically i wanna see if 60% of the quotes are below threshold.

Percentile-Example.xlsx
0
Comment
Question by:Ganesh Vijaykumar
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
Comment Utility
Yes, that's right - see tthis article for confirmation.

There are alternative ways to calculate it in Excel 2010 - see PERCENTILE.EXC
0
 

Author Closing Comment

by:Ganesh Vijaykumar
Comment Utility
Thanks for the response!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now