# Excel scatter plot diagram

Not what you're looking for? Search our solutions OR ask your own Custom question.

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

1 12

2 10

4 9

3 11

5 12

4 15

https://brainmass.com/statistics/scatter-plot/excel-scatter-plot-diagram-10284

#### Solution Preview

Enter the data in excel. select all the data and hit chart icon.

<br>Select chart type to be scatter ...

#### Solution Summary

The expert examines an Excel scatter plot diagram.

$2.49