The optimal visualisation of this data

Hi guys,

Diameter.PNG


I neep your opinions, what do you think would be the optimal visualisation of this kind of data ?
Thank you very much.

Yassine

Hi Jeff, thanks for your respond.
What I had in mind is the effect of quenching, but it is eventually for quality control.
No Jeff, they are 7 different components and for quality porpuses we make multiple measurements in each one of those components (Gears). In this example those are measurements for the bore diameter in each one of those gears. If your question is, whether those 7 gears have the same characteristics,then the answer is yes.

So it sounds like you want to focus on the variability of the change as a result of quenching. You might even want to use statistical process control methods to evaluate that variability.

I am not an expert at this but would be happy to show you a couple of ideas with your data, if you could attach your file (I can't do that with an image). The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Thank you so much Jeff. Here is the file.

I apologize for taking so long to look at this. Do you have standards for the tolerance of the bore diameter? What is the ideal diameter, and what are the ± tolerances for variation?

Originally Posted by 6StringJazzer

I apologize for taking so long to look at this. Do you have standards for the tolerance of the bore diameter? What is the ideal diameter, and what are the ± tolerances for variation?

Hi Jeff, it's okey, thank you so much anyway.

Yes I do, the ideal diameter should be 154.4000 and the tolerances for variation are ±0.0300 (from 154.3700 to 154.4300).


Thank you so much Jeff, I am looking foreward to your answer .

Best regards
Yassine, working student

Originally Posted by JeteMc

I don't know that this is optimal, however if you want to emphasize delta values that fall outside the tolerance you might select the range T4:AB8 and apply the following conditional formatting:
=T4>.03 (fill = red, font = white)
=T4<-.03 (fill = red, font = white)
Let us know if you have any questions.

Thanks for the idea,

I am still looking for an affective way to visualize this data all together graphs or charts..

Originally Posted by MrShorty

As Jeff first asked, so much depends on exactly what you want to get out of the visualization. It seems to me that we are still at the early (non-Excel) stage of trying to decide what kind of visualization will work. It will be difficult to give Excel specific instructions until we know what kind of visualization you want to use.

In the spirit of brainstorming, I wonder if a box and whiskers plot would be a useful visualization. A box plot is a statistical chart that readily shows both central tendency (via the median) and variability (quartiles). It should allow you to compare different gears to each other and to compare each gear's before and after (maybe not in the same box plot). Does a box plot seem like a possible candidate?

As tedious as it might be, you might need to go through a "trial and error" process of trying different charts to see what they do well and where they fall short. Until you decide what chart type you want to use, it will be difficult for us to decide for you which visualization is "optimal" (assuming there is only one optimal visualization). It might be valuable to lower the bar and seek out a "good enough" visualization rather than limit the search to a single "optimal" visualization.

Thank you so much, very useful respond!

Here is a quick one to show performance against tolerance. If time permits I will think about how statistical process control would apply, but I'm not sure the sample size is big enough to be meaningful.