I have some data from an experiment (which I did not design) that I'm supposed to analyze. After looking through the possible options for displaying the data to visually analyze, I believe that a radar plot would work if properly customized or weighted (the only other option I can imagine would be a scatter plot).
While I cannot post my actual data, I've made a mock up of the experiment that has the same general layout as what I have to work with. The file is here: https://docs.google.com/spreadsheets/d/1007Gb2lEaMtZ_N9LFrQEn2L35cHS7MlXBCF5AgbZ1Nk/edit?usp=sharing
Basically, there were three distances along a test cylinder at which data was collected. At each distance, the angular location of a local high value and the angular location of a local low value were recorded. As well, the actual low and high values were recorded.
Each record of the table contains the following:
(part_number, High_Location_A, Low_Location_A, High_Location_B, Low_Location_B, High_Location_C, Low_Location_C, High_Value_A, Low_Value_A, High_Value_B, Low_value_B, High_Value_C, Low_Value_C)
My goal is to find a trend in this data (I have almost 70 entries in the table to work with) and to be able to display it for analysis and explanation of findings.
An example would be fantastic, or even just advice on a better way to plot the data.