- H Se A1 2 4 3 7 S 10 11 12 11 14 11 16 17 18 19 20 34 Lapboard 37 Year Month Average Indies 2027 25 1886 46 1811 91 8 1 (25.88 KiB) Viewed 56 times
- H Se A1 2 4 3 7 S 10 11 12 11 14 11 16 17 18 19 20 34 Lapboard 37 Year Month Average Indies 2027 25 1886 46 1811 91 8 2 (34.41 KiB) Viewed 56 times
Questions Problem 2-31 Algo (Outliers and Missing Values) 2. 3. 4. 6. 7. 8. 9. 10. 13. 14 15. 0 O • • O O O 0 ● Outliers Count Hide Feedback Spreadsheet There is no consistent way of defining an outlier that everyone agrees upon. For example, some people refer to an outlier that is any observation more than three standard deviations from the mean (Type 1.) Other people use the box plot definition, where an outlier (moderate or extreme) is any observation more than 1.5 1QR from the edges of the box (Type 2 moderate), and some people care only about the extreme box plot-type outliers, those that are 3.0 1QR from the edges of the bow (Type 2 extreme) The life P02 31.xlsx contains average monthly values of the S&P 500 index over 39 months. Calculate the monthly index percentage change, and identify outiers-months when the percentage change was unusually large in either a negative or positive direction-according to each of the three definitions given above. How many outliere does each definition produce? Type 1 Partially Correct ellook Own Kry Type 2 moderate Type 2 extreme Check My Work Feedback Click here for a video walkthrough of a similar problem. Assignment Scare: 74.60% Save Submit Assignment for Grading Quenti 4 of 15 Check My Work Check My Mak O