Given the following data, 1) how do you make Excel create a scatter diagram for you? 2) If you were to draw a line through the points, how straight would the line be? 3) What is the coefficient of determination - r2 for this data, and more importantly, 4) what does it mean?
# Employees # Orders received
Enter the data in excel. select all the data and hit chart icon.
<br>Select chart type to be scatter ...
The expert examines an Excel scatter plot diagram.