Histogram, box plot, quantile plot, and other statistician-friendly features needed
I am regularly surprised when Excel can do complex operations using built in functions, but there is a lack of data visualization options out there. For example, a histogram, box plot, and quantile plot can provide options for visualizing and comparing data. I know these can be achieved using various add-ins (for example QI Macros), but those are never perfect and always seem hokey. Also would love to be able to do hypothesis tests (t-test, f-test, z-test, and so on) in user friendly and visual manner. Also, for all charts, please add a feature for using split column(s) to differentiate the data in a chart. Currently, you would have to have a separate column for each split to be plotted - not really the best practice. Adding these features, and more, will make Excel a competitor to some of the top data analysis software out there like JMP or Minitab or Spotfire.
In Office 2016, we released 6 new built in chart types: Treemap, Sunburst, Histogram, Pareto, Box & Whisker, and Waterfall. Checkout the following link for the top new features in Excel 2016. https://docs.com/ExcelDemos/7981/excel-2016-top-features.
However, there are several other feature requests wrapped up in this post. Please enter those as separate items so that we can respond to them individually.
Lack of histograms is a real pain for me and one of the reasons I use minitab for visualising most of my data nowadays. A normal distribution fit with stdev and the mean as the equation would be the icing on the cake.
A normal probability axis, including cumulative probability option, would be wonderful. Have the option to format the axis labels as decimal, percent, or 1/p.