Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Decile Analysis

Posted on 2014-01-28
2
Medium Priority
?
547 Views
Last Modified: 2014-02-12
I need to do decile analysis on the attached data set (which shows average cycle time by numbers of deals).
We have a target goal of 17 days for deal processing and need to trim down some cycle times somewhere to achieve targets. Therefore, if I know that 10% of deals hit aspiration, what kind of movement has to occur on the other 90% to allow us to hit our goals?  So if I could shave off 5 days on deciles 6-10 while keeping deciles 1 -5 static, what becomes the average?

                        Threshold                        Target                   Max
              20            17            14

Is this analysis possible in Excel? I ran the query in Oracle – PL/SQL – any easier way to do it there?

Thanks.
Summed-Deals---3mos.xlsx
0
Comment
Question by:saved4use
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 84

Accepted Solution

by:
ozo earned 1000 total points
ID: 39815888
"what kind of movement has to occur"
The only information relating to "kind" that I see in your data are "DEALS" and "TOTAL_CYT"
and the only thing relating to "movement" that I see are numbers with different values.
So the only things an analysis of that data could tell you is whether you would want to change the number of "DEALS" or whether you would want to change the number of "TOTAL_CYT"
I'm not sure how such an analysis would be helpful to you.
0
 

Author Comment

by:saved4use
ID: 39816020
@ozo
How would I represent what you are saying with the data? What would you do differently to achieve a helpful analysis?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

636 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