Date Open High Low Close Volume 23-Oct-15 727.5 730 701.5 702 6653923 22-Oct-15 646.7 657.8 644.01 651.79 4070954 21-Oct-15 654.15 655.87 641.73 642.61 1794172 20-Oct-15 664.04 664.72 644.2 650.28 2498215 19-Oct-15 661.18 666.82 659.58 666.1 1477340 16-Oct-15 664.11 664.97 657.2 662.2 1611128 15-Oct-15 654.66 663.13 654.46 661.74 1885737 14-Oct-15 653.21 659.39 648.85 651.16 1415468 13-Oct-15 643.15 657.81 643.15 652.3 1807685 12-Oct-15 642.09 648.5 639.01 646.67 1276134 2-Oct-15 607.2 627.34 603.13 626.91 2684805 1-Oct-15 608.37 612.09 599.85 611.29 1867601 30-Sep-15 603.28 608.76 600.73 608.42 2413441 29-Sep-15 597.28 605 590.22 594.97 2310284 28-Sep-15 610.34 614.6 589.38 594.89 3127667 25-Sep-15 629.77 629.77 611 611.97 2174009 24-Sep-15 616.64 627.32 612.4 625.8 2240098 23-Sep-15 622.05 628.93 620 622.36 1470949 22-Sep-15 627 627.55 615.43 622.69 2562869 21-Sep-15 634.4 636.49 625.94 635.44 1788506 18-Sep-15 636.79 640 627.02 629.25 5133386 17-Sep-15 637.79 650.9 635.02 642.9 2274690 16-Sep-15 635.47 637.95 632.32 635.98 1286454 15-Sep-15 626.7 638.7 623.78 635.14 2084397 14-Sep-15 625.7 625.86 619.43 623.24 1702271 11-Sep-15 619.75 625.78 617.42 625.77 1373545 10-Sep-15 613.1 624.16 611.43 621.35 1900526 9-Sep-15 621.22 626.52 609.6 612.72 1702094 8-Sep-15 612.49 616.31 604.12 614.66 2279538 4-Sep-15 600 603.47 595.25 600.7 2089453 3-Sep-15 617 619.71 602.82 606.25 1759572 2-Sep-15 605.59 614.34 599.71 614.34 2575620 1-Sep-15 602.36 612.86 594.1 597.79 3702105 31-Aug-15 627.54 635.8 617.68 618.25 2176737 28-Aug-15 632.82 636.88 624.56 630.38 1978733 27-Aug-15 639.4 643.59 622 637.61 3491336 26-Aug-15 610.35 631.71 599.05 628.62 4235891 25-Aug-15 614.91 617.45 581.11 582.06 3537966 24-Aug-15 573 614 565.05 589.61 5770302 21-Aug-15 639.78 640.05 612.33 612.48 4265183 20-Aug-15 655.46 662.99 642.9 646.83 2855299 19-Aug-15 656.6 667 654.19 660.9 2134098 18-Aug-15 661.9 664 653.46 656.13 1456059 17-Aug-15 656.8 661.38 651.24 660.87 1051699 14-Aug-15 655.01 659.86 652.66 657.12 1072061 13-Aug-15 659.32 664.5 651.66 656.45 1810749 12-Aug-15 663.08 665 652.29 659.56 2940803 11-Aug-15 669.2 674.9 654.27 660.78 5029203 10-Aug-15 639.48 643.44 631.25 633.73 1809205 7-Aug-15 640.23 642.68 629.71 635.3 1403865 6-Aug-15 645 645.38 632.25 642.68 1572600 5-Aug-15 634.33 647.86 633.16 643.78 2334266 4-Aug-15 628.42 634.81 627.16 629.25 1490881 3-Aug-15 625.34 633.06 625.34 631.21 1304511 31-Jul-15 631.38 632.91 625.5 625.61 1706149 30-Jul-15 630 635.22 622.05 632.59 1474203 29-Jul-15 628.8 633.36 622.65 631.93 1575069 28-Jul-15 632.83 632.83 623.31 628 1727327 27-Jul-15 621 634.3 620.5 627.26 2675381 24-Jul-15 647 648.17 622.52 623.56 3625747 23-Jul-15 661.27 663.63 641 644.28 3029109 22-Jul-15 660.89 678.64 659 662.1 3929309 21-Jul-15 655.21 673 654.3 662.3 3377196 20-Jul-15 659.24 668.88 653.01 663.02 5860872 17-Jul-15 649 674.47 645 672.93 11164943 16-Jul-15 565.12 580.68 565 579.85 4768318 15-Jul-15 560.13 566.5 556.79 560.22 1784554 14-Jul-15 546.76 565.85 546.71 561.1 3244066 13-Jul-15 532.88 547.11 532.4 546.55 2206475 10-Jul-15 526.29 532.56 525.55 530.13 1956682 9-Jul-15 523.12 523.77 520.35 520.68 1842347 8-Jul-15 521.05 522.73 516.11 516.83 1296699 7-Jul-15 523.13 526.18 515.18 525.02 1597229 6-Jul-15 519.5 525.25 519 522.86 1280525 2-Jul-15 521.08 524.65 521.08 523.4 1235903 1-Jul-15 524.73 525.69 518.23 521.84 1961354 30-Jun-15 526.02 526.25 520.5 520.51 2235595 29-Jun-15 525.01 528.61 520.54 521.52 1937821 26-Jun-15 537.26 537.76 531.35 531.69 2109130 25-Jun-15 538.87 540.9 535.23 535.23 1335697 24-Jun-15 23-Jun-15 22-Jun-15 19-Jun-15 18-Jun-15 17-Jun-15 16-Jun-15 15-Jun-15 12-Jun-15 11-Jun-15 10-Jun-15 9-Jun-15 8-Jun-15 5-Jun-15 4-Jun-15 3-Jun-15 2-Jun-15 1-Jun-15 29-May-15 28-May-15 27-May-15 26-May-15 22-May-15 21-May-15 20-May-15 19-May-15 18-May-15 15-May-15 14-May-15 13-May-15 12-May-15 11-May-15 8-May-15 7-May-15 6-May-15 5-May-15 4-May-15 1-May-15 30-Apr-15 29-Apr-15 28-Apr-15 27-Apr-15 24-Apr-15 23-Apr-15 22-Apr-15 21-Apr-15 20-Apr-15 17-Apr-15 16-Apr-15 15-Apr-15 14-Apr-15 13-Apr-15 10-Apr-15 9-Apr-15 8-Apr-15 7-Apr-15 6-Apr-15 2-Apr-15 1-Apr-15 31-Mar-15 30-Mar-15 27-Mar-15 26-Mar-15 25-Mar-15 24-Mar-15 23-Mar-15 20-Mar-15 19-Mar-15 18-Mar-15 17-Mar-15 16-Mar-15 13-Mar-15 12-Mar-15 11-Mar-15 10-Mar-15 9-Mar-15 6-Mar-15 5-Mar-15 4-Mar-15 3-Mar-15 2-Mar-15 540 539.64 539.59 537.21 531 529.37 528.4 528 531.6 538.42 529.36 527.56 533.31 536.35 537.76 539.91 532.93 536.79 537.37 538.01 532.8 538.12 540.15 537.95 538.49 533.98 532.01 539.18 533.77 530.56 531.6 538.37 536.65 523.99 531.24 538.21 538.53 538.43 547.87 550.47 554.64 563.39 566.1 541 534.4 537.51 525.6 528.66 529.9 528.7 536.25 538.41 542.29 541.03 538.38 538.08 532.22 540.85 548.6 550 551.62 553 557.59 570.5 562.56 560.43 561.65 559.39 552.5 551.71 550.95 553.5 553.51 555.14 564.25 566.86 574.88 575.02 571.87 570.45 560.53 540 541.5 543.74 538.25 538.15 530.98 529.64 528.3 533.12 538.98 538.36 529.2 534.12 537.2 540.59 543.5 543 536.79 538.63 540.61 540.55 539 544.19 543.84 542.92 540.66 534.82 539.27 539 534.32 533.21 541.98 541.15 533.46 532.38 539.74 544.07 539.54 548.59 553.68 556.02 565.95 571.14 550.96 541.08 539.39 536.09 529.84 535.59 534.73 537.57 544.06 542.29 541.95 543.85 542.69 538.41 540.85 551.14 554.71 553.47 555.28 558.9 572.26 574.59 562.36 561.72 560.8 559.78 553.8 556.85 558.4 556.37 558.14 564.85 570.27 576.68 577.91 577.11 575.39 572.15 535.66 535.25 537.53 533.01 530.79 525.1 525.56 524 530.16 533.02 529.35 523.01 526.24 532.52 534.32 537.11 531.33 529.76 531.45 536.25 531.71 529.88 539.51 535.98 532.97 533.04 528.85 530.38 532.41 528.66 525.26 535.4 536 521.75 521.08 530.39 535.06 532.1 535.05 546.9 550.37 553.2 557.25 540.23 531.75 533.68 524.5 521.01 529.61 523.22 528.09 537.31 537.31 535.49 538.38 536 529.57 533.85 539.5 546.72 548.17 548.13 550.65 558.74 561.21 555.83 559.05 556.14 547 548 546 544.22 550.46 550.68 554.73 563.54 566.76 573.41 568.01 566.52 558.75 537.84 540.48 538.19 536.69 536.73 529.26 528.15 527.2 532.33 534.61 536.69 526.69 526.83 533.33 536.7 540.31 539.18 533.99 532.11 539.78 539.79 532.32 540.11 542.51 539.27 537.36 532.3 533.85 538.4 529.62 529.04 535.7 538.22 530.7 524.22 530.8 540.78 537.9 537.34 549.08 553.68 555.37 565.06 547 539.36 533.97 535.38 524.05 533.8 532.53 530.39 539.17 540.01 540.78 541.61 537.02 536.76 535.53 542.56 548 552.03 548.34 555.17 558.78 570.19 558.81 560.36 557.99 559.5 550.84 554.51 547.32 555.51 551.18 555.01 568.85 567.68 575.33 573.37 573.64 571.34 1286608 1197450 1250282 1893497 1833109 1294216 1071814 1632702 955789 1217536 1814958 1455266 1524139 1388220 1348337 1717036 1938989 1904332 2597407 1029849 1525019 2406512 1176214 1462695 1430826 1966947 2003421 1971343 1403935 1253063 1634174 905285 1527615 1546278 1566987 1383068 1307960 1768181 2082214 1698761 1490983 2398039 4919031 4173376 1589248 1839668 1675487 2145955 1296304 2312512 2597043 1640809 1405574 1553586 1175332 1299298 1320767 1711737 1957718 1583677 1283958 1892323 1568331 2146384 2576234 1639306 2609690 1194049 2128714 1800570 1636493 1698872 1385772 1815763 1787357 1059336 1654561 1385818 1871694 1700084 2123796 27-Feb-15 26-Feb-15 25-Feb-15 24-Feb-15 23-Feb-15 20-Feb-15 19-Feb-15 18-Feb-15 17-Feb-15 13-Feb-15 12-Feb-15 11-Feb-15 10-Feb-15 9-Feb-15 6-Feb-15 5-Feb-15 4-Feb-15 3-Feb-15 2-Feb-15 30-Jan-15 29-Jan-15 28-Jan-15 27-Jan-15 26-Jan-15 23-Jan-15 22-Jan-15 21-Jan-15 20-Jan-15 16-Jan-15 15-Jan-15 14-Jan-15 13-Jan-15 12-Jan-15 9-Jan-15 8-Jan-15 7-Jan-15 6-Jan-15 5-Jan-15 2-Jan-15 31-Dec-14 30-Dec-14 29-Dec-14 26-Dec-14 24-Dec-14 23-Dec-14 22-Dec-14 19-Dec-14 18-Dec-14 17-Dec-14 16-Dec-14 15-Dec-14 12-Dec-14 11-Dec-14 10-Dec-14 9-Dec-14 8-Dec-14 5-Dec-14 4-Dec-14 3-Dec-14 2-Dec-14 1-Dec-14 28-Nov-14 26-Nov-14 25-Nov-14 24-Nov-14 21-Nov-14 20-Nov-14 19-Nov-14 18-Nov-14 17-Nov-14 14-Nov-14 13-Nov-14 12-Nov-14 11-Nov-14 10-Nov-14 7-Nov-14 6-Nov-14 5-Nov-14 4-Nov-14 3-Nov-14 31-Oct-14 554.24 543.21 535.9 530 536.05 543.13 538.04 541.4 546.83 543.35 537.25 535.3 529.3 528 527.64 523.79 529.24 528 531.73 515.86 511 522.78 529.97 538.53 535.59 521.48 507.25 511 500.01 505.57 494.65 498.84 494.94 504.76 497.99 507 515 523.26 529.01 531.25 528.09 532.19 528.77 530.51 527 516.08 511.51 512.95 497 511.56 522.74 523.51 527.8 533.08 522.14 527.13 531 531.16 531.44 533.51 538.9 540.62 540.88 539 537.65 541.61 531.25 535 537.5 543.58 546.68 549.8 550.39 548.49 541.46 546.21 545.5 556.8 553 555.5 559.35 564.71 556.14 546.22 536.79 536.44 543.75 543.11 545.49 550 549.91 544.82 538.45 537.7 532 537.2 528.5 532.67 533.4 533 539.87 511.09 522.99 530.7 539 542.17 536.33 519.28 512.5 508.19 505.68 503.23 502.98 495.98 504.92 503.48 507.24 516.18 524.33 531.27 532.6 531.15 535.48 534.25 531.76 534.56 526.46 517.72 513.87 507 513.05 523.1 528.5 533.92 536.33 534.19 531 532.89 537.34 536 535.5 541.41 542 541.55 543.98 542.7 542.14 535.11 538.24 541.94 543.79 546.68 549.8 550.46 551.94 549.59 546.21 546.88 556.8 555.5 557.9 559.57 552.9 541.5 535.44 528.25 529.41 535.8 538.01 537.51 541.09 543.13 534.67 533.38 526.92 526.02 526.41 522.09 521.27 523.26 518.55 515.52 501.2 510 518.19 529.67 533 519.7 506.2 506.02 500 497.76 493 492.39 487.56 494.79 491 499.65 501.05 513.06 524.1 525.8 527.13 530.01 527.31 527.02 526.29 516.08 506.91 504.7 496.81 489 513.27 518.66 527.1 525.56 520.5 523.79 524.28 528.59 529.26 529.8 531.86 536.6 537.04 538.6 535.62 536.56 531.08 530.08 534.17 534.06 542.15 543.48 545.17 546.3 541.02 538.67 540.97 544.05 549.3 553.23 554.75 558.4 555.48 543.87 536.09 531.91 538.95 542.87 539.7 542.84 549.01 542.93 535.97 536.94 527.83 531 527.58 522.76 529.24 528.48 534.52 510.66 510 518.63 535.21 539.95 534.39 518.04 506.9 508.08 501.79 500.87 496.18 492.55 496.17 502.68 501.1 501.96 513.87 524.81 526.4 530.42 530.33 534.03 528.77 530.59 524.87 516.35 511.1 504.89 495.39 513.8 518.66 528.34 526.06 533.37 526.98 525.26 537.31 531.32 533.75 533.8 541.83 540.37 541.08 539.27 537.5 534.83 536.99 535.03 536.51 544.4 545.38 547.31 550.29 547.49 541.01 542.04 545.92 554.11 555.22 559.08 2403553 2305219 1821041 1002393 1453907 1441212 987478 1449089 1612439 1895126 1615824 1373970 1745076 1264276 1758650 1844687 1659125 2033085 2841976 5590977 4174924 1679230 1898844 1539524 2275485 2669558 2262455 2225922 2292043 2711355 2229638 2365687 2320446 2065715 3344395 2059366 2891950 2054238 1446662 1371819 873923 2276104 1037727 704035 2191567 2723599 3680148 2918730 2875281 3953371 2812786 1989117 1610964 1716835 1871268 2327127 2558649 1392208 1279288 1522481 2109599 1145231 1519503 1784967 1701682 2218249 1559131 1388440 1957664 1721282 1285991 1335719 1126594 964866 1131546 1629259 1329604 2026740 1240761 1378511 2032887 30-Oct-14 29-Oct-14 28-Oct-14 27-Oct-14 548.95 550 543 537.03 552.8 554.19 548.98 544.41 543.51 546.98 541.62 537.03 550.31 549.33 548.9 540.77 1451667 1767107 1273372 1184973 Date Close 23-Oct-15 702 22-Oct-15 651.79 21-Oct-15 642.61 20-Oct-15 650.28 19-Oct-15 666.1 16-Oct-15 662.2 15-Oct-15 661.74 14-Oct-15 651.16 13-Oct-15 652.3 12-Oct-15 646.67 2-Oct-15 626.91 1-Oct-15 611.29 30-Sep-15 608.42 29-Sep-15 594.97 28-Sep-15 594.89 25-Sep-15 611.97 24-Sep-15 625.8 23-Sep-15 622.36 22-Sep-15 622.69 21-Sep-15 635.44 18-Sep-15 629.25 17-Sep-15 642.9 16-Sep-15 635.98 15-Sep-15 635.14 14-Sep-15 623.24 11-Sep-15 625.77 10-Sep-15 621.35 9-Sep-15 612.72 8-Sep-15 614.66 4-Sep-15 600.7 3-Sep-15 606.25 2-Sep-15 614.34 1-Sep-15 597.79 31-Aug-15 618.25 28-Aug-15 630.38 27-Aug-15 637.61 26-Aug-15 628.62 25-Aug-15 582.06 24-Aug-15 589.61 21-Aug-15 612.48 20-Aug-15 646.83 19-Aug-15 660.9 18-Aug-15 656.13 17-Aug-15 660.87 14-Aug-15 657.12 13-Aug-15 656.45 12-Aug-15 659.56 11-Aug-15 660.78 10-Aug-15 633.73 7-Aug-15 635.3 6-Aug-15 642.68 5-Aug-15 643.78 4-Aug-15 629.25 3-Aug-15 631.21 31-Jul-15 625.61 30-Jul-15 632.59 29-Jul-15 631.93 28-Jul-15 628 27-Jul-15 627.26 24-Jul-15 623.56 23-Jul-15 644.28 22-Jul-15 662.1 21-Jul-15 662.3 20-Jul-15 663.02 17-Jul-15 672.93 16-Jul-15 579.85 15-Jul-15 560.22 14-Jul-15 561.1 13-Jul-15 546.55 10-Jul-15 530.13 9-Jul-15 520.68 8-Jul-15 516.83 7-Jul-15 525.02 6-Jul-15 522.86 2-Jul-15 523.4 1-Jul-15 521.84 30-Jun-15 520.51 29-Jun-15 521.52 26-Jun-15 531.69 25-Jun-15 535.23 Mean Standard Deviation 562.3067 47.01921 24-Jun-15 23-Jun-15 22-Jun-15 19-Jun-15 18-Jun-15 17-Jun-15 16-Jun-15 15-Jun-15 12-Jun-15 11-Jun-15 10-Jun-15 9-Jun-15 8-Jun-15 5-Jun-15 4-Jun-15 3-Jun-15 2-Jun-15 1-Jun-15 29-May-15 28-May-15 27-May-15 26-May-15 22-May-15 21-May-15 20-May-15 19-May-15 18-May-15 15-May-15 14-May-15 13-May-15 12-May-15 11-May-15 8-May-15 7-May-15 6-May-15 5-May-15 4-May-15 1-May-15 30-Apr-15 29-Apr-15 28-Apr-15 27-Apr-15 24-Apr-15 23-Apr-15 22-Apr-15 21-Apr-15 20-Apr-15 17-Apr-15 16-Apr-15 15-Apr-15 14-Apr-15 13-Apr-15 10-Apr-15 9-Apr-15 8-Apr-15 7-Apr-15 6-Apr-15 2-Apr-15 1-Apr-15 31-Mar-15 30-Mar-15 27-Mar-15 26-Mar-15 25-Mar-15 24-Mar-15 23-Mar-15 20-Mar-15 19-Mar-15 18-Mar-15 17-Mar-15 16-Mar-15 13-Mar-15 12-Mar-15 11-Mar-15 10-Mar-15 9-Mar-15 6-Mar-15 5-Mar-15 4-Mar-15 3-Mar-15 2-Mar-15 537.84 540.48 538.19 536.69 536.73 529.26 528.15 527.2 532.33 534.61 536.69 526.69 526.83 533.33 536.7 540.31 539.18 533.99 532.11 539.78 539.79 532.32 540.11 542.51 539.27 537.36 532.3 533.85 538.4 529.62 529.04 535.7 538.22 530.7 524.22 530.8 540.78 537.9 537.34 549.08 553.68 555.37 565.06 547 539.36 533.97 535.38 524.05 533.8 532.53 530.39 539.17 540.01 540.78 541.61 537.02 536.76 535.53 542.56 548 552.03 548.34 555.17 558.78 570.19 558.81 560.36 557.99 559.5 550.84 554.51 547.32 555.51 551.18 555.01 568.85 567.68 575.33 573.37 573.64 571.34 27-Feb-15 26-Feb-15 25-Feb-15 24-Feb-15 23-Feb-15 20-Feb-15 19-Feb-15 18-Feb-15 17-Feb-15 13-Feb-15 12-Feb-15 11-Feb-15 10-Feb-15 9-Feb-15 6-Feb-15 5-Feb-15 4-Feb-15 3-Feb-15 2-Feb-15 30-Jan-15 29-Jan-15 28-Jan-15 27-Jan-15 26-Jan-15 23-Jan-15 22-Jan-15 21-Jan-15 20-Jan-15 16-Jan-15 15-Jan-15 14-Jan-15 13-Jan-15 12-Jan-15 9-Jan-15 8-Jan-15 7-Jan-15 6-Jan-15 5-Jan-15 2-Jan-15 31-Dec-14 30-Dec-14 29-Dec-14 26-Dec-14 24-Dec-14 23-Dec-14 22-Dec-14 19-Dec-14 18-Dec-14 17-Dec-14 16-Dec-14 15-Dec-14 12-Dec-14 11-Dec-14 10-Dec-14 9-Dec-14 8-Dec-14 5-Dec-14 4-Dec-14 3-Dec-14 2-Dec-14 1-Dec-14 28-Nov-14 26-Nov-14 25-Nov-14 24-Nov-14 21-Nov-14 20-Nov-14 19-Nov-14 18-Nov-14 17-Nov-14 14-Nov-14 13-Nov-14 12-Nov-14 11-Nov-14 10-Nov-14 7-Nov-14 6-Nov-14 5-Nov-14 4-Nov-14 3-Nov-14 31-Oct-14 558.4 555.48 543.87 536.09 531.91 538.95 542.87 539.7 542.84 549.01 542.93 535.97 536.94 527.83 531 527.58 522.76 529.24 528.48 534.52 510.66 510 518.63 535.21 539.95 534.39 518.04 506.9 508.08 501.79 500.87 496.18 492.55 496.17 502.68 501.1 501.96 513.87 524.81 526.4 530.42 530.33 534.03 528.77 530.59 524.87 516.35 511.1 504.89 495.39 513.8 518.66 528.34 526.06 533.37 526.98 525.26 537.31 531.32 533.75 533.8 541.83 540.37 541.08 539.27 537.5 534.83 536.99 535.03 536.51 544.4 545.38 547.31 550.29 547.49 541.01 542.04 545.92 554.11 555.22 559.08 30-Oct-14 29-Oct-14 28-Oct-14 27-Oct-14 550.31 549.33 548.9 540.77 MATH 201 PROJECT 3 INSTRUCTIONS Based on Larson & Farber: sections 5.2-5.3 Go to this website. First, set the date range to be for exactly 1 year ending with the Monday that this course started. For example, if the current term started on 04/01/2014, then use 04/01/2013 - 03/31/2014. Your dates will going back exactly 1 year. Next, click the link on the right that says Download to Spreadsheet and then save the file to your computer. This project will only use the Closing Values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation and then use those numbers and the methods you learned in sections 5.2 and 5.3 of our text book for Normal distributions to answer the questions. Complete this assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit. 1. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution. (5 points) 2. If a person bought one share of Google stock within the last year, what is the probability that the stock on that day closed at more than $600? (5 points) 3. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $45 of the mean for that year? (5 points) 4. Suppose a person within the last year claimed to have bought Google stock at closing at $450 per share. Would such a price be considered unusual? Be sure to use the definition of unusual from our textbook. (5 points) 5. At what prices would Google have to close at in order for it to be considered statistically unusual? You should have a low and high value. Be sure to use the definition of unusual from our textbook that is measured as a number of standard deviations. (5 points) 6. What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you should answer without using anything about the Normal distribution. (5 points) 7. Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in our textbook? It does not need to be perfect. Real data sets are never perfect. However, it should be close. One option would be to construct a histogram like we did in Project 1 and see if it has the right shape. If you go this route, something in the range of 10 to 12 classes would be a good number. (5 points) There are also 5 points for miscellaneous items like correct date range, correct mean, correct SD, etc. Submit your work through the assignment link by 11:59 p.m. (ET) on Monday of Module/Week 5. Note that you must do this project on your ownyou may not work with other students. You are always welcome to ask your instructor for help