Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Stats in Excel
Resolved · Low Priority · Version 2003
Dee has attended:
Excel Advanced course
Excel Intermediate course
I am working with a number of very large spreadsheets. The data in the columns are vehicle speeds. The columns are headed for the hour in a 24 hour day. For what we need, the hour does not count, just all the recordings for speed. I can sort the average, but I also need to get the 85th percentile from all the speeds, plus the percent above the average and the percent greater than 15 mph over the average. I'm probably being braindead here, but I can't find a way to get this data from the cummulative set of numbers across 24 columns. Do I need to slog it out with each individual column, or should I move everything into one column? I keep thinking there is an easier way to do this.
Cheers,
Dee
Hello Dee
Thank you for your question and apologies for the delay in response.
Have you got a sample spreadsheet you can send through so we can have a look at what you're working with? If so my email address is amanda@stl-training.co.uk
Kind regards
Amanda
Hello Dee
Thanks for sending your spreadsheet in.
Please find attached the spreadsheet with the results I think you are after. I named the range of cells containing the figures as speeds, just to make things a bit easier when putting in the formulas. I'm not a statistician, but I think the function I've used to get the 85th percentile is giving the right result, but I'll leave that up to you to judge :)
Hope this helps.
Kind regards
Amanda
|
|
Excel tip:Recovering Unsaved Work in Excel 2010Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.11 secs.
Microsoft Training question response.xls