![]() However, trying to explain it can be time consuming and not worth the effort. Among them are Histogram, Pareto, and Box and Whisker. If the audience is familiar then it is a great solution. Instructor In Excel 2016, Microsoft introduced a number of new chart types. So the use of a box plot depends on your audience. The major issue I had with the box plot is that not everyone understands it. ![]() The instructions here are for Excel 2013, but histograms can be created in prior versions of Excel in a similar fashion. This is a great way to see the distribution of your data and compare it to other segments or categories. A histogram graph is used to graphically demonstrate the distribution of data within Excel. This will add a secondary axis and give you two bars. Click in the Input Range field, and then highlight the scores (not the names) of the students. In the right-pane that opens, select the Secondary Axis option. Click Histogram from the Analysis Tools list. I first started with the box plot or quartile plot. With the Profit margin bars selected, right-click and click on ‘Format Data Series’. ![]() How does the the average price of each product in Segment 1 compare to the rest? Like all good charting or data visualization projects, it took many iterations to come up with a chart that clearly communicated the story without too much explanation. I was recently doing analysis on product pricing data and the goal was to determine how one customer segment was performing against all the rest. ![]() But this same technique could be used for any combination of data value and categories sales by product and region, headcount by department and country, etc. So the data values are average price, and the categories are the products and customer segments. ![]() In this case we want to see pricing distribution for several products by customer segment. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |