Questions
please asnwer all parts of question 5 Date Yearmonth SP500 WMT MSFT MGM CERN XOM 12/3/2012...

please asnwer all parts of question 5

Date Yearmonth SP500 WMT MSFT MGM CERN XOM
12/3/2012 201212 1426.19 65.33 25.39 11.64 38.76 82.52
11/1/2012 201211 1416.18 68.58 25.31 10.15 38.61 84.03
10/1/2012 201210 1412.16 71.43 26.91 10.31 38.1 86.38
9/4/2012 201209 1440.67 70.27 28.06 10.75 38.69 86.65
8/1/2012 201208 1406.58 69.13 29.06 9.86 36.57 82.72
7/2/2012 201207 1379.32 70.49 27.61 9.52 36.96 81.76
6/1/2012 201206 1362.16 66.03 28.66 11.16 41.33 80.55
5/1/2012 201205 1310.33 62.34 27.34 10.83 38.98 74.02
4/2/2012 201204 1397.91 55.42 29.8 13.42 40.56 80.72
3/1/2012 201203 1408.47 57.57 30.02 13.62 38.08 81.09
2/1/2012 201202 1365.68 55.21 29.54 13.77 36.92 80.87
1/3/2012 201201 1312.41 57.34 27.3 13.05 30.44 77.86
12/1/2011 201112 1257.6 55.84 24 10.43 30.62 78.81
11/1/2011 201111 1246.96 54.7 23.65 10.29 30.49 74.8
10/3/2011 201110 1253.3 52.67 24.44 11.52 31.72 72.18
9/1/2011 201109 1131.42 48.2 22.84 9.29 34.26 67.13
8/1/2011 201108 1218.89 49.39 24.41 11.07 32.98 68.42
7/1/2011 201107 1292.28 48.6 24.99 15.11 33.24 73.27
6/1/2011 201106 1320.64 48.99 23.71 13.21 30.56 74.73
5/2/2011 201105 1345.2 50.91 22.81 15.07 30.02 76.65
4/1/2011 201104 1363.61 50.36 23.48 12.66 30.05 80.33
3/1/2011 201103 1325.83 47.67 23 13.15 27.8 76.82
2/1/2011 201102 1327.22 47.28 24.08 13.94 25.11 78.1
1/3/2011 201101 1286.12 51 24.97 14.83 24.71 73.28
12/1/2010 201012 1257.64 49.05 25.14 14.85 23.68 66.42
11/1/2010 201011 1180.55 48.93 22.75 12.22 21.97 63.18
10/1/2010 201010 1183.26 49 23.87 10.93 21.96 60.02
9/1/2010 201009 1141.2 48.41 21.92 11.28 21 55.77
8/2/2010 201008 1049.33 45.35 21.01 9.01 18.21 53.35
7/1/2010 201007 1101.6 46.03 22.98 10.86 19.36 53.49
6/1/2010 201006 1030.71 43.23 20.49 9.64 18.97 51.15
5/3/2010 201005 1089.41 45.47 22.97 12.46 20.93 54.18
4/1/2010 201004 1186.69 47.96 27.07 15.89 21.19 60.33
3/1/2010 201003 1169.43 49.71 25.96 12 21.23 59.62
2/1/2010 201002 1104.49 48.07 25.41 10.54 20.74 57.86
1/4/2010 201001 1073.87 47.5 24.86 11.06 18.92 56.98
12/1/2009 200912 1115.1 47.52 26.89 9.12 20.61 60.31
11/2/2009 200911 1095.63 48.26 25.95 10.57 18.82 66.39
10/1/2009 200910 1036.19 43.95 24.36 9.27 19.01 63.02
9/1/2009 200909 1057.08 43.43 22.59 12.04 18.7 60.33
8/3/2009 200908 1020.62 45 21.65 8.47 15.43 60.8
7/1/2009 200907 987.48 43.88 20.54 7.23 16.27 61.52
6/1/2009 200906 919.32 42.62 20.76 6.39 15.57 61.1
5/1/2009 200905 919.14 43.76 18.25 7.46 14.57 60.61
4/1/2009 200904 872.81 44.1 17.58 8.38 13.45 57.92
3/2/2009 200903 797.87 45.59 15.94 2.33 10.99 59.16
2/2/2009 200902 735.09 42.85 14.02 3.5 9.15 58.99
1/2/2009 200901 825.88 41 14.74 8 8.43 66.11
12/1/2008 200812 903.25 48.78 16.76 13.76 9.61 69
11/3/2008 200811 896.24 48.42 17.43 11.98 8.99 69.28
10/1/2008 200810 968.75 48.35 19.12 16.46 9.31 63.7
9/2/2008 200809 1166.36 51.89 22.85 28.5 11.16 66.75
8/1/2008 200808 1282.83 51.18 23.37 35.19 11.51 68.77
7/1/2008 200807 1267.38 50.59 21.94 29.02 11.16 68.77
6/2/2008 200806 1280 48.5 23.46 33.89 11.3 75.36
5/1/2008 200805 1400.38 49.83 24.15 49.21 11.34 75.9
4/1/2008 200804 1385.59 49.82 24.23 51.15 11.57 79.23
3/3/2008 200803 1322.7 45.27 24.12 58.77 9.32 72
2/1/2008 200802 1330.63 42.41 23.11 61.59 10.86 74.07
1/2/2008 200801 1378.55 43.4 27.59 72.72 13.1 72.64
12/3/2007 200712 1468.36 40.65 30.13 84.02 14.1 79.41
11/1/2007 200711 1481.14 40.78 28.44 86.5 14.94 75.57
10/1/2007 200710 1549.38 38.49 31.05 91.61 14.89 77.67
9/4/2007 200709 1526.75 37.16 24.85 89.44 14.95 78.15
8/1/2007 200708 1473.99 37.15 24.24 83.97 14.26 72.39
7/2/2007 200707 1455.27 38.93 24.37 73.11 13.22 71.59
6/1/2007 200706 1503.35 40.76 24.78 82.48 13.87 70.54
5/1/2007 200705 1530.62 40.32 25.8 79.53 14.2 69.94
4/2/2007 200704 1482.37 40.41 25.09 67.25 13.31 66.47
3/1/2007 200703 1420.86 39.59 23.35 69.52 13.61 63.18
2/1/2007 200702 1406.82 40.54 23.61 71.06 13.03 60.02
1/3/2007 200701 1438.24 40.02 25.77 69.97 11.23 61.79
12/1/2006 200612 1418.3 38.75 24.94 57.35 11.38 63.9
11/1/2006 200611 1400.63 38.54 24.52 53.77 12.01 64.05
10/2/2006 200610 1377.94 41.2 23.89 43.02 12.08 59.29
9/1/2006 200609 1335.85 41.24 22.76 39.49 11.35 55.71
8/1/2006 200608 1303.82 37.39 21.39 35.68 11.52 56.18
7/3/2006 200607 1276.66 37.07 19.95 35.54 10.12 55.98
6/1/2006 200606 1270.2 40.12 19.32 40.8 9.28 50.7
5/1/2006 200605 1270.09 40.36 18.78 41.46 9.49 50.33
4/3/2006 200604 1310.61 37.38 19.95 44.9 9.91 51.87
3/1/2006 200603 1294.87 39.21 22.47 43.09 11.86 50.04
2/1/2006 200602 1280.66 37.51 22.19 36.97 10.41 48.82
1/3/2006 200601 1280.08 38.13 23.17 37.06 11.25 51.32
12/1/2005 200512 1248.29 38.7 21.53 36.67 11.36 45.94
11/1/2005 200511 1249.48 40.04 22.79 38.11 12.05 47.46
10/3/2005 200510 1207.01 39.01 21.09 37.37 10.56 45.68
9/1/2005 200509 1228.81 36.13 21.12 43.77 10.87 51.71
8/1/2005 200508 1220.33 37.07 22.47 42.26 9.85 48.74
7/1/2005 200507 1234.18 40.56 20.96 45.45 9.43 47.57
6/1/2005 200506 1191.33 39.61 20.33 39.58 8.5 46.54
5/2/2005 200505 1191.5 38.82 21.11 38.09 8.17 45.51
4/1/2005 200504 1156.85 38.62 20.64 34.9 7.26 45.95
3/1/2005 200503 1180.59 41.05 19.72 35.41 6.56 48.02
2/1/2005 200502 1203.6 42.16 20.52 37.08 6.51 51.01
1/3/2005 200501 1181.27 42.8 21.37 35.9 6.22 41.37
12/1/2004 200412 1211.92 43.15 21.73 36.37 6.65 41.1
11/1/2004 200411 1173.82 42.42 21.8 29.15 6.59 41.09
10/1/2004 200410 1130.2 43.94 20.41 26.9 5.64 39.25
9/1/2004 200409 1114.58 43.35 20.18 24.83 5.41 38.54
8/2/2004 200408 1104.24 42.92 19.92 20.67 5.48 36.76
7/1/2004 200407 1101.72 43.09 20.73 22.08 5.62 36.7
6/1/2004 200406 1140.84 42.68 20.78 23.47 5.57 35.2
5/3/2004 200405 1120.68 45.31 19.08 22.2 5.35 34.28
4/1/2004 200404 1107.3 46.23 19.01 22.91 5.35 33.51
3/1/2004 200403 1126.21 48.41 18.14 22.67 5.64 32.76
2/2/2004 200402 1144.94 48.2 19.3 21.77 5.59 33.21
1/2/2004 200401 1131.13 43.58 20.12 20.2 4.9 31.93
12/1/2003 200312 1111.92 42.93 19.91 18.81 4.73 32.09
11/3/2003 200311 1058.2 44.95 18.7 18.74 5.58 28.33
10/1/2003 200310 1050.71 47.62 19.02 17.75 5.3 28.43
9/2/2003 200309 995.97 45.04 20.11 18.27 3.86 28.45
8/1/2003 200308 1008.01 47.72 19.19 18.13 4.41 29.3
7/1/2003 200307 990.31 45.09 19.11 17.15 3.96 27.47
6/2/2003 200306 974.5 43.29 18.55 17.09 2.85 27.72
5/1/2003 200305 963.59 42.36 17.8 14.12 2.64 28.1
4/1/2003 200304 916.92 45.35 18.5 14.21 2.5 26.98
3/3/2003 200303 848.18 41.89 17.52 14.62 4.05 26.79
2/3/2003 200302 841.15 38.63 17.15 12.81 4.15 26.08
1/2/2003 200301 855.7 38.42 17.11 13.1 4.61 26
12/2/2002 200212 879.82 40.6 18.64 16.49 3.91 26.6
11/1/2002 200211 936.31 43.26 20.8 16.91 4.11 26.49
10/1/2002 200210 885.76 42.98 19.28 15.55 4.45 25.46
9/3/2002 200209 815.28 39.52 15.77 18.65 4.4 24.13
8/1/2002 200208 916.07 42.87 17.7 17.75 4.67 26.81
7/1/2002 200207 911.62 39.42 17.3 17.5 5.43 27.63
6/3/2002 200206 989.82 44.09 19.72 16.88 5.98 30.75
5/1/2002 200205 1067.14 43.31 18.36 18.84 6.8 30.01
4/1/2002 200204 1076.92 44.72 18.84 20.08 6.64 30.01
3/1/2002 200203 1147.39 49.07 21.75 18.11 5.96 32.75
2/1/2002 200202 1106.73 49.58 21.04 17.2 5.43 30.86
1/2/2002 200201 1130.2 47.96 22.97 16.28 6.05 29.01
12/3/2001 200112 1148.08 46.01 23.89 14.44 6.24 29.19
11/1/2001 200111 1139.45 44.04 23.15 13.18 6.61 27.78
10/1/2001 200110 1059.78 41.04 20.97 11.15 6.72 29.13
9/4/2001 200109 1040.94 39.53 18.45 11.24 6.19 29.09
8/1/2001 200108 1133.58 38.31 20.57 14.57 6.06 29.65
7/2/2001 200107 1211.23 44.57 23.87 15.45 7.04 30.67
6/1/2001 200106 1224.38 38.91 26.32 14.98 5.25 32.07
5/1/2001 200105 1255.82 41.2 24.94 15.72 5.24 32.58
4/2/2001 200104 1249.46 41.19 24.43 15.03 5.63 32.36
3/1/2001 200103 1160.33 40.21 19.72 12.55 4.28 29.59
2/1/2001 200102 1239.94 39.82 21.27 13.44 6.4 29.61
1/2/2001 200101 1366.01 45.16 22.02 14.53 6.04 30.58

Question 5:                         Use Data5 Sheet             

                                This sheet reports monthly value of SP500 index and prices of 5 stocks.

                                REMEMBER to check the timeline order.

                Based on the whole data, create a table reporting the average monthly Return and Total Risk for each of the following stocks:

                Put both Risk and Return in percentage format (say 12.56%)

WMT

MSFT

MGM

CERN

XOM

                (For Total Risk, you use the Standard Deviation based on a Sample – STDEV.S)

                Return=Price(t)/Price(t-1)-1

5a.          Report ticker of the stock with the highest average monthly return

5b.          Report ticker of the stock with the highest total risk

5c.          If you can only invest in 01 stock for only 1 month, which stock and which yearmonth will you choose to maximize your return.

                                Put in the answer sheet that the ticker (in Cap) and year month continuously, say MGM200103.

In: Finance

Admminister Metoclopramide Hydrochloride 10 mg IV push through a locked PICC line. The Client is complaining...

Admminister Metoclopramide Hydrochloride 10 mg IV push through a locked PICC line. The Client is complaining of nausea after her hysterectomy and weighs 200 pounds

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer Furosemide 60 mg IV push through a locked portacatth. The client has early renal failure and weighs 200 pounds.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer Heparin 8000 Units IV push through a saline lock. The clients PTT an hour ago was 160 seconds.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer Ketorolac 15 mg IV Push through a peripheral saline lock. The client is 75 years old and weighs 150 pounds and has post operative pain.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer Solu Medrol 40 mg IV push ghrough a peripheral saline lock. The client weighs 140 pounds and was admitted with an asthma attack yesterday.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer digoxin 600 mcg IV push through a peripheral saline lock. The client weighs 140 pounds and has heart failure.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer diazepam 10 mg IV push through a locked portacat. The client is experiencing alcohol withdrawal.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer morphine sulfate 4 mg IV push through a locked portacath. The client weighs 70 kg and has postoperative pain.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer Lorazepam 10 mg IV push through a locked PICC line. The client weighs 200 pounds and is experiencing a seizure.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer NPH Insulin 8 units IV push. The client weighs 200 pounds and the blood glucose is 330 mg/dL.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

Administer phenytoin 100 mg IV Push. The client has an IV of D5W running at 100 mL/hr. The client, who weighs 180 pounds, has chronic seizures and us NPO for procedure.

1. what is the drug classification?

2. why is the drug being given?

3. is it a propriate situation?

4. is it safe for the client?

5. can you give the drug IV Push?

6. how fast can you administer the drug?

In: Nursing

One common system for computing a grade point average​ (GPA) assigns 4 points to an​ A,...

One common system for computing a grade point average​ (GPA) assigns 4 points to an​ A, 3 points to a​ B, 2 points to a​ C, 1 point to a​ D, and 0 points to an F. What is the GPA of a student who gets an A in a 3​-credit ​course, a B in each of three 2​-credit ​courses, a C in a 3​-credit ​course, and a D in a 4​-credit ​course?

In: Statistics and Probability

One common system for computing a grade point average​ (GPA)assigns 4 points to an​ A,...

One common system for computing a grade point average (GPA) assigns 4 points to an A, 3 points to a B, 2 points to a C, 1 point to a D, and 0 points to an F. What is the GPA of a student who gets an A in a 3-credit course, a B in each of two 4-credit courses, a C in a 3-credit course, and a D in a 2-credit course?

In: Statistics and Probability

An investor invests $500. The investment pays $100 at the end of year 2, $200 at...

An investor invests $500. The investment pays $100 at the end of year 2, $200 at the end of year 3 and $300 at the end of year 4.

Calculate the net present value (NPV) of the investment using interest preference rate of 5.7%.

----------------------------------------------

I got

v = 1/1.12

So would it just be NPV = -500 + 100(v)^2 + 200v^3 + 300v^4?

In: Finance

Imagine that you have been assigned four substances from which you will observe the rate of...

Imagine that you have been assigned four substances from which you will observe the rate of diffusion: substance #1: 212mg? substance #2: 1918 mg substance #3: 50 mg substance #4: 4 mg a) substance #2 will diffuse fastest at first but the other materials will catch up within an hour b) The rate of diffusion for the four substance will be equal

In: Biology

1) A loan of RM10,000 at 12% compounded monthly is to be amortized by 36 monthly...

1) A loan of RM10,000 at 12% compounded monthly is to be amortized by 36 monthly payments.
a) Calculate the monthly payment.
b) Construct an amortization schedule.
2) Sarimah invests RM300 every 3 months for 4 years. She is offered 5% compounded quarterly for the first 2 years and 8% compounded quarterly for the rest of the period. Calculate the accumulated amount at the end of the 4 years.

In: Advanced Math

A study group is to be selected from 5 freshmen, 7 sophomores, and 4 juniors. a....

A study group is to be selected from 5 freshmen, 7 sophomores, and 4 juniors. a. If a study group is to consist of 4 freshmen, 6 sophomores, and 2 juniors, how many different ways can the study group be selected? b. If a study group consisting of 6 students is selected, what is the probability that the group will consist of 2 freshmen, 3 sophomores, and 1 junior?

In: Statistics and Probability

Q1: According to the following table, which describe the grade distribution of students. Find the mean,...

Q1: According to the following table, which describe the grade distribution of students. Find the mean, median class, median, modal class and mode for this distribution.

1-Mean.

2-Median Class.

3-Median.

4-Modal Class.

5-Mode.

Frequency

Grade

2

51 - 55

7

56 - 60

8

61 - 65

4

66 - 70

In: Computer Science

Scenario 2: You are informed that an endocrine organ in the body expresses four membrane receptors...

Scenario 2: You are informed that an endocrine organ in the body expresses four membrane receptors a) receptor-i which is Gs coupled b) receptor-ii which is Gi coupled c) receptor-iii which is Gq coupled d) receptor-iv is a receptor guanylyl cyclase You are further informed that an increase in Ca2+ concentration or an increase in the active PKA levels inside the organ both will result in release of hormone from this endocrine organ. On the other hand, PKG inhibits the release of hormone from this organ. What would be the expected outcome (increased blood concentration of hormone or decreased blood concentration of hormone) with the following drugs: Q4. Receptor 1 agonist? 1 point

Q5. Receptor 1 antagonist? 1 point

Q6. Receptor 2 agonist? 1 point

Q7. Receptor 2 antagonist? 1 point

Q8. Receptor 3 agonist? 1 point

Q9. Receptor 3 antagonist? 1 point

Q10. Receptor 4 agonist? 1 point

Q11. Receptor 4 antagonist? 1 point

In: Anatomy and Physiology