# Statistics Question

PROJECT 3 INSTRUCTIONS: Probability & Stastics

Based on Larson & Farber: sections 6.1–6.3

Go to this website. Click the link on the right that says, “Download to Spreadsheet.” Set the date range to end on the first day (Tuesday) of Module/Week 5 and going back exactly 1 year. Assume that the closing prices of the stock form a normally distributed data set. Do not manually count values in the data set, but use the ideas found in sections 5.2–5.3. Answer the following:

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?

2. 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 more than \$500?

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?

4. Suppose a person within the last year claimed to have bought Google stock at closing at \$400 per share. Would such a price be considered unusual? Explain.

5. At what price would Google have to close at in order for it to be considered statistically unusual? You should have a low and high value.

6. What are Q1, Q2, and Q3 in this data set?

7. Is the assumption that was made at the beginning valid? Why or why not?

9-Apr-13

8-Apr-13

5-Apr-13

2-Apr-13

1-Apr-13

809.64

807.79

826.99

8-Mar-13

7-Mar-13

6-Mar-13

5-Mar-13

4-Mar-13

805.00

1-Mar-13

805.30

807.00

785.35

8-Feb-13 780.13

7-Feb-13

6-Feb-13

5-Feb-13

4-Feb-13

1-Feb-13

750.25

753.83

9-Jan-13

8-Jan-13

736.30

7-Jan-13

4-Jan-13

3-Jan-13 724.93

2-Jan-13

723.25

700.01

7-Dec-12

696.88

6-Dec-12

4-Dec-12 695.00

3-Dec-12

669.97

669.80

9-Nov-12

8-Nov-12

7-Nov-12 675.00

6-Nov-12

5-Nov-12

2-Nov-12

1-Nov-12

687.59

675.00

682.00

672.00

695.00

758.50

9-Oct-12

8-Oct-12

5-Oct-12

4-Oct-12

3-Oct-12

2-Oct-12

1-Oct-12

765.00

754.15

712.88

7-Sep-12 700.00

6-Sep-12

5-Sep-12 680.00 686.50

4-Sep-12

672.00

678.00

669.51

677.25

9-Aug-12

8-Aug-12

7-Aug-12

6-Aug-12

3-Aug-12

2-Aug-12

1-Aug-12

615.00

9-Jul-12

6-Jul-12

5-Jul-12

3-Jul-12

2-Jul-12

571.48

579.84

8-Jun-12

7-Jun-12

6-Jun-12

5-Jun-12

4-Jun-12

1-Jun-12

615.00

9-May-12

8-May-12

7-May-12

595.00

4-May-12

3-May-12

2-May-12

1-May-12

600.61

