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
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.
20) Compare the regression equations of the two plots. How did removal of the outlier affect the slope and R2?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started