3 4 5 6 7 0 9 10 n R 11 M 18 17 18 11 20 26 A1 40 Undo 41 Year 1 Jan 1 feb 1 Mar B C Month Average Index 2027.25 1885.46
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
3 4 5 6 7 0 9 10 n R 11 M 18 17 18 11 20 26 A1 40 Undo 41 Year 1 Jan 1 feb 1 Mar B C Month Average Index 2027.25 1885.46
Questions Problem 2-31 Algo (Outliers and Missing Values) 2. 4. S 7. 8. 9. 10 11. 12. 13 14 153 O 0 O O O 0 O Outliers Count 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 1Q 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 10R from the edges of the box (Type 2 extreme.) The fe P02 31.xlsx contains average monthly values of the S&P 500 index over 39 months. Calculate the monthly index percentage change, and identify outlers maths 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 outlers does each definition produce? Type 1 Hide Feedback Partially Correct Ove on y Check My Work Feedback Click here for a video walkthrough of a similar problem. Type 2 moderate Type 2 extreme O ellook B O O Save 734 Suley Submit Assignment for Grading Question of 15 Oleck My Work