604.00

 Date Open High Low Close Volume 1 9-Apr-13 769.16 803.44 766.26 799.87 5804316 1 8-Apr-13 785.35 785.80 761.26 765.91 3328777 17-Apr-13 786.75 790.84 778.10 782.56 2037355 16-Apr-13 786.59 796.00 783.92 793.37 1742374 1 5-Apr-13 785.95 797.00 777.02 781.93 2454767 1 2-Apr-13 791.99 792.10 782.93 790.05 1636829 1 1-Apr-13 792.88 793.10 784.06 790.39 2028766 10-Apr-13 782.92 792.35 776.00 790.18 1978862 775.50 783.75 773.11 777.65 2157928 778.75 779.55 768.40 774.85 2832718 786.06 786.99 776.40 783.05 3433994 4-Apr-13 804.25 805.75 791.30 795.07 2448102 3-Apr-13 813.46 814.20 800.67 806.20 1738753 804.54 814.83 804.00 813.04 2041713 795.01 802.25 793.25 801.19 1807580 2 8-Mar-13 803.99 805.37 793.30 794.19 2287712 2 7-Mar-13 806.68 807.00 801.33 802.66 2163295 2 6-Mar-13 813.50 814.00 807.79 812.42 1191912 2 5-Mar-13 812.41 819.23 806.82 809.64 1712684 22-Mar-13 814.74 815.24 810.31 1491678 2 1-Mar-13 811.29 816.92 809.85 811.26 1477590 20-Mar-13 816.83 817.51 811.44 814.71 1464122 19-Mar-13 811.24 819.25 806.45 811.32 2098176 18-Mar-13 805.00 812.76 801.47 1838552 15-Mar-13 818.50 820.30 813.34 814.30 3099791 1 4-Mar-13 826.99 817.39 821.54 1651111 13-Mar-13 827.90 830.69 822.31 825.31 1641413 12-Mar-13 830.71 831.89 823.67 827.61 2008979 11-Mar-13 831.69 839.70 831.50 834.82 1595678 834.50 834.92 825.05 831.52 2912283 834.06 836.62 829.58 832.60 2054238 841.02 844.00 828.81 831.38 2873998 828.93 840.15 828.90 838.60 4045034 805.30 822.84 821.50 2776185 797.80 807.14 796.15 806.19 2175425 2 8-Feb-13 801.10 806.99 801.03 801.20 2265874 2 7-Feb-13 794.80 804.75 791.11 799.78 2028515 2 6-Feb-13 795.00 795.95 784.40 790.13 2205059 2 5-Feb-13 802.30 808.41 790.49 790.77 2307008 22-Feb-13 799.26 801.25 793.80 799.71 2054050 2 1-Feb-13 798.00 805.45 791.22 795.53 3511036 20-Feb-13 808.97 791.79 792.46 2765029 19-Feb-13 795.99 795.28 806.85 2932924 15-Feb-13 787.40 793.26 787.07 792.89 2729917 1 4-Feb-13 779.73 788.74 777.77 787.82 1735219 13-Feb-13 780.13 779.97 782.86 1198170 12-Feb-13 781.75 787.90 779.37 780.70 1858945 11-Feb-13 778.40 783.00 773.75 782.42 2167656 786.67 779.56 785.37 3024853 769.70 778.81 765.50 773.95 2840506 759.07 772.96 758.50 770.17 2079687 761.13 771.11 759.46 765.74 1870716 767.69 770.47 758.27 759.02 3041242 758.20 776.60 758.10 775.60 3746165 31-Jan-13 750.51 757.62 750.25 755.69 1634556 30-Jan-13 753.74 760.95 752.91 753.83 1732972 2 9-Jan-13 746.75 756.95 746.54 753.68 1747734 2 8-Jan-13 751.76 755.60 747.89 750.73 1627833 25-Jan-13 750.77 758.48 753.67 2225811 2 4-Jan-13 741.24 756.83 740.51 3383596 2 3-Jan-13 735.99 749.00 735.79 741.50 5911865 2 2-Jan-13 704.66 705.34 695.52 702.87 3792336 18-Jan-13 710.36 712.77 701.33 704.51 3226898 1 7-Jan-13 717.71 719.64 711.02 711.32 2212357 16-Jan-13 722.40 724.34 713.67 715.19 2024991 15-Jan-13 719.33 735.00 712.10 724.93 3927990 14-Jan-13 737.00 742.20 722.35 723.25 2864106 11-Jan-13 742.00 742.43 736.30 739.99 1285125 10-Jan-13 742.83 745.00 733.50 741.48 1835780 732.27 738.35 728.60 738.12 2025751 735.54 724.43 733.30 1676740 735.45 739.38 730.58 734.75 1655967 729.34 741.47 727.68 737.97 2763552 731.93 720.72 723.67 2318140 719.42 727.00 716.55 2542268 31-Dec-12 700.00 710.57 696.00 707.38 1997733 28-Dec-12 701.69 706.91 700.01 1403926 2 7-Dec-12 707.14 708.84 698.61 706.29 1647392 2 6-Dec-12 708.07 712.88 702.41 708.87 1182572 2 4-Dec-12 714.51 715.18 707.47 709.50 841931 21-Dec-12 713.97 718.82 710.52 715.63 3527849 20-Dec-12 723.26 724.65 716.97 722.36 1657153 19-Dec-12 720.71 723.00 716.68 720.11 1919799 18-Dec-12 716.60 729.10 715.05 721.07 3005138 17-Dec-12 705.50 738.28 704.02 720.78 3036763 14-Dec-12 699.17 707.82 698.43 701.96 2130595 1 3-Dec-12 715.92 716.48 699.55 702.70 3446306 12-Dec-12 699.23 703.51 693.48 697.56 2426299 11-Dec-12 690.00 701.92 687.72 696.88 2687956 10-Dec-12 685.39 691.65 683.79 685.42 1366866 695.00 682.42 684.21 1919476 687.59 695.61 684.51 691.13 1462216 5-Dec-12 692.15 694.50 682.33 687.82 1862735 695.51 685.70 691.03 1991605 702.24 705.89 694.11 695.25 2193948 30-Nov-12 691.31 699.22 685.69 698.37 3164441 2 9-Nov-12 687.78 693.90 682.00 691.89 2780544 2 8-Nov-12 668.01 684.91 663.89 683.67 3041940 2 7-Nov-12 660.17 675.00 658.00 670.71 2509598 2 6-Nov-12 666.44 667.00 659.02 661.15 2205527 23-Nov-12 669.97 670.00 666.10 667.97 922477 2 1-Nov-12 668.99 669.80 660.40 665.87 2113011 20-Nov-12 669.51 678.00 664.57 2089086 19-Nov-12 655.70 668.92 655.53 668.21 2369716 16-Nov-12 645.99 653.02 636.00 647.18 3438500 1 5-Nov-12 650.00 660.00 643.90 647.26 1848939 14-Nov-12 660.66 662.18 650.50 652.55 1668322 13-Nov-12 663.00 667.60 658.23 659.05 1594639 1 2-Nov-12 663.75 660.87 665.90 1405870 654.65 668.34 650.30 663.03 3114084 670.20 671.49 651.23 652.29 2598676 678.23 666.49 667.12 2232438 685.48 686.50 677.55 681.72 1582936 684.50 686.86 675.56 682.96 1635894 694.79 695.55 687.37 687.92 2324569 679.50 690.90 678.72 2050471 3 1-Oct-12 679.86 681.00 680.30 1537001 26-Oct-12 676.50 683.03 671.20 675.15 1950865 2 5-Oct-12 680.00 673.51 677.76 2403696 2 4-Oct-12 686.80 687.00 675.27 677.30 2496411 2 3-Oct-12 672.01 687.33 672.00 680.35 2916978 2 2-Oct-12 681.01 684.63 669.70 678.67 4057872 1 9-Oct-12 705.58 706.70 681.79 11483428 1 8-Oct-12 755.54 759.42 676.00 12442346 17-Oct-12 743.95 756.34 740.26 755.49 2292819 16-Oct-12 740.13 746.99 736.46 744.70 2058468 15-Oct-12 741.94 743.83 730.70 740.98 3020098 12-Oct-12 751.85 754.87 744.10 744.75 2406787 11-Oct-12 752.90 750.29 751.48 2383987 10-Oct-12 741.86 747.53 738.29 744.56 2041203 759.67 761.32 742.53 744.09 3003884 761.00 763.58 754.15 757.84 1958625 770.71 774.38 765.00 767.65 2737751 762.75 769.89 759.40 768.05 2454496 755.72 763.92 752.20 762.50 2208639 765.20 765.99 750.27 756.99 2790375 759.05 756.21 761.78 3168477 28-Sep-12 759.30 751.15 754.50 2784091 2 7-Sep-12 759.95 762.84 751.65 756.50 3932272 2 6-Sep-12 749.85 761.24 741.00 753.46 5674334 2 5-Sep-12 753.05 764.89 747.66 749.16 6061033 2 4-Sep-12 731.00 750.04 730.25 749.38 3565837 21-Sep-12 732.21 734.92 730.12 733.99 6360376 20-Sep-12 724.47 731.38 721.22 728.12 2907854 19-Sep-12 717.50 728.56 716.41 727.50 3098782 18-Sep-12 707.78 718.66 706.78 718.28 2067249 17-Sep-12 708.11 705.00 709.98 1508307 14-Sep-12 709.60 713.00 707.01 709.68 2618874 13-Sep-12 693.09 709.00 690.54 706.04 2659302 12-Sep-12 689.41 694.91 680.88 690.88 2642260 11-Sep-12 697.96 700.65 691.00 692.19 1874004 10-Sep-12 709.76 712.81 698.39 700.77 2560067 712.25 697.67 706.15 3236308 685.96 699.89 684.73 699.40 3044450 679.14 680.72 1708169 684.55 685.00 673.50 681.04 1889613 3 1-Aug-12 684.00 688.58 680.04 685.09 2127125 30-Aug-12 684.24 687.39 680.18 681.68 1627704 2 9-Aug-12 677.37 688.99 676.15 688.01 2991037 2 8-Aug-12 665.00 677.62 664.74 677.25 2058938 2 7-Aug-12 662.99 659.24 669.22 2614131 24-Aug-12 675.60 680.45 674.08 678.63 1429267 2 3-Aug-12 674.27 680.48 671.00 676.80 1784453 2 2-Aug-12 667.38 680.60 666.70 677.18 1909262 21-Aug-12 673.11 662.17 2222805 20-Aug-12 675.50 678.87 672.66 675.54 1758421 17-Aug-12 674.12 671.70 677.14 2177896 1 6-Aug-12 667.51 674.64 667.08 672.87 1717691 15-Aug-12 670.28 674.25 664.10 667.54 2411100 14-Aug-12 659.25 672.85 659.00 668.66 3662178 13-Aug-12 647.42 660.15 646.68 660.01 3268073 10-Aug-12 638.59 642.24 636.13 642.00 1434408 644.51 646.37 641.52 642.35 1070288 639.05 645.87 638.50 642.23 1322386 641.79 644.26 636.47 640.54 1982695 639.61 649.38 639.22 642.82 1782494 640.00 643.72 636.14 641.33 1897446 625.51 638.03 623.41 628.75 1977690 637.30 639.51 631.38 632.68 1844556 31-Jul-12 628.26 636.50 628.22 632.97 1865890 30-Jul-12 636.05 642.60 629.50 632.30 2186717 27-Jul-12 618.89 635.00 617.50 634.96 3550174 2 6-Jul-12 615.00 616.87 610.03 613.36 1687485 2 5-Jul-12 608.32 613.38 605.37 607.99 1822973 24-Jul-12 617.93 604.34 607.57 2012189 2 3-Jul-12 600.48 618.35 598.25 615.51 3561818 20-Jul-12 608.76 612.94 598.18 610.82 6463748 1 9-Jul-12 586.14 598.48 586.00 593.06 4674637 18-Jul-12 576.98 583.69 576.13 580.76 1550950 17-Jul-12 578.43 580.67 568.40 576.73 1681568 16-Jul-12 576.37 579.19 571.78 574.92 1462861 13-Jul-12 572.15 579.15 568.55 576.52 1976558 1 2-Jul-12 567.12 571.93 562.09 570.48 2310094 11-Jul-12 576.30 577.85 564.94 571.19 3500946 10-Jul-12 590.19 592.43 578.74 581.70 1923015 584.95 588.60 581.25 586.01 1715020 592.45 593.52 582.82 585.98 2162328 588.76 600.06 588.54 595.92 2345901 580.01 588.41 578.00 587.83 1190525 581.82 583.00 576.50 580.47 1655563 29-Jun-12 574.96 580.13 572.20 580.07 2522562 2 8-Jun-12 565.90 566.23 557.21 564.31 1922064 2 7-Jun-12 567.70 573.99 566.02 569.30 1692446 2 6-Jun-12 562.76 566.60 559.48 564.68 1351151 2 5-Jun-12 567.33 568.09 557.35 560.70 1582036 22-Jun-12 568.00 571.48 565.82 2229125 2 1-Jun-12 579.84 563.73 565.21 2011322 20-Jun-12 579.81 580.00 573.51 577.51 2346698 19-Jun-12 573.59 584.28 573.12 581.53 2076629 18-Jun-12 562.62 574.21 559.25 570.85 2497864 15-Jun-12 560.34 564.52 557.09 564.51 3002511 1 4-Jun-12 561.30 565.07 556.52 559.05 2345107 13-Jun-12 561.72 567.00 558.68 561.09 1954607 12-Jun-12 569.77 570.30 558.58 565.10 3224142 11-Jun-12 584.21 585.32 566.69 568.50 2662269 575.85 581.00 574.58 580.45 1410366 587.60 587.89 577.25 578.23 1759532 576.48 581.97 573.61 580.57 2096173 575.45 578.13 566.47 570.41 2340477 570.22 580.49 570.01 578.59 2433786 571.79 572.65 568.35 570.98 3058314 3 1-May-12 588.72 590.00 579.00 580.86 2969455 30-May-12 588.16 591.90 583.53 588.23 1906629 2 9-May-12 595.81 599.13 588.32 594.34 2606651 25-May-12 601.00 601.73 588.28 591.53 3582472 2 4-May-12 609.16 611.92 598.87 603.66 1892185 2 3-May-12 601.65 609.60 597.12 609.46 3178016 2 2-May-12 613.44 613.81 596.00 600.80 3052748 21-May-12 600.51 615.69 600.00 614.11 3075829 1 8-May-12 625.10 632.42 596.70 600.40 5976129 1 7-May-12 633.83 637.85 621.23 623.05 3354518 16-May-12 617.96 630.10 615.94 628.93 4837424 15-May-12 605.35 603.75 611.11 2102339 14-May-12 600.78 608.50 600.58 604.00 1824733 11-May-12 610.35 614.55 604.77 605.23 2099726 10-May-12 612.96 616.19 610.23 613.66 1535877 606.82 616.38 601.81 609.15 2329546 605.53 616.90 600.70 612.79 2678485 595.00 610.57 607.55 1994515 605.92 607.89 596.81 596.97 2207360 609.62 614.83 608.95 611.02 1868187 601.20 608.11 600.61 607.26 1611434 603.79 611.60 600.19 604.43 2002424 30-Apr-12 612.99 616.08 604.85 2407213 27-Apr-12 615.02 616.74 610.60 614.98 1636399 26-Apr-12 610.91 618.00 609.70 615.47 2093733 25-Apr-12 611.35 602.88 609.72 1821042 24-Apr-12 598.24 606.63 597.32 601.27 1933303 23-Apr-12 592.90 598.45 590.20 597.60 2197933