Get instant live expert help on how to calculate q1
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to calculate the achievement percentage for q1,q2,&q4. For example accuracy( would be gut / finish (ie how accurate their forecasts were every week vs. how they actually finished) and then *achievement* would be finish / target (how well they did to their EOQ goal
Solved by T. W. in 25 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
hi, I need help using quartiles. I have been given a data set. It is asking me to calculate the q1, q2, q3, q4 values for number of victims each plain crash has made.
Solved by M. H. in 14 mins
Hi, can you help me with Q1 in file attached?
Solved by O. D. in 11 mins
Need Week 6, Week 9, Week 12 for Q1, weekly gut % difference
Solved by O. U. in 13 mins