Given the following information,

a) What are the expected returns for stock A and B, respectively?

b) What is the standard deviation/risk for stock A? List the formula and input the number, no calculation needed.

c) What is the portfolio return given that you have $10,000 and allocate $3,000 in stock A and the rest in stock B? List the formula and input the number, no calculation needed.

d) The principle of diversification states that as the number of stocks under the portfolio increases, the portfolio risk more likely A) increases or B) decreases?

Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on 3.18.2018-3.17.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 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. Answers with no work and no explanation will receive no credit.

1. a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions. – COPIED SUBMITTED

b) What is the mean and Standard Deviation (SD) of the Close column in your data set? –

• Standard Deviation – 1112.1782
• Mean –    67.239

c) 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? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution. (5 points) – PROBABILITY IS .5. This is because there is a 50/50 chance that the stock is above or below the mean. – (1112.2-1112.2)/67.4 = 0(0.5000) 1-.5000 = 0.5

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 $1150? (5 points):

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 $50 of the mean for that year? (Hint: this means the probability of being between 50 below and 50 above the mean)
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 unusual? Use the definition of unusual from the course textbook that is measured as a number of standard deviations
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.
6. What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you must answer without using anything about the normal distribution.

Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in the course textbook? Real data sets are never perfect, however, it should be close. One option would be to construct a histogram as you did in Project 1 to see if it has the right shape. Something in the range of 10 to 12 classes is a good number.

The weight of a small Starbucks coffee is a normally distributed random variable with a mean of 350 grams and a standard deviation of 11 grams. Find the weight that corresponds to each event. (Use Excel or Appendix C to calculate the z-value. Round your final answers to 2 decimal places.)
a. Highest 10 percent _________
b. Middle 50 percent _________to________
c. Highest 80 percent _________
d. Lowest 10 percent__________

In C++

c. The program should output the highest and lowest temperatures for the year. Your program must consist of the following functions:

a. Function getData: This function reads and stores data in the two-dimensional array.

b. Function indexHighTemp: This function returns the index of the highest high temperature in the array.

c. Function indexLowTemp: This function returns the index of the lowest low temperature in the array.

These functions must all have the appropriate parameters.

Goal:
Make the highest volume VG/PG solution at 80%/20%, respectively, with a 0.3% nicotine level.

Ingredients:

750ml VG

250ml PG

125ml 75%/25% VG/PG solution at 2.4% nicotine level.

I need to know the formula for the highest volume of this solution I can make that ends with a 0.3% nicotine level at an 80%/20% VG/PG ratio, given the above listed ingredients.

Ant on a metal plate. The temperature at a point ( x, y) on a metal plate is T(x, y) = 4x² - 4xy + y² . An ant on the plate walks around the circle of radius 10 centered at the origin.

a) What are the highest and lowest temperatures encountered by the ant?

b) Suppose the ant has changed its trajectory and is walking around the circle of radius 5. Is the highest temperature encountered by the ant greater or less compared to the one in part a)?

Rank the following three single taxpayers in order of the magnitude of taxable income (from lowest to highest). (First mean highest taxable income, third means lowest taxable income.)

(a)Suppose the market demand function for orchids (in pots) is given by Q=1400-30P. Now we rank the MB of each pot of orchids from the highest to the lowest, what is the MB of the 200th pot of orchids?

(b)Suppose the market supply function for orchids (in pots) is given by Q=40P-400. Now we rank the MC of each pot of orchids from the lowest to the highest what is the MC of the 200th pot of orchids?

There are four tables in the database.

1. students (sno, sname, sgender, sbirthday, class)

- sno: student number

- sname: student name

- sgender: male or female

- sbirthday: date of birth

- class: class number

- primary key: sno

2. courses (cno, cname, tno)

- cno: course number

- cname: course name

- tno: teacher number

- primary key, cno, tno

3. scores (sno, cno, grade)

- sno: student number

- cno: course number

- grade: grade

- primary key, sno, cno

4. teachers (tno, tname, tgender, tbirthday, title, department)

- tno: teacher number

- tname: teacher name

- tgender: teacher gender

- tbirthday: date of birth

- title: title of the teacher, e.g. professor, lecture, or TA

- department: department name, e.g. CS, EE.

Question 1: In the score table, find the student number that has all the grades in between 90 and 70.

Question 2: For all the courses that took by class 15033, calculate the average grade.

Question 3: Find the class number that has at least two male students.

Question 4: Find the teacher's name in CS and EE department, where they have different title. Return both name and title.

Question 5: Find the students, who took the course number "3-105" and have earned a grade, at least, higher than the students who took "3- 245" course. Return the results in a descending order of grade.

Question 6: Find the students, who took more than 1 course, and return the students' names that is not the one with highest grade.

Question 7: For each course, find the students who earned a grade less than the average grade of this course.

There is an old drug for a certain disease. The cure rate of the old drug (the proportion of patients cured) is 0.8.

Pharma Co has developed a new drug for this disease. The company is conducting a small field trial (trial with real patients) of the new drug and the old drug. Assume that patient outcomes are independent. Also, assume the probability that any one patient will be cured when they take the drug is p.  For the old drug, p = 0.8. The random variable X is the number of patients who are cured when the drug is given to n patients.

A. The old drug is given to 16 randomly-chosen patients. What is the expected number of patients who will be cured?  One decimal.

B. The old drug is given to 16 randomly-chosen patients. What is the probability that all 16 will be cured?  Four decimals.

C. Pharma Co thinks the answer to the previous question is too big. They want the probability that all of the patients will be cured to be less than 0.01. (We mean “all of the patients who get the old drug in the field trial”.) What is the smallest number of patients that Pharma Co must give the old drug to? HINT: You can do this either by trial and error (increasing n above 16), or by setting up an inequality with n as an unknown, and taking the natural logarithm of it to solve for n.  Integer.

D. Alternatively, suppose Pharma Co uses a sample size of 35. The old drug is given to 35 randomly-chosen patients. What is the probability that all 35 will be cured?  Four decimals.

E. Pharma Co thinks the answer to the previous question is too small! They want P(X  a)  0.01 , and they want the smallest value of “a” where P(X  a)  0.01. In other words, they don’t necessarily want to use a = 35. What about a = 34? Is P(X  34)  0.01? Is P(X  33)  0.01. Find the smallest value of “a” where P(X  a)  0.01. NOTE: We are not changing n. We are still giving the old drug to 35 patients. We are just calculating P(X  a), when n = 35 and p = 0.8, for different values of “a”, to find the value of “a” that we want.  Integer.

F. For the new drug, p = 0.95. Go back to your answer to the third question in this set (“smallest number of patients …”). Suppose Pharma Co gives the new drug to this many patients. What is the probability they all will be cured?  Four decimals.

G. Go back to your answer to the question E in this set (“find the smallest value of a where …”). Use the value of “a” that you calculated in that question. What is P(X ≥≥ a) if the new drug (p = 0.95) is given to 35 patients?  Four decimals