Get instant live expert help on lower quartile calculator

“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

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
I'm trying to use the quartile function and I am getting a #num error for the first quartile but not the 2nd or third. I tried the percentile, and the same thing happens
Solved by K. A. in 28 mins
I wish to calculate the mean of a dataset of 445 positive numbers, including zero, that excludes the outliers. The greatest value of Quartile1 is less than the Inter-Quartile Range (IQR) between Q1 and Q3. When I subtract 1.5 times IQR from Q1, the result is a negative number. There are no outliers in Q1. When I add 1.5 times the Inter-Quartile Range to Q3, the result identifies 21 outliers. If I use TRIMMEAN, an equal number of values from the lower and upper range of data points is excluded. But I want the 21 large positive numbers excluded. How can I do this, please?
Solved by S. E. in 15 mins
please help i need to find median and quartile measures from this set of data
Solved by Z. Y. in 27 mins
I have created a formula with true and false however would like it to be $0 if the cells are blank. =IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)
Solved by O. E. in 12 mins