directorylkp.blogg.se

Scatter chart excel definition
Scatter chart excel definition








scatter chart excel definition

Recommended reading: All about Bar Charts and their uses Types of Scatter Charts The resultant graph is represented below. Then each dot can be given a specific color in accordance with the gender of the child. In this chart, if you want to add another variable, say, the gender of the children. To make this clearer, let us take an example, suppose you are portraying a relationship between height and weight of children. Scatter plots can have a third variable introduced in them, by changing the color or size of the dots. The resultant graph will show you how the number of accidents increases with increase in the speed of vehicles and thus depict the correlation between them. The two variables that need to be considered will be, the number of accidents and the speed of vehicles. Scatter plots are a good way to predict and determine the nature of an unknown variable by plotting it with a known one.įor example, suppose you want to show the pattern of accidents happening on the highway. If the graph forms a band from lower left to upper right, it indicates a positive correlation between the variables and if it goes the other way around, that is, goes from upper left to lower right, that shows a negative correlation. But if they are arranged equally, the correlation is low. If all the dots are close to making a straight line, the correlation is high. If there is no dependent variable, then either of the variables can be plotted on any axis and chart provides us with the degree of difference between these two variables, which is better known as correlation.

scatter chart excel definition

The dependant or measured variable is plotted along the Y-axis. The independent variable also called the control parameter, that systematically increases, or decreases is plotted along the horizontal or x-axis.

scatter chart excel definition

The main use of scatter charts is to draw the values of two series or variables and compare them over time or any other parameter. The first variable is independent, and the second variable is dependent on the first one. This chart is between two points or variables. Scatter charts are known by different names, scatter graph, scatter plot, scatter diagram or correlation chart.

scatter chart excel definition

Unlike other charts, that uses lines or bars this chart only uses markers or dots.










Scatter chart excel definition