4.5: Visualizing Correlations

Last updated
Save as PDF

Page ID: 138291

$ \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $

$ \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} $

$ \newcommand{\dsum}{\displaystyle\sum\limits} $

$ \newcommand{\dint}{\displaystyle\int\limits} $

$ \newcommand{\dlim}{\displaystyle\lim\limits} $

$ \newcommand{\id}{\mathrm{id}}$ $ \newcommand{\Span}{\mathrm{span}}$

( \newcommand{\kernel}{\mathrm{null}\,}\) $ \newcommand{\range}{\mathrm{range}\,}$

$ \newcommand{\RealPart}{\mathrm{Re}}$ $ \newcommand{\ImaginaryPart}{\mathrm{Im}}$

$ \newcommand{\Argument}{\mathrm{Arg}}$ $ \newcommand{\norm}[1]{\| #1 \|}$

$ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$

$ \newcommand{\Span}{\mathrm{span}}$

$ \newcommand{\id}{\mathrm{id}}$

$ \newcommand{\Span}{\mathrm{span}}$

$ \newcommand{\kernel}{\mathrm{null}\,}$

$ \newcommand{\range}{\mathrm{range}\,}$

$ \newcommand{\RealPart}{\mathrm{Re}}$

$ \newcommand{\ImaginaryPart}{\mathrm{Im}}$

$ \newcommand{\Argument}{\mathrm{Arg}}$

$ \newcommand{\norm}[1]{\| #1 \|}$

$ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$

$ \newcommand{\Span}{\mathrm{span}}$ $ \newcommand{\AA}{\unicode[.8,0]{x212B}}$

$ \newcommand{\vectorA}[1]{\vec{#1}} % arrow$

$ \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow$

$ \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $

$ \newcommand{\vectorC}[1]{\textbf{#1}} $

$ \newcommand{\vectorD}[1]{\overrightarrow{#1}} $

$ \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} $

$ \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} $

$ \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $

$\newcommand{\longvect}{\overrightarrow}$

$ \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} $

$\newcommand{\avec}{\mathbf a}$ $\newcommand{\bvec}{\mathbf b}$ $\newcommand{\cvec}{\mathbf c}$ $\newcommand{\dvec}{\mathbf d}$ $\newcommand{\dtil}{\widetilde{\mathbf d}}$ $\newcommand{\evec}{\mathbf e}$ $\newcommand{\fvec}{\mathbf f}$ $\newcommand{\nvec}{\mathbf n}$ $\newcommand{\pvec}{\mathbf p}$ $\newcommand{\qvec}{\mathbf q}$ $\newcommand{\svec}{\mathbf s}$ $\newcommand{\tvec}{\mathbf t}$ $\newcommand{\uvec}{\mathbf u}$ $\newcommand{\vvec}{\mathbf v}$ $\newcommand{\wvec}{\mathbf w}$ $\newcommand{\xvec}{\mathbf x}$ $\newcommand{\yvec}{\mathbf y}$ $\newcommand{\zvec}{\mathbf z}$ $\newcommand{\rvec}{\mathbf r}$ $\newcommand{\mvec}{\mathbf m}$ $\newcommand{\zerovec}{\mathbf 0}$ $\newcommand{\onevec}{\mathbf 1}$ $\newcommand{\real}{\mathbb R}$ $\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}$ $\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}$ $\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}$ $\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}$ $\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}$ $\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}$ $\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}$ $\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}$ $\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}$ $\newcommand{\laspan}[1]{\text{Span}\{#1\}}$ $\newcommand{\bcal}{\cal B}$ $\newcommand{\ccal}{\cal C}$ $\newcommand{\scal}{\cal S}$ $\newcommand{\wcal}{\cal W}$ $\newcommand{\ecal}{\cal E}$ $\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}$ $\newcommand{\gray}[1]{\color{gray}{#1}}$ $\newcommand{\lgray}[1]{\color{lightgray}{#1}}$ $\newcommand{\rank}{\operatorname{rank}}$ $\newcommand{\row}{\text{Row}}$ $\newcommand{\col}{\text{Col}}$ $\renewcommand{\row}{\text{Row}}$ $\newcommand{\nul}{\text{Nul}}$ $\newcommand{\var}{\text{Var}}$ $\newcommand{\corr}{\text{corr}}$ $\newcommand{\len}[1]{\left|#1\right|}$ $\newcommand{\bbar}{\overline{\bvec}}$ $\newcommand{\bhat}{\widehat{\bvec}}$ $\newcommand{\bperp}{\bvec^\perp}$ $\newcommand{\xhat}{\widehat{\xvec}}$ $\newcommand{\vhat}{\widehat{\vvec}}$ $\newcommand{\uhat}{\widehat{\uvec}}$ $\newcommand{\what}{\widehat{\wvec}}$ $\newcommand{\Sighat}{\widehat{\Sigma}}$ $\newcommand{\lt}{<}$ $\newcommand{\gt}{>}$ $\newcommand{\amp}{&}$ $\definecolor{fillinmathshade}{gray}{0.9}$

Data visualization enhances the clarity and understanding of correlation results. Scatterplots are the most direct method for assessing the relationship between two variables. In Excel, users can select two columns of data and insert a scatterplot to immediately see the distribution and any apparent trend. Figure 4.2 shows examples of scatterplots:

Figure 4.2: Examples of Scatter plots

The scatterplot on the left displays the relationship between Advertising Expenditure ($) and Sales ($). Each point represents one observation. The chart shows a strong positive correlation, with a correlation coefficient of r = 0.94.

As advertising expenditures increase, sales also tend to increase—demonstrating a consistent upward trend. This pattern supports the typical business expectation that investing more in marketing leads to higher sales revenue. The tight clustering of points around the trend confirms both the strength and reliability of the association.
Interpretation: Increased advertising spending is strongly associated with increased sales performance.

The scatterplot on the right illustrates the relationship between Price ($) and Sales ($). It reveals a strong negative correlation, with a correlation coefficient of r = –0.98. As price increases, sales consistently decrease, which is consistent with traditional economic principles of price sensitivity and demand. The pattern is very clear—when prices are lower, customers buy more; when prices rise, purchases fall. The points are tightly aligned along a downward trend, suggesting a highly predictable inverse relationship. Interpretation: Higher prices are strongly associated with lower sales, indicating customers respond sensitively to pricing changes.

Correlation heatmaps present relationships across multiple variables simultaneously. In Excel, this is done by computing a correlation matrix and using conditional formatting to create a color-coded grid. A red-to-green scale, for example, can visually differentiate between negative and positive relationships.

Figure 4.3 displays a correlation matrix heatmap highlighting relationships among key business variables. This type of visualization helps identify strong and weak associations that may warrant further exploration in predictive models.

Figure 4.3: Correlation Matrix Heatmap

From the heatmap in Figure 4.3, we observe strong positive correlation between 'Marketing Spend' and 'Sales Revenue'—a common business relationship. A strong negative correlation is seen between 'Marketing Spend' and 'Product Returns,' possibly indicating improved quality or targeting. 'Employee Satisfaction' shows weak correlations with most other variables, while 'Operational Cost' appears largely independent of other metrics. This kind of analysis guides data-driven decision-making and variable selection for further modeling.

Tableau also supports dynamic scatterplots. By dragging two measures into the Rows and Columns shelves, users can create interactive plots. Tableau allows adding trendlines to visually assess direction and strength, making it a great tool for presentations and dashboards.

Figure 4.4 illustrates how Tableau Desktop can be used to create a scatterplot. The data pane on the left includes examples of both qualitative (e.g., 'Gender') and quantitative variables (e.g., 'Advertising Expenditures', ‘Price’, ‘Sales Amount’, 'IQ'). To build the scatterplot, 'Advertising Expenditure' is dragged to the Columns shelf and 'Sales Amount' to the Rows shelf. The chart visually displays the positive relationship between these two variables. Using Tableau’s Analytics pane, a trendline has been added to help visualize the strength and direction of the correlation.

A Tableau Analytics pane showing a graph of Advertising Expenditure versus Sales. The x axis denotes advertising expenditures and the y axis denotes sales. The data goes in a generally upward trent.

Figure 4.4: Scatterplot Created in Tableau Desktop

The heatmap shown in Figure 4.5 visualizes the correlation among four business variables: Advertising Expenditure, Price, Sales Amount, and IQ. Stronger correlations are indicated by more intense red or blue shades. This plot is designed to simulate output generated by R’s `ggcorrplot` package.

A matrix heatmap noting correlation between advertising expenditures, price, sales amounts and IQ from left to right and top to bottom.

Figure 4.5: Heatmap Created using the R Programming Language

Visualizing correlations through scatter plots, heatmaps, and dashboards enhances our ability to detect and interpret meaningful relationships within data. Whether using Excel for quick analysis, Tableau for dynamic dashboards, or advanced matrix visualizations using Python or R, these tools help bring patterns to life—making data-driven insights more accessible. While understanding and visualizing correlations is crucial, the real value emerges when we apply these techniques to solve real-world business problems. In the next section, we explore how correlation analysis is used across marketing, finance, human resources, and other domains to support strategic decisions and operational improvements.

Search

Text Color

Text Size

Margin Size

Font Type