17) On this worksheet, make an XY scatter plot linked to thefollowing data:
X | Y |
92 | 22 |
87 | 23 |
102 | 23 |
80 | 25 |
91 | 27 |
100 | 20 |
95 | 21 |
109 | 19 |
77 | 28 |
100 | 221 |
98 | 25 |
89 | 27 |
97 | 23 |
93 | 22 |
89 | 27 |
91 | 22 |
97 | 21 |
105 | 21 |
88 | 22 |
83 | 24 |
86 | 27 |
89 | 26 |
79 | 30 |
88 | 22 |
94 | 24 |
18) Add trendline, regression equation and r squared to theplot.
Add this title. (\"Scatterplot of X and Y Data\")
19)
The scatterplot reveals a point outside the point pattern. Copy thedata to a new location in the worksheet. You now have 2 sets ofdata. | | |
Datathat are more tha 1.5 IQR below Q1 or more than 1.5 IQR above Q3are considered outliers and must be investigated. | | |
| | | | | | | | | | |
It wasdetermined that the outlying point resulted from data entry error.Remove the outlier in the copy of the data. | | |
| | | | | | | | | | |
Make anew scatterplot linked to the cleaned data without the outlier, andadd title (\"Scatterplot without Outlier,\") trendline, andregression equation label. | |
| | | | | | | | | | |