Question

17) On this worksheet, make an XY scatter plot linked to the following 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 the plot.

Add this title. ("Scatterplot of X and Y Data")

19)

The scatterplot reveals a point outside the point pattern. Copy the data to a new location in the worksheet. You now have 2 sets of data.
Data that are more tha 1.5 IQR below Q1 or more than 1.5 IQR above Q3 are considered outliers and must be investigated.
It was determined that the outlying point resulted from data entry error. Remove the outlier in the copy of the data.
Make a new scatterplot linked to the cleaned data without the outlier, and add title ("Scatterplot without Outlier,") trendline, and regression equation label.

Answer 1

Scatter plot without removing outlier