Question

Visit the NASDAQ historical prices weblink.

UPDATE: Copy and Paste

https://finance.yahoo.com/quote/GOOG/history/

Or here are the numbers

1175.76

1142.32

1143.3

1157.86

1162.03

1147.8

1140.99

1119.92

1116.05

1115.13

1109.4

1110.37

1096.97

1113.8

1118.56

1113.65

1121.67

1120.16

1121.37

1095.01

1095.06

1098.71

1115.23

1145.99

1132.8

1110.75

1116.37

1089.06

1060.62

1070.08

1090.99

1073.9

1075.57

1070.52

1098.26

1089.9

1080.97

1077.15

1044.69

1057.19

1070.33

1074.66

1076.28

1068.39

1070.71

1016.06

1045.85

1035.61

1037.08

1043.88

1039.46

976.22

979.54

1009.41

1023.01

1028.71

1016.53

1042.1

1061.9

1063.68

1051.75

1039.55

1036.58

1068.73

1050.82

1106.43

1094.43

1088.3

1086.23

1044.41

1048.62

1023.88

1037.61

1025.76

1020

1061.49

1064.71

1043.66

1036.05

1038.63

1066.15

1082.4

1093.39

1055.81

1040.09

1057.79

1070

1076.77

1036.21

1020.08

1071.47

1095.57

1050.71

1103.69

1101.16

1096.46

1087.97

1115.69

1121.28

1092.25

1110.08

1079.32

1081.22

1138.82

1148.97

1157.35

1168.19

1202.95

1200.11

1195.31

1193.47

1194.64

1180.49

1184.65

1173.37

1166.09

1186.87

1171.09

1161.22

1156.05

1172.53

1175.33

1162.82

1177.36

1164.64

1164.83

1171.44

1186.48

1197

1218.19

1239.12

1249.3

1231.15

1241.82

1220.65

1205.38

1207.33

1201.62

1207.77

1200.96

1206.49

1214.38

1242.1

1235.01

1237.61

1249.1

1245.61

1242.22

1224.77

1223.71

1226.15

1220.01

1217.26

1219.74

1238.5

1268.33

1263.7

1248.08

1205.5

1184.91

1186.96

1195.88

1198.8

1183.86

1188.82

1183.48

1153.9

1152.84

1154.05

1140.17

1124.27

1102.89

1127.46

1115.65

1114.22

1103.98

1118.46

1124.81

1155.48

1157.66

1169.84

1168.06

1173.46

1152.26

1152.12

1134.79

1139.32

1129.99

1120.87

1123.86

1136.88

1139.66

1139.29

1119.5

1084.99

1067.8

1060.32

1075.66

1079.24

1079.69

1069.73

1079.58

1066.36

1078.59

1081.77

1079.23

1100.2

1098.26

1097.57

1082.76

1053.91

1054.79

1048.21

1023.72

1024.38

1037.31

1017.33

1030.05

1040.04

1021.18

1019.98

1067.45

1072.96

1087.7

1072.08

1074.16

1037.98

1029.27

1032.51

1019.97

1031.64

1015.45

1007.04

1027.81

1025.14

1013.41

1006.47

1031.79

1004.56

1005.1

1053.21

1021.57

1049.08

1090.88

1097.71

1099.82

1135.73

1149.58

1149.49

1138.17

1164.5

USE DATA IN SPREADSHEET FROM MARCH 12TH 2018 THRU MARCH 11TH 2019 Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer. This project will only use the Close 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. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points. Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers.

4- 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 $900 per share. Would this be considered unusal? Use the definition of unusual from the course textbook that is measured as a number of standard deviations (5 points)

5- At what prices would Google have to close in order for it to be considered statistically unusual? You will have a low and high value. Use the definition of unusual from the course textbook that is measured as a number of standard deviations. (5 points)

Answer 1

Answer:

Mean of Closing prices of Google stock price at closing : 1111.4

Standard Dev. of Closing prices of Google stock price at closing : 66.74

4.

To obtain the probability of stock on that day closed at less than $900 per share, we have obtained the count of days when stock closes below $900 and then divide that number by total no. of days in given time period of last year.

No. of times stock closes below $900 = 0

total no of days= 250

Probability = 0

Since there is not a single day in a last year that stock falls below $900 value. which shows that probability that value of stock on day closed at less than $900 is almost 0.

This event is considered to be unusual event.

5.

We have data of last year from which we got,

Minimum= 976.22

Maximum= 1268.33

Hence Google have to close the Stock value less than 976.22 or higher than 1268.33 then it would be considered statistically unusual for this scrip.