Get instant live Excel expert help to learn how to create a statistical function in Excel?

Continue work on file attached, I had told the previous expert that i needed the 0.25 percentile of column AHT attainment column but i actually need the percentile of AHT instead. I also want to see if theres a way I can do the formula for all tabs instead of manually changing the formula for every cell.

I need help using the empirical rule to describe the Gross Total data in the 95th and 99th percentile.

Hi I ran the percentile formula in a cell and get an error message #NUM! - I enabled Iterative Calculations and it still didn't resolve it. Help?

Hello! I need to create a report using data from the tab "Master Pool" in this document. You'll see in this document there's a header in the tab "Master Pool" called accnum. This is our unique identifiers for this document, and the thing we'll be counting in the final pivot table. There's also headers called "Test", "Measure", and "Item Type". These are what we will use for filters. That above part of the pivot table (and I'm open to this report being expressed in whatever way works, I just chose pivot table because that makes the most sense) is easy. Now here's the issue. What I want to measure in the report is found under the headers Accessibility 1, Accessibility 2, Accessibility 3, and Accessibility 4. Each row has different values for these 4 columns. Each column can have one of a few options for this values (see tab "A11Y Tag Placements"). These values are not presented in the data in any specific order, nor is the data the same across items (For example- In the column Accessibility 1- a row can contain just "Magnification". It could also contain "Magnification" and "ASL".). The issue I'm running into, is that when I try to make my pivot tables, because the info in those cells (Accessibility 1-4) is can change from row to row wildly, but still only has a few set options, what I get is all the permutations of what those values can be arranged as for values. What I need (please see tab "A11Y Placements") is the actual values of those fields extracted, and total counts for each values in the way I've presented them on tab "A11Y Placements". I then need to be able to filter down these counts using the filters "Test", "Measure", and "Item Type".

Hello! I need to create a report using data from the tab "Master Pool" in this document. You'll see in this document there's a header in the tab "Master Pool" called accnum. This is our unique identifiers for this document, and the thing we'll be counting in the final pivot table. There's also headers called "Test", "Measure", and "Item Type". These are what we will use for filters. That above part of the pivot table (and I'm open to this report being expressed in whatever way works, I just chose pivot table because that makes the most sense) is easy. Now here's the issue. What I want to measure in the report is found under the headers Accessibility 1, Accessibility 2, Accessibility 3, and Accessibility 4. Each row has different values for these 4 columns. Each column can have one of a few options for this values (see tab "A11Y Tag Placements"). These values are not presented in the data in any specific order, nor is the data the same across items (For example- In the column Accessibility 1- a row can contain just "Magnification". It could also contain "Magnification" and "ASL".). The issue I'm running into, is that when I try to make my pivot tables, because the info in those cells (Accessibility 1-4) is can change from row to row wildly, but still only has a few set options, what I get is all the permutations of what those values can be arranged as for values. What I need (please see tab "A11Y Placements") is the actual values of those fields extracted, and total counts for each values in the way I've presented them on tab "A11Y Placements". I then need to be able to filter down these counts using the filters "Test", "Measure", and "Item Type". It's fine if it takes more than 20 minutes to solve. I can buy more credits.

How do I calculate all permutations (concatenate) of each column of 7 rows without having to manually do such?

How do I calculate all permutations in multiples of 2 of a row containing up to 7 columns?

how to write a quartile if statement with 3 conditions =QUARTILE(IF('All USA Data - sheet 1'!$E$2:$E$2031=B61,if('All USA Data - sheet 1'!$M$2:$M$2031),if("<2",IF('All USA Data - sheet 1'!$N$2:$N$2031<>0,'All USA Data - sheet 1'!$N$2:$N$2031)),1) where am going wrong?

Hi! I am trying to create a quartile if function based on any one of several conditions being bet and then a quartile and if function with two conditions being met.

Hi, I'm trying to do conditional formatting based on quartile formula for column U in this data. I want to highlight Columns A through to BV based on quartiles. It's not saying there's an error in formula but nothing is highlighting?