Price change % is my column of interest. I would like to measure whether or not there are correlations between Price change % and any of the other columns. What visualisations would be best for this?
What I've tried so far is creating pivot tables and grouping by Production year, Category, Margin % and Category 2 and sorting by Price change %. I've then attempted a scatter graph by displaying the Production year on the x axis and Margin% on the y axis. Does this make any sense? Or must I have the Price change % as one of the axis? Also, I haven't been able to introduce attentional measures to the scatter graph. Would it be beneficial to do so to measure the correlation when multiple groups are combined. Eg a certain combination of Category 2 + Production year.
What MS visualisations or other tools in Excel would you recommend for me to use in order to assess correlations?
What I've tried so far is creating pivot tables and grouping by Production year, Category, Margin % and Category 2 and sorting by Price change %. I've then attempted a scatter graph by displaying the Production year on the x axis and Margin% on the y axis. Does this make any sense? Or must I have the Price change % as one of the axis? Also, I haven't been able to introduce attentional measures to the scatter graph. Would it be beneficial to do so to measure the correlation when multiple groups are combined. Eg a certain combination of Category 2 + Production year.
What MS visualisations or other tools in Excel would you recommend for me to use in order to assess correlations?