Use the data for the components of the S&P 500 index here to answer this question.

"Volume" is the number of shares of the stock that had been exchanged on the trading day at the time the data were downloaded. What is the standard error of "Volume"? Your answer must be correct to at least two decimal place. Use the data for the components of the S&P 500 index here to answer this question.

"Volume" is the number of shares of the stock exchanged for the trading day at the time the data were downloaded. Suppose that the true population average for the Volume is 2,000,000. Notice that this is different from the average in this data set. What is the z value for the average in the data set? Your answer must be correct to at least two decimal place. Use the data for the components of the S&P 500 index here to answer this question. "Volume" is the number of shares exchanged for the the day at the time the data were downloaded. Suppose that the true population average for Volume is 2,000,000. Notice that this is different from the average in this data set. You found the z value for the average in the data set. Assuming that the true population average (mean) Volume was 2,000,000 and that the standard deviation in the sample is actually the population standard deviation the z value you found follows the standard normal distribution. Then, what is the probability of of getting a sample with an average price this high or higher? Your answer must be correct to at least four decimal place. You can use the z table or excel.

I PHW6 Q- volume O, e Share A AutoSave OFF D A D - U - Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) - 11 A+ A- = = O copy B 1 U - - 4 - A. = = = = = Format X y fix A - S, Wrap Text General > AutoSum A "AY: Paste 13 Merge & Center, $ - 9% 2000 Conditional Format Cell Insert Delete Format Formatting as Table Styles 0 Clear Sort & Filter 112 29 72 4 AAL 5 AAP 6 AAP 1 ABSV 8 ARC 9 ABT 10 ACN 11 ADBE 12 ADI 13 ADIA 14 ADP 15 ADS 16 ADS 17 AEE 18 AEP 19 AES 20 AET 21 AFL 22 AGU 23 AIG 24 AIV 25 AIZ 26 AUG 27 AKAM 28 ALB 29 AIGN 30 ALS 31 ALL 32 ALLE 33 ALXN 34 AIAAT 35 AIAD 36 AIME 37 AAG 38 AIAGN 39 AIAP 40 AIAI 41 AZN 42 ANDV Name LAgilent Technologie American Airlines G Advance Auto Parts Apple Inc Abbvie Inc Amerisourcebergen Abbott Laboratories Accenture Pic Adobe Systems Inc Analog Devices Archer Daniels Midi Automatic Data Pro Alliance Data Syste Autodesk Inc Ameron Corp American Eectric P The Aes Corp Aetna Inc Aflac Incorporated Alergan Pc American Internatio Apartment Investme Assurant Inc Arthur J. Gallagher Akamai Technologie Abemarle Corp Align Technology | Alaska Air Group Alstate Corp Alegion Pic Ordinar Alexion Pharm Inc Applied Materials Adv Micro Devices Antok Inc Affiliated Managers Amoen Anneriprise Financia American Tower Cc Amazon.Com Inc Andeavor Last Price Change %Chg High Low 71.03 -0.94 -1.31% 71,85 71 52.16 0.58 1.12% 52.23 51.1 107.23 -0.34 -0.32% 108.38 104.85 173.85 1.420 82% 174 25 171.5 121.24 2.64 2.64 223% 121.55 117.54 99.72 0.32D 32% 400 94.52 59.37 -0.8 -1.33% 59.87 58.95 162.56 -0.1 -0.06% 162.72 161.11 202.22 0.66 D 33% 202.53 199.18 89.02 89.47 86.92 42.79 -0.34 -0.79% 43.18 42.55 116.32 0,14 0 12% 116.64 114, 79 248.79 4.11 1.88% 249.02 244.06 114.64 1.69 1.50% 114.91 55.05 -1.27 -2 25% 56.27 54.8 68.39 -1.30 67.41 65.96 10,52 0,07 067% 10.52 10,36 178.39 -0.12 -0.07% 178.64 176.66 89.72 0.59 0.66% 88.61 161.24 -2.8 -1.71% 160.3 59.68 0.19 0.32% 59.89 59.23 39.66 -0.03 -0.08% 40.01 39.34 88.96 -0.96 -1.07% 89.98 88,17 69.88 0.91 1.32% 69.88 68.87 67, 16 0.270406 67 37 66.28 115.24 3 2.67% 115.39 112 258 6.5 2.58% 259.63 250.5 64.39 -0.58 -0. 895% 65 64.14 942 -0.88% 949 93.25 4.28 5.17% 88. 3i 85.3 121.52 1.05 0.87% 122.11. 118.42 56.99 1.96 3.56% 57.34 54.35 12 1 0 28 2 37% 12.19 11.71 76.36 0.19 -0.19 -0.25% 77.08 75.98 189.11 -1.40 192.34 187.68 1838 0.25 0.145% 184, 33 182.14 160 27 0.46 0.29% 160.95 158.57 139.74 -0.28 - 20% 140.7 138.54 1,479.01 30.32 2.09% 1.480.00 1,444.17 95.19.0.98 -1.00% 96.39 94.85 Volume 1,393,700 1.241.852 509,625 15,858,655 3,727,487 625,993 2,675,518 689,655 1,041,201 1,578,496 1,231,838 427,180 138, 107 S6A, 130 846.278 1,078,087 2,530 267 574,435 569,554 1.137.815 1,804,375 285,894 97,170 285,005 506, 350 668,502 496,848 431,032 692,998 821,133 534,679 10,693,156 27,320,025 363,742 198,899 1,167,448 259,503 751,681 2,856,375 729,098 Time Links 12:37 ET 12:37 ET 12:37 ET 12:37 ET 12:37 ET 12:35 ET 12:37 ET 12:32 ET 12:36 ET 12:37 ET 12:37 ET 12:37 ET 12:31 ET 12:36 ET 12:37 ET 12:37 ET 12:34 ET 12:37 ET 12:32 ET 12:37 ET 12:36 ET 12:37 ET 12:33 ET 12:37 ET 12:36 ET 12:36 ET 12:36 ET 12:37 ET 12:35 ET 12:36 ET 12:37 ET 12:37 ET 12:37 ET 12:33 ET 12:32 ET 12:37 ET 12:36 ET 12:37 ET 12:36 ET 12:36 ET -0.84 Sheet1 + Ready 9 D 0 - - + 100% I PHW6 Q- volume O, e Share A AutoSave OFF D A D - U - Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) - 11 A+ A- = = O copy B 1 U - - 4 - A. = = = = = Format X y fix A - S, Wrap Text General > AutoSum A "AY: Paste 13 Merge & Center, $ - 9% 2000 Conditional Format Cell Insert Delete Format Formatting as Table Styles 0 Clear Sort & Filter 112 29 72 4 AAL 5 AAP 6 AAP 1 ABSV 8 ARC 9 ABT 10 ACN 11 ADBE 12 ADI 13 ADIA 14 ADP 15 ADS 16 ADS 17 AEE 18 AEP 19 AES 20 AET 21 AFL 22 AGU 23 AIG 24 AIV 25 AIZ 26 AUG 27 AKAM 28 ALB 29 AIGN 30 ALS 31 ALL 32 ALLE 33 ALXN 34 AIAAT 35 AIAD 36 AIME 37 AAG 38 AIAGN 39 AIAP 40 AIAI 41 AZN 42 ANDV Name LAgilent Technologie American Airlines G Advance Auto Parts Apple Inc Abbvie Inc Amerisourcebergen Abbott Laboratories Accenture Pic Adobe Systems Inc Analog Devices Archer Daniels Midi Automatic Data Pro Alliance Data Syste Autodesk Inc Ameron Corp American Eectric P The Aes Corp Aetna Inc Aflac Incorporated Alergan Pc American Internatio Apartment Investme Assurant Inc Arthur J. Gallagher Akamai Technologie Abemarle Corp Align Technology | Alaska Air Group Alstate Corp Alegion Pic Ordinar Alexion Pharm Inc Applied Materials Adv Micro Devices Antok Inc Affiliated Managers Amoen Anneriprise Financia American Tower Cc Amazon.Com Inc Andeavor Last Price Change %Chg High Low 71.03 -0.94 -1.31% 71,85 71 52.16 0.58 1.12% 52.23 51.1 107.23 -0.34 -0.32% 108.38 104.85 173.85 1.420 82% 174 25 171.5 121.24 2.64 2.64 223% 121.55 117.54 99.72 0.32D 32% 400 94.52 59.37 -0.8 -1.33% 59.87 58.95 162.56 -0.1 -0.06% 162.72 161.11 202.22 0.66 D 33% 202.53 199.18 89.02 89.47 86.92 42.79 -0.34 -0.79% 43.18 42.55 116.32 0,14 0 12% 116.64 114, 79 248.79 4.11 1.88% 249.02 244.06 114.64 1.69 1.50% 114.91 55.05 -1.27 -2 25% 56.27 54.8 68.39 -1.30 67.41 65.96 10,52 0,07 067% 10.52 10,36 178.39 -0.12 -0.07% 178.64 176.66 89.72 0.59 0.66% 88.61 161.24 -2.8 -1.71% 160.3 59.68 0.19 0.32% 59.89 59.23 39.66 -0.03 -0.08% 40.01 39.34 88.96 -0.96 -1.07% 89.98 88,17 69.88 0.91 1.32% 69.88 68.87 67, 16 0.270406 67 37 66.28 115.24 3 2.67% 115.39 112 258 6.5 2.58% 259.63 250.5 64.39 -0.58 -0. 895% 65 64.14 942 -0.88% 949 93.25 4.28 5.17% 88. 3i 85.3 121.52 1.05 0.87% 122.11. 118.42 56.99 1.96 3.56% 57.34 54.35 12 1 0 28 2 37% 12.19 11.71 76.36 0.19 -0.19 -0.25% 77.08 75.98 189.11 -1.40 192.34 187.68 1838 0.25 0.145% 184, 33 182.14 160 27 0.46 0.29% 160.95 158.57 139.74 -0.28 - 20% 140.7 138.54 1,479.01 30.32 2.09% 1.480.00 1,444.17 95.19.0.98 -1.00% 96.39 94.85 Volume 1,393,700 1.241.852 509,625 15,858,655 3,727,487 625,993 2,675,518 689,655 1,041,201 1,578,496 1,231,838 427,180 138, 107 S6A, 130 846.278 1,078,087 2,530 267 574,435 569,554 1.137.815 1,804,375 285,894 97,170 285,005 506, 350 668,502 496,848 431,032 692,998 821,133 534,679 10,693,156 27,320,025 363,742 198,899 1,167,448 259,503 751,681 2,856,375 729,098 Time Links 12:37 ET 12:37 ET 12:37 ET 12:37 ET 12:37 ET 12:35 ET 12:37 ET 12:32 ET 12:36 ET 12:37 ET 12:37 ET 12:37 ET 12:31 ET 12:36 ET 12:37 ET 12:37 ET 12:34 ET 12:37 ET 12:32 ET 12:37 ET 12:36 ET 12:37 ET 12:33 ET 12:37 ET 12:36 ET 12:36 ET 12:36 ET 12:37 ET 12:35 ET 12:36 ET 12:37 ET 12:37 ET 12:37 ET 12:33 ET 12:32 ET 12:37 ET 12:36 ET 12:37 ET 12:36 ET 12:36 ET -0.84 Sheet1 + Ready 9 D 0 - - + 100%