| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Computing Quartiles with Excel 2007
No problem. Thanks for the reply
On 19 Mar, 17:28, Quco wrote: Excellent! Thank you! "Lori" wrote: =QUARTILE((A1:A100,A201:A221),1) for the first quartile, for the other values use 0,2,3,4 instead. On 19 Mar, 16:50, Quco wrote: Hi, I have the following problem, that I would think it would be easy to solve but I haven't find a way to do it. I have a large set of data where I run simple descriptive statistics from let's say A1:A100 to get the following distributioin analyzis: Minimum =MIN(A1:A100) 1st Quartile =QUARTILE(A1:A100,1) Median =MEDIAN(A1:A100) 3rd Quartile QUARTILE(A1:A100,3) Maximum =MAX(A1:A100) No problem at this point. Now, the Excel spreadsheet cannot be modified by changing the order of where the cells are. New data comes in, it wasn't supposed to be new data, but furtehr down the road we realized we accidentantly skipped 21 values BUT THERE IS NO WAY WE CAN MODIFIED THE CELLS ON THIS SPREADSHEET. Instead, I decided to put the new 21 values of data at the very end of the spreadsheet. MY QUESTIONS is this: how do you compute the quartiles for the set of data when you have the location of the data separated on the spreadsheet? As you can see, it is an easy fix for the Max, the Median and the Mean. But who cal help me to figure this out? what do you do with the quartiles? This is how my spreadsheet looks now: Minimum =MIN(A1:A100,A201:A221) 1st Quartile =QUARTILE(A1:A100,1) Median =MEDIAN(A1:A100,A201:A221) 3rd Quartile QUARTILE(A1:A100,3) Maximum =MAX(A1:A100,A201:A221) I am combining two arrays to cover all data, but how do you do the same with the Quartile formula? Please Help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add quartiles and mode functions to pivots tables in Excel! | Excel Discussion (Misc queries) | |||
| graphing quartiles..does anyone have a source for how to do this? | Charts and Charting in Excel | |||
| QUARTILES in Excel | Excel Worksheet Functions | |||
| Algorithm for computing Excel PercentRank | Excel Worksheet Functions | |||
| Calculation Method for Quartiles | Excel Worksheet Functions | |||
Threaded Mode
