X AutoSave Off MGMT650 HW11 Summer22_Questions . Saved v Search (Alt+Q) Tiffany Dial TD X File Home Insert Page Layout Formulas Data Review View Help Comments Share 10 ~ A A" General Insert Arial = ab Conditional Formatting Ap O $ ~ % " Format as Table Delete GI Paste Sort & Find & Analyze Sensitivity $58 308 Cell Styles * Format Filter * Select v Dat Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity B70 : XV fx A B D E F G H J K L M N 0 P Q R S 17) On this worksheet, make an XY scatter plot linked to the following data: X 1.01 2.8482 1.48 4.2772 1.8 4.788 1.81 5.3757 1.07 2.5252 1.53 3.0906 1.46 4.3362 1.38 3.2016 1.77 4.3542 1.88 4.8692 1.32 3.8676 1.75 3.9375 1.94 5.7424 1.19 2.4752 1.31 26.2 1.56 4.5708 1.16 2.842 1.22 2.44 1.72 5.1256 1.45 4.3355 1.43 4.2471 1.19 3.5343 5.46 3.84 1.58 3.8552 HW11 Chi Square ANOVA Regression Cleaning Data with Outlier + Ready X Accessibility: Investigate + 88% 77' F (DELL 9:48 PM Clear 7/31/2022 3X AutoSave Off MGMT650 HW11 Summer22_Questions . Saved v Search (Alt+Q) Tiffany Dial TD X File Home Insert Page Layout Formulas Data Review View Help Comments Share 10 ~ A" A" General Arial Insert = ab Conditional Formatting Ap O $ ~ % " Format as Table Delete GI Paste Sort & Find & Analyze Sensitivity $58 308 Cell Styles * Format Filter * Select v Dat Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity B70 XV fx A B C D E F G H J K L M N 0 P Q R S 28 1.6 3.84 29 1.58 3.8552 30 31 18) Add trendline, regression equation and r squared to the plot. 32 Add this title. ("Scatterplot of X and Y Data") 33 34 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. 35 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. 36 37 It was determined that the outlying point resulted from data entry error. Remove the outlier in the copy of the data. 38 39 Make a new scatterplot linked to the cleaned data without the outlier, and add title ("Scatterplot without Outlier,") trendline, and regression equation label. 40 41 42 X Y 43 1.01 2.8482 44 1.48 4.2772 45 1.8 4.788 46 1.81 5.3757 1.07 2.5252 1.53 3.0906 1.46 4.3362 1.38 3.2016 1.77 4.3542 1.88 4.8692 1.32 3.8676 1.75 3.9375 1.94 5.7424 1.19 2.4752 HW11 Chi Square ANOVA Regression Cleaning Data with Outlier + Ready 7% Accessibility: Investigate + 88% 77' F (DELL 9:49 PM 3 Clear 7/31/2022X AutoSave Off MGMT650 HW11 Summer22_Questions . Saved v Search (Alt+Q) Tiffany Dial TD X File Home Insert Page Layout Formulas Data Review View Help Comments Share General Arial 10 ~ A" A" Conditional Formatting Insert = ab Ap O $ ~ % " Format as Table Delete GI Paste Sort & Find & Analyze Sensitivity $58 308 Cell Styles * Format Filter * Select v Dat Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity B70 X V fx A B C D E F G H J K L M N 0 P Q R S 49 1.46 4.3362 50 1.38 3.2016 51 1.77 4.3542 1.88 4.8692 1.32 3.8676 1.75 3.9375 1.94 5.7424 1.19 2.4752 1.56 4.5708 1.16 2.842 1.22 2.44 1.72 5.1256 1.45 4.3355 1.43 4.2471 1.19 3.5343 2 5.46 1.6 3.84 1.58 3.8552 Compare the regression equations of the two plots. How did removal of the outlier affect the slope and R'? Explain why the slope and R Square change the way they did 70 20) 71 72 73 74 75 76 77 HW11 Chi Square ANOVA Regression Cleaning Data with Outlier + Ready X Accessibility: Investigate + 88% 77' F (DELL 9:50 PM 3 Clear 7/31/2022