Get instant live expert help on I need help with box and whisker plot calculator
“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
1) Instead of have outliers on box and whisker plot shown as points, have highest and lowest outliers be shown as max and min of box whisker plot. 2) Show title for each box whisker plot on one chart 6 plots.
Solved by A. H. in 25 mins
I have a box and whisker plot chart. I want to add a horizontal line that doesn't represent a trend or average, but rather an outside threshold effecting my results. Is there any way to add a horizontal line without having to draw it?
Solved by T. S. in 24 mins
Create a box plot to characterize this distribution of these MBA salaries.
Solved by K. S. in 22 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
Created a trend curve for some data; Excel shows the equation as 2E + 06^X^(-1.331). However, when I plot it in a graphing calculator, it does not match the curve drawn in the excel chart.
Solved by F. Y. in 12 mins