Excel Crazy

“ONE VARIABLE CORRELATED WITH ANOTHER VARIABLE” – SCATTER PLOT CHART

When we see random(Scatter) things we plan to organize them, and then we think how we can do that in a simple way to solve it, so here comes the main word scatter. Then we plan to make “scatter” word in the PLOT(diagram) form, which makes things to understand more easily to solve them with day-to-day work.

So now, let’s first understand Scatter Plot. A Scatter (XY) Plot has points that show the Correlation between two sets of data.
In scatter plot chart, we use horizontal and vertical axes to plot data points. Scatter plots show how much one variable is correlated by another. The relationship between two variables is called their correlation.

Different Types of Scatter Plot Charts.

  • Positive Correlation
  • Negative Correlation
  • None

Steps to Make Scatter Plot:

  • Select the data that you want to plot on the scatter chart.
  • On the Insert tab, in the Charts group, click Scatter.
  • Click Scatter with only Markers.
  • Click the chart area of the chart.
  • On the Design tab, in the Chart Styles group, click the chart style that you want to use.

Exercise:

An online retail company has captured the sales data of three products (Gold, Iron, and Silver) across states of united states. Management is interested to see the correlation between quant variables like Sales, Profit, Discount, and Cost.

Reporting team has decided to create the scatter plot chart with two combo box controls and three checkbox controls. In two combo box control user will select the variable and checkbox will help them to analyze which product scattering they want to see.

December 21, 2017

0 responses on "“ONE VARIABLE CORRELATED WITH ANOTHER VARIABLE” - SCATTER PLOT CHART"

Leave a Message

Your email address will not be published. Required fields are marked *

top
 

© LOKESH PALIWAL 1987 - 2018

LOKESH@EXCELCRAZY[DOT]COM | 8826547882

Reporting Solutions | Data Consulting | Analytics Training

CONTACT US
close slider

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Message for us...

Skip to toolbar