Formula

Resolved · Low Priority · Version 2007

Formula

Gavin has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

by - delegate Gavin [3 posts] (2008 Jul 7 Mon, 16:19) Reply

How can I calculate P25, P50, & P75 for 3 different data points within a range of numbers e.g. Median Salaries.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Formula

by - trainer Mark gold contributer [244 posts] (2008 Jul 17 Thu, 11:27) Reply

Hi Gavin

How are you hope you are well

Could you please give me a bit more calification on what you are trying to do and what you mean by median salaries

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the Reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Many Thanks

Mark East
MOUS Master Instructor
mark

· How to Create Better Excel Spreadsheets: Part Three
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Improve Performance Of Your Excel Macros
· What's Better Than the Help Function in Excel? Microsoft Training
· Tips to Facilitate Printing of Excel worksheets

Please browse our web site to find out more about
excel+course and other Microsoft training courses.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Rate this page: