Subject DataBase/MySQL

What is wrong with this statement?

SELECT vendor_id, (SELECT vendor_name FROM vendors), avg(invoice_total)
FROM invoices
GROUP BY vendor_id;

Select one:

a. The subquery returns more than 1 row.

b. You need a JOIN ON clause to pull from multiple tables.

c. You cannot have a subquery in the SELECT statement.

d. The result is a Cartesian Product.

e. There is nothing wrong with this statement.

What is wrong with this statement?

SELECT vendor_name, avg(invoice_total) AS 'Invoice Total'
FROM vendors v
JOIN invoices i ON v.vendor_id = i.vendor_id

Select one:

a. You are missing the GROUP BY clause.

b. Nothing, this statement runs correctly.

c. The JOIN ON clause is incorrect.

d. Invoices should also be in the FROM clause.

e. You are using single quotes instead of double quotes.

- TIA

                                                                                          E(R)

                                                                                          Stock A                    Stock B

State                                           p(i)                             E(Ra)                         E(Rb)

Recession                                30%                          -30%                         -20%

Normal                                     40%                          10%                          10%                          

Expansion                               30%                          50%                          30%

Beta                                                                                1.4                             1.25

R_f                                                                                      3%

R_M                                                                                    8%

1. What is the expected return on Stock A across all market situations?

What is the expected return on Stock B across all market situations?

2. What is the standard deviation of Stock A’s return?

What is the standard deviation of Stock B’s return?

3. With a mix of 75% Stock A and 25% Stock B what is the portfolio return?

With a mix of 75% Stock A and 25% Stock B what is the portfolio standard deviation?

4. Which of the two stocks has higher total risk?

Which of the two stocks has higher systematic risk?

5. Which of the two stocks has a higher Reward-to-Risk Ratio?

Are the two stocks under or over-valued based on the Capital asset Pricing Model?

6. What return would you expect on each stock based on the Capital Asset Pricing Model?

P [1r / 0s] = 0.03 and P [0r / 1s] = 0.02 conditional in an asymmetric binary communication channel

available. The probability of sending 0 in this channel is P [1s] = 0.56. 25 bits from this channel

It has been sent. Accordingly, find the possibility of fewer than 3 faulty bits in the 25 bits transmitted.

Note: 0s : 0 transmit, 1s : 1 transmit, 0r : 0 represent, 1r : 1 represent running events.

1. Roll a pair of dice (one is red and the other is green). Let A be the event that the red die is 4 or 5. Let B be the event that the green die is 1 Let C be the event that the dice sum is 7 or 8.

1. Calculate P(A), P(B), P(C)
2. Calculate P(A|C), P(A|B)
3. Are the events A and C independent?

2. Suppose box 1 has four black marbles and two white marbles, and box 2 has two black marbles and five marbles. If you picked one marble from one of the two boxes at random, what it the probability that you picked from box 1 given that the marble you picked is black?

3. A raffle has 5000 tickets with the following prizes: 1 ticket has $2000 prize, 10 tickets have $200 prize, and 20 tickets have $50 prize and 500 tickets have a $20 prize. If to buy a ticket costs $15, and X is the random variable that measures net profit:

1. Calculate the pdf table of X
2. Calculate E(X), Var(X)

4. If a fair coin is flipped 120 times, what is the probability that:

1. The number of heads is more than 70
2. The number of heads between 50 and 70?

5. According to a study, 21.1% of 507 female college students were on a diet at the time of the study.

a) Construct a 99% confidence interval for the true proportion of all female students who were on a diet at the time of this study.

b) Explain what this interval means.

c) Is it reasonable to think that only 17% of college women are on a diet?

6. A used car dealer says that the mean price of a 2008 Honda CR-V is at least $20,500. You suspect this claim is incorrect and find that a random sample of 14 similar vehicles has a mean price of $19,850 and a standard deviation of $1084. Is there enough evidence to reject the dealer’s claim at α = 0.05?

With one sentence or two explain how are the two key terms relate to each other​:

1-Marketing (The 4P's) and Value Proposition &Value Creation:

2-Marketing (The 4P's) and Logos:

3- Marketing (The 4P's) and Organizational Culture:

4-Marketing (The 4P's) and Customer experience mapping:

5-Opportunity Cost and Marketing (The 4P's):

6-Brand Loyalty and Marketing (The 4P's):

7- Customer Relationship Building and Marketing (The 4P's):

8- Competitive Advantage and Marketing (The 4P's):

9- Digital and Online Marketing and Marketing (The 4P's):

Consider a two-period binomial model in which a stock trades currently at $44. The stock price can go up 6% or down 6% each period. The risk free rate is 2% per period.

A) Calculate the price of a call option expiring in two periods with an exercise price of $45.

B) Calculate the price of a put option expiring in two periods with an exercise price of $45.

Consider a two-period binomial model in which a stock trades currently at $44. The stock price can go up 6% or down 6% each period. The risk free rate is 2% per period.

A) Calculate the price of a call option expiring in two periods with an exercise price of $45.

B) Calculate the price of a put option expiring in two periods with an exercise price of $45.

C) Based on your answer in A), calculate the number of units of the underlying stock that would be needed at t=0 in the binomial tree to construct a risk-free hedged portfolio which includes 10,000 calls.

Consider two vectors F1 with magnitude 44 N inclined at 61 o and F2 with magnitude 98 N inclined at 139 o , measured from the positive x axis with counterclockwise positive.

Find the direction of this resultant vector (between the limits of 0 and −180◦ from the positive x-axis). Answer in units of o . Your answer must be within ± 5.0%

Applications that do not violate the OLS assumptions for inference. Identify the response and explanatory variable(s) for each problem. Write the OLS assumptions for inference in the context of each study.

1. Cricket Chirps. Researchers record the number of cricket chirps per minute and temperature during that time to investigate whether the number of chirps varies with the temperature.
2. Women’s Heights. A random selection of women aged 20-24 years are selected and their shoe size is used to predict their height