please, explain what are the steps to this problem. Thank you.

Excel File Edit View Insert Format Tools Data Window Help Sat 9:31 PM Q OE . . AutoSave OFF 3 HW11 MGMT650_Spring2019_Questions-3 Q ~ Search Sheet * Ho X G 25) Ad > + Home Insert Draw Page Layout Formulas Data Review View Share Comments V O G E DOCX Arial 10 A" A General C Conditional Formatting v Insert LGv d Research IU Y L Av F Format as Table v x Delete v . 27 M...a Pierre U Paste B E $ % 9 568 -98 Cell Styles v Format X v Sort & Filter F23 fx B C D E H M N DOCX 24) On this worksheet, make an XY scatter plot linked to the following data: idelines 22 3872 9312 5217 4230 4536 10 1820 8274 een Shot 121 6314 10...5.28 PM 16 3828 2448 6156 7515 1309 3534 4576 5797 een Shot 4983 10...5.41 PM 6670 &Na 2464 2197 3278 5408 49 7497 35 5705 een Shot? 26) Add trendline, regression equation and r squared to the plot. 10...5.57 PM Add this title. ("Scatterplot of X and Y Data") 34 27) 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. 36 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. Answer 37 25) 38 It was determined that the outlying point resulted from data entry error. Remove the outlier in the copy of the data. 39 29) een Shot 40 Make a new scatterplot linked to the cleaned data without the outlier, and add title ("Scatterplot without Outlier, ") trendline, and regression equation label. 10...7.34 PM 43 44 30) 45 Compare the regression equations of the two plots. How did removal of the outlier affect the slope and R?? 46 47 48 een Shot 19 10...7.46 PM HW11 ANOVA Pivot Table Pivot Table Data Regression Cleaning Data with Outlier Select destination and press ENTER or choose Paste - + 96% 13 X WOP 6 DOLCE