![]() ![]() whether a linear relationship exists or not between the two variables.Ī line of best fit is used in the scatter plot to assess the strength or weakness of a linear relationship. ![]() The way the data points lie in the scatter plot tells us of the functional form of the relationship, i.e. The resulting trend line on the scatter plot will be as follows: Uses of the Scatter Plots Click on the drop down menu for “Trendline” and select “Linear Trendline”. Click on the graph and select the “Layout” tab from “Chart Tools”. This may be done in EXCEL by adding a trend line to the graph. Insert Tab> Charts> Scatter Plots)Ī data point on the graph shows how the USD x spot price for 1 barrel of Brent corresponds with the USD y spot price for 1 barrel of West Texas on any given day.Īs mentioned earlier a line of best fit is usually added to a scatter plot in order to better assess the strength and direction of the relationship between variables. Next using EXCEL’s chart function we construct scatter plots from the two time series obtained (i.e. To ensure the quality of the analysis it is important that data used in the study is obtained from reliable sources- always remember the old computer adage “Garbage in, garbage out”. To construct a scatter plot we need to first obtain the historical time series data for the variables, in this case, the West Texas Crude Oil and Brent Crude Oil spot price data time series. This line of best fit is used in assessing, in particular, the strength and direction of the relationship between two variables. In addition, we will also see how a line of best fit may be constructed for the given plot.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |