Group Project Berk DeMarzo Data Case chapter 10 1. Collect price information for each stock from Yahoo! Finance Professor has provided it for us. The specific data of question 2-4 is in the appendix. We only include the functions and simple answers below every question. 2. Return=(P2-P1)/P1 3. mean monthly returns, standard deviations for the monthly returns and annual statistics Ticker | AAPL | ADM | BA | C | CAT | DE | HSY | MOT | PG | SIRI | WMT | YHOO | Mean | 8.39% | 3.70% | 2.68% | -0.26% | 2.87% | 3.40% | 0.43% | 0.48% | 1.25% | 3.34% | 0.69% | 2.22% | SD | 0.1584 | 0.1050 | 0.0697 | 0.0709 | 0.0742 | 0.0867 | 0.0491 | 0.0934 | 0.0455 | 0.1963 | 0.0477 | 0.1299 | Annual Mean | 1.0068 | 0.4444 …show more content…
3.60 | Dec-04 | 19.41 | 8.46 | -2.28 | 1.81 | -8.22 | -6.67 | 5.30 | -8.50 | -2.92 | -13.12 | -0.78 | -6.56 | -1.17 | Jan-05 | 16.67 | -0.09 | 9.15 | -1.85 | 6.66 | 2.40 | 8.10 | -0.47 | -0.27 | -15.86 | -1.51 | -8.35 | 1.22 | Feb-05 | -7.11 | 2.01 | 6.35 | -5.82 | -3.79 | -5.16 | -4.03 | -4.19 | -0.17 | 0.90 | -2.62 | 5.05 | -1.55 | Mar-05 | -13.46 | -26.80 | 1.82 | 5.49 | -3.27 | -6.84 | 5.69 | 2.47 | 2.70 | -15.30 | -5.93 | 1.77 | -4.31 | Apr-05 | 10.26 | 10.81 | 7.80 | 0.30 | 6.89 | 5.77 | 0.81 | 13.29 | 1.85 | 26.26 | 0.50 | 7.83 | 7.70 | May-05 | -7.42 | 7.71 | 3.28 | -1.85 | 1.28 | -0.53 | -3.28 | 5.35 | -4.36 | 7.82 | 2.05 | -6.85 | 0.27 | Jun-05 | 15.87 | 7.31 | 0.02 | -4.98 | 13.64 | 12.29 | 2.84 | 15.98 | 6.01 | 5.25 | 2.39 | -3.78 | 6.07 | Jul-05 | 9.94 | -1.49 | 1.91 | 0.62 | 2.93 | -11.09 | -7.10 | 3.28 | -0.26 | 0.88 | -8.62 | -0.06 | -0.76 | Aug-05 | 14.33 | 9.56 | 1.39 | 4.01 | 5.88 | -5.92 | -4.72 | 0.87 | 7.16 | -4.94 | -2.53 | 1.56 | 2.22 | Sep-05 | 7.42 | -1.17 | -4.87 | 0.56 | -10.09 | -0.85 | 0.94 | 0.57 | -5.36 | -4.74 | 7.96 | 9.25 | -0.03 | Oct-05 | 17.76 | -2.93 | 5.88 | 7.09 | 9.87 | 14.30 | -4.16 | 8.74 | 2.14 | 14.77 | 2.65 | 8.82 | 7.08 | Nov-05 | 6.00 | 4.59 | 3.02 | -0.05 | -0.02 | -1.25 | 1.89 | -6.07 | 1.21 | -6.29 | -3.34 | -2.61 | -0.24 | Dec-05 | 5.04 | 27.73 | -2.76 | -4.01 | 18.01 | 5.37 | -7.33 | 0.51 | 2.82 | -15.37 | -1.46 | -12.25 | 1.36 | Jan-06 | -9.30 | 1.05 | 6.86 | 0.62 | 7.63 | 6.30 | 0.37 |
3. Understanding that HIV is a retrovirus (a virus that uses reverse transcriptase), answer the following questions:
You are the investment banker assigned with the task of setting the IPO price for Boston Beer Company (BBC). Prepare a research report to support your recommendation. As you prepare this report, you may find that you would like to have more field information than what the case offers you. However, the case contains critical information that gives you a reasonable basis to compute its valuation. In addition use the following information for 1995.1 Sales ($ millions) Redhook Pete’s BBC 25.89 59.17 151.31 EPS .75 .25 .40 Book value/share 7.70 4.33 3.00 Price 27.00 24.75 ?
2.52 0.63 49.19 3.50 74.31 39.83 69.86 96.97 5.34 1.46 0.65 0.57 5.73 1.47 35.22% 13.06% 7.01% 12.42% 29.41%
31. A new weight-watching company, Weight Reducers International, advertises that those who join will lose, on the average, 10 pounds the first two weeks with a standard deviation of 2.8 pounds. A random sample of 50 people who joined the new weight reduction program revealed the mean loss to be 9 pounds. At the .05 level of significance, can we conclude that those joining Weight Reducers on average will lose less than 10 pounds? Determine the p-value.
1. To begin, assume that it is now January 1, 1993, and that each bond in Table 1 matures on December 31 of the year listed. Further, assumes that each bond has $1,000 par value, each had a 30-year maturity when it was issued, and the bonds currently have a 10 percent required nominal rate or return.
(The Table value for significance at 0.05 level with df 2 and 57 and 2 and 56 are 3.14 and 3.15 respectively)
31. A new weight-watching company, Weight Reducers International, advertises that those who join will lose, on the average, 10 pounds the first two weeks with a standard deviation of 2.8 pounds. A random sample of 50 people who joined the new weight reduction program revealed the mean loss to be 9 pounds. At the .05 level of significance, can we conclude that those joining Weight Reducers on average will lose less than 10 pounds? Determine the p-value.
I drew the curve this way because from 1990 to 2010 the curve starts to increase steadily.
Data collection has been around for years in one form or another. The implementation of the No Child Left Behind Act stimulated dedicated educators to learn the correlation between data driven decision-making and successful school improvement plans. The legislative goal was to ensure academic success across all socioeconomic frontiers. Districts across the country were steered into driving their instruction with data and teacher collaboration. This has lead to districts that have successfully found the correlation between data driven decision-making and success.
0.18 0.23 0.23 0.27 0.28 0.3 0.3 0.31 0.31 0.34 0.35 0.39 0.42 0.45 0 0.1 0.2 0.3 0.4 0.5
Symbol OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS OFSS Series EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ EQ Date 22-Apr-08 23-Apr-08 24-Apr-08 25-Apr-08 28-Apr-08 29-Apr-08 30-Apr-08 2-May-08 5-May-08 6-May-08 7-May-08 8-May-08 9-May-08 12-May-08 13-May-08 14-May-08 15-May-08 16-May-08 20-May-08 21-May-08 22-May-08 23-May-08 26-May-08 Prev Close 1323.85 1288.55 1280.9 1337.55 1331.85 1299.9 1320.4 1397 1423.3 1346.25 1351.1 1347.05 1318.1 1265.6 1228.3 1326.1 1384.6 1362.55 1403.3 1426.5 1458.45 1506.35 1440.4 Open Price High Price Low Price Last Price Close Price 1330 1290 1300 1365 1345 1315 1330 1450 1447.8 1360 1370 1345 1310 1267 1251 1310 1405 1380 1394 1420 1465 1495.1 1415 1330 1338 1365 1369.8 1359 1351 1425 1462.4 1447.8 1410 1380 1359 1335 1267 1368.95 1404 1439 1413.85 1450 1491 1520 1545 1423 1250 1271 1263.6 1321 1282 1296 1280 1414.95 1335 1293.6 1326.5 1302.7 1243.1 1205 1100 1310 1341.6 1366 1355 1400 1455 1422 1340 1290 1273.4 1335 1332.95 1300 1320 1395 1425.05 1340 1360 1340 1313 1245 1228 1325 1392 1360.15 1409 1424 1485 1515
The second example is a bar graph, which show descriptive statistics. It is about Facebook’s Company Valuation from December 2010 till August 2011, skipping the months of February and May horizontally and the valuation in billions on the vertical axis starting from $55 to $90, increasing by multiples of five. The month of December has a value of $60B, following with $66.2 in January, $79.2 and $81.6 for March, April has $76.8, $79.2 and $84 for June, July follows with $84, $84, $81.6, and lastly August has $79.2. They used
Summary statistics, using the observations 2012/01/02 - 2013/12/02 for the variable 'R_i ' (101 valid observations)
then it comes with a lag of 2 months (e.g. figures for quarter Jan-Mar 2008
|0.51 |-0.2 | |130 |123 |123.391 |0.32 |-0.4 | |140 |116 |116.788 |0.67 |-0.7 | |150 |108 |107.812 |0.17 |-1 | |160 |97 |96.656 |0.36 |-1 | |170 |83 |83.799 |0.95 |-1.4 | |180 |69 |70 |1.43 |-1.3 | |190 |55 |56.201 |2.14 |-1.4 | |200 |42 |43.344 |3.1 |-1.4 | |210 |32 |32.188 |0.58 |-1 | |220 |23 |23.212 |0.91 |-0.9 |