x
Solved

# Statistics

Posted on 2013-11-26
Medium Priority
234 Views
The attached file has 2 columns: column A has a list of jobs and column B has time information. I also added column C to show approx. how many hours it takes to run a job.

I need to figure out processing time for 50% of the jobs and 95% of the jobs.

thanks!!
Statistics.xlsx
0
• 2
• 2

LVL 50

Expert Comment

ID: 39678514
Not sure what you mean. If you want a time which would be longer than 95% of the jobs use PERCENTILE function, e.g.

=PERCENTILE(C2:C75,95%)

and so the total time for all jobs under that threshold would be

=SUMIF(C2:C75,"<="&PERCENTILE(C2:C75,95%))

change to 50% for your other query

regards, barry
0

Author Comment

ID: 39678634
What I am trying to get should look like this (it's an example):

50% jobs were done within 1.03 days,
95% jobs were done within 2.28 days.
1.03 and 2.28 is what I am trying to figure out.  Does make sense? Ignore column C, it is extra.

thanks!!
0

LVL 50

Accepted Solution

barry houdini earned 2000 total points
ID: 39678659
OK, then I think you just want Percentile applied to column B like this

=PERCENTILE(B2:B75,50%)

and

=PERCENTILE(B2:B75,95%)

that should give you 1 and 2.775 respectively

regards, barry
0

Author Closing Comment

ID: 39678691
:):):)

thank you!!
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Are you looking to start a business? Do you own and operate a small company? If so, here are some courses you need to take before you hire a full-time IT staff.
This is a comprehensive review of a bundled Toolkit designed for use by IT Professionals and End Users to help Microsoft Outlook fans manipulate Outlook files and repair some common problems. Enjoy...
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
###### Suggested Courses
Course of the Month10 days, 13 hours left to enroll