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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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.
Solved by I. D. in 19 mins
I need help using the empirical rule to describe the Gross Total data in the 95th and 99th percentile.
Solved by S. U. in 27 mins
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?
Solved by G. W. in 23 mins
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".
Solved by X. D. in 21 mins
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.
Solved by V. U. in 19 mins
How do I calculate all permutations (concatenate) of each column of 7 rows without having to manually do such?
Solved by X. S. in 20 mins
How do I calculate all permutations in multiples of 2 of a row containing up to 7 columns?
Solved by V. B. in 17 mins
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?
Solved by K. L. in 15 mins
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.
Solved by C. Y. in 21 mins
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?
Solved by D. E. in 25 mins