![]() ![]() At this point, under the TRENDLINE tab, we can check Display Equation on the chart and Display R-squared value on the chart to add equation and R-squared value to the scatter chart.Īt this point, it can be seen visually that the data points on the scatter chart are densely distributed, and the two variables are positively correlated, i.e., the higher the height, the greater the corresponding weight will be. Click this small triangle, and choose More Options. There is a small triangle on the right side of The Trendline. In the Chart Element area, we can also check Trendline to add a trend line to the scatter chart. We change the X-axis title to Weight, while changing the Y-axis title to Height. So, in the Bounds area, we input 140 in the Minimum box, and input 200 in the Maximum box.Īfter finishing settings, we click the Chart Element shortcut button and check Axis Title. ![]() ![]() The data points in the chart are all in the range of 140-200. Double-click the X-axis, and in the AXIS OPTIONS area, click AXIS. In order to analyze the data more clearly, we need to set up the chart.Īt this point, we can see that the data of the scatter chart is densely distributed on the right side of the chart. There are several types of scatter charts in the drop-down menu. Click the Insert tab, and click the Insert (X Y) Scatter Chart drop-down button. Here we first select A1:B1, press the Ctrl+Shift+down arrow to select all the data in column A and column B. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do that?īefore drawing a scatter chart, we need to know exactly what the X-axis is and what the Y-axis is, rather than blindly selecting the table data. This is a set of height and weight data of boys and girls. The scatter plot is a great graphical tool that we often use for statistical modelling. It presents all the data as points on rectangular coordinates, showing the relationships between variables. A scatter chart in WPS Spreadsheet is normally called an X-Y graph. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |