Hope you are doing great. I have a long list with the following structure:
Name Res 90th P Res
A 110.8 113.2
B 114.1 113.44
C 108.5 108.98
I am trying to calculate a percentile of salleries in a table if they've worked between 24 and 60
What I've done so far which actually works:
25% Percentile sallery Monthsworked <24...
So I need to calculate the 95th and 5th percentile for a specific set of cells. However, my data is 10s of thousands of rows long as it is temperatures from every day of the year over a period of 30-100 years. So I want to work out the 95th percentile for the temperature on January 1st of every...
I am trying to calculate the Median & 75th Percentile for the range in array where the range differs in the length. For example, my data looks like the one given below (my data-set is almost 100,000 rows). Now I am trying to find the median and 75th percentile values of a combined set of 3...
I want to know how to calculate percentile for a large data set. I have to calculate percentiles of 5th,10th,20th,30th,40th,50th,60th,70th,75th,80th,90th and 95th for a known value of data lets say.
I can do...
I am trying to create a macro which will calculate percentile for a set of range in a row but the numbrs of cells change and hence the range needs to be dynamic. I have record the macro:
I have data with multiple columns. In one column I have months designated 1 - 12 (column C). In another column I have values such as temperature (column P). I am trying to calculate the 85th percentile of only the months may - October (5 - 10). I have tried a nested percentile if and...
with EXCEL 2010 there is this nice percentile_inc function that gives the k-percentile value of a part of this worksheet.
This works fine - also for a 2-dimensional table, and even the values must not be sorted.
Now, I want to use this function within a VBA program.
A maximum of...
I have data in the following format:
Number of Occurences
How I can use Excel to get the value of a given percentile. So for example, the 15th percentile is 32, the 85th percentile is...
I have a large data set where the data is delineated by a field called "Category." For each Category, I'd like to calculate the PERCENTILE.INC for each row within that Category. For example, here is some sample data with the (manual) formula. I'd like a way to automatically calculate the range...
I am trying to automate percentile report generation. Any help would be greatly appreciated.
1. I get 40 csv files with data everyday under a shared LAN folder. Folder name is current date and 40 csv files names remain same.
2. I need to calculate a percentile report everyday...
OK so here is my not working formula, which in fact needs to be extended to include references G3 and H3:
The problem is the source data with formatting which means that there is not always a value in column E, sometimes it is in F or G or H, and...
So basically I have a column of numbers. I need to calculate the 25th, 50th, 75th, and 90th percentiles automatically. There is one blank row between the bottom of the column and my 25th percentile calculation. The VBA code below would work if the column was a fixed number of rows but there...