See the related posts on RExcel (for basic, Excel 2003 and Excel 2007) for basic information.
When there are large number of variables we want to see how they are distributed whereas how they are related with each other. Scatter plot matrix is greatway to do it.
(1) We will use the same data we used in previous post, please refere it too see how we can load data and work in RExcel (link is here).
(2) Under graphs menu click scatter plot matrix. Now select the variables you want to plot in scatter plot matrix. You can choose different distribution plots (eg. density, histogram, boxplot, Normal Q-Q plot, one dimensional scatter plot, or even nothing). You have choose whether to plot smoothed line or not. You can accept defaults. Let's say we select 7 variables (V1 to V7).
You can see the plots nicely arranged.
Here are with histogram, boxplot, normal Q-Q plot in the center.
When there are large number of variables we want to see how they are distributed whereas how they are related with each other. Scatter plot matrix is greatway to do it.
(1) We will use the same data we used in previous post, please refere it too see how we can load data and work in RExcel (link is here).
(2) Under graphs menu click scatter plot matrix. Now select the variables you want to plot in scatter plot matrix. You can choose different distribution plots (eg. density, histogram, boxplot, Normal Q-Q plot, one dimensional scatter plot, or even nothing). You have choose whether to plot smoothed line or not. You can accept defaults. Let's say we select 7 variables (V1 to V7).
You can see the plots nicely arranged.
The relationship between variables is called correlation. Correlation is just another word for "relationship." For example, how much you weigh is related (correlated) to how much you eat. There are two types of correlation: positive correlation and negative correlation. If the data points form a line from the origin from the low values of x and y to the high values of x and y, the data points are positively correlated, as in the previous graph. If the graph starts with high y values and continues with low y values, then the graph is negatively correlated.
ReplyDeletehttps://ppcexpo.com/blog/scatter-plot-examples
A scatter plot is another useful data visualization technique that is used to display the correlation or relationship between the two variables. Carefully created, well-designed scatter plots help you see the correlation between the complex set of data easily.
ReplyDeleteScatter plot