A B с Year Month 1 Jan 1 Feb 1 Mar 1 Apr 1 May 1 Jun 1 Jul 1 Aug 1 Sep 1 Oct 1 Nov 1 Dec 2 Jan 2 Feb 2 Mar 2 Apr 2 May 2 Jun 2 Jul 2 Aug 2 Sep 2 Oct 2 Nov 2 Dec 3 Jan 3 Feb 3 Mar 3 Apr 3 May 3 Jun 3 Jul 3 Aug 3 Sep 3 Oct 3 Nov 3 Dec 4 Jan 4 Feb 4 Mar Average Index 2024.78 1875.25 1814.63 1785.82 1769.24 1752.18 1762.73 1758.52 1766.22 1747.33 1761.29 1748.80 1753.73 1756.78 1745.18 1753.05 1754.28 1749.72 1754.46 1745.38 1738.91 1735.01 1741.37 1737.51 1724.75 1716.26 1699.50 1701.39 1678.50 1670.06 1646.76 1640.45 1619.86 1586.57 1571.03 1523.45 1483.34 1433.92 1348.13
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 IQR 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 IQR from the edges of the box (Type 2 extreme.) The file PO2_31.xlsx contains average monthly values of the S&P 500 index over 39 months. Calculate the monthly index percentage change, and identify outliers - 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 outliers does each definition produce? Outliers Type 1 Type 2 moderate Type 2 extreme Count
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!