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,...

50.1K

Verified Solution

Question

Statistics

17) On this worksheet, make an XY scatter plot linked to thefollowing data:

XY
9222
8723
10223
8025
9127
10020
9521
10919
7728
100221
9825
8927
9723
9322
8927
9122
9721
10521
8822
8324
8627
8926
7930
8822
9424

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.

Answer & Explanation Solved by verified expert
4.4 Ratings (1070 Votes)
Scatter    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students