A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a sure rate of 4.1%. The probability distributions of the risky funds are:

The correlation between the fund returns is 0.12.

What is the expected return and standard deviation for the minimum-variance portfolio of the two risky funds? (Do not round intermediate calculations. Round your answers to 2 decimal places.)

5. [Using both Excel (show your work) and SPSS]

​Perform three post hoc tests, comparing the three pairs of means from the previous question. Are there significant differences between:

A. Baseline and one minute?

B. Baseline and two minutes?

C. One minute and two minutes?

Use a = .05 / 3 = .017 for each test.

i only need excel version no need for Spss. Thank you

How to make a Revenue Recognition memo with this information?

Background: Using Implementation Guidance Heavenly Tours Heavenly Tours (HT) was the brainchild of four college friends: Bart, Ava, Carla and Dave. They wanted to create a one-stop, high-touch, discounted tour experience for visitors to two local theme parks. Park Survival provides various simulated survival experiences. Park Adrenaline provides numerous adventures guaranteed to provide visitors with adrenaline rushes. Bart is responsible for managing the relationship with both parks and obtaining discounted admissions for HT’s customers. Ava is responsible for the tour guides, who help customize the experience for visitors. Carla is responsible for working with high-end restaurants in the area surrounding the parks to obtain discounts on food and beverages. Dave is responsible for merchandise, which can be sold to HT’s customers. Historically, HT has reported all cash collected as revenue. A private investor is requesting financial information prepared in accordance with generally accepted accounting principles before investing in HT. The investor has indicated a particular interest in HT’s total revenues. The four friends are meeting with their local accountant to discuss next steps. The accountant informs them they will need to analyze each revenue stream to determine whether HT is acting as a principal or an agent. The accountant states this determination is necessary for proper accounting treatment because when a principal satisfies a performance obligation, the gross amount of consideration is recorded as revenue; however, when an agent satisfies a performance obligation, only the amount of the fee or commission earned is recorded as revenue. Background: The accountant asked Bart to explain the relationship with both parks. Bart explained that he had been able to obtain a 15% discount from Park Survival. HT customers can access Park Survival’s website and use a discount password provided by HT. Under this agreement, HT’s customers are charged 90% of the full entrance price on their credit card when their order is accepted on Park Survival’s website. Once the order is processed on Park Survival’s website, the customer is given a pass that can be used for entrance to Park Survival and 5% is remitted to HT. The negotiations with Park Adrenaline had been more difficult because it was a newer park and in need of cash. Accordingly, HT purchased 100 passes for 90% of the face value. These passes are good for one year from the date of purchase. Any passes that are not used during the year would simply expire. HT has obtained the right to each pass purchased to provide the pass holder with access to the park. HT is free to sell these passes to its customers at any price, as long it doesn’t exceed the face value of the pass. The customer pays an agreed-upon amount when an order is accepted on HT’s website. Park Adrenaline retained the full responsibility for fulfilling its obligation to customers who entered the park with a pass purchased from HT.

ASSIGNMENT REQUIREMENTS:

Read ASC 606-10-55-36 through 40 in ASC 606, Revenue from Contracts with Customers, discussing implementation guidance for principal versus agent determination.

Review the examples in ASC 606-10-55-316 through 334F.

1. For each park, determine if HT is a principal or an agent and, accordingly, how the revenue should be recorded.

2. Prepare a professional accounting research memorandum in proper form with reference to the appropriate sections of the FASB codification.

3. In the memo provide a thorough explanation of your conclusions and the rationale behind your conclusion referencing the appropriate sections of the FASB codification.

During lunchtime, customers arrive at Bob's Drugs according to a Poisson distribution with λ = 5 per minute. Show your answers to 3 decimal places.

What is the probability of one customer arriving?

What is the probability of more than two customers arriving?

What is the probability of at most three customers arriving?

What is the probability of at least four customers arriving?

What is the probability of fewer than two customers arriving?

Waiting times (in minutes) of customers at a bank where all customers enter a single waiting line and a bank where
customers wait in individual lines at three different teller windows are listed below. Find the coefficient of variation for each
of the two sets of data, then compare the variation.
Bank A (single line): 6.5 6.6 6.7 6.9 7.1 7.3 7.4 7.6 7.7 7.8
Bank B (individual lines): 4.4 5.4 5.7 6.2 6.7 7.7 7.8 8.4 9.4 9.9

The coefficient of variation for the waiting times at Bank A is ____%
(Round to one decimal place as needed.)
The coefficient of variation for the waiting times at the Bank B is _____%.
(Round to one decimal place as needed.)
Is there a difference in variation between the two data sets?
A. The waiting times at Bank B have considerably less variation than the waiting times at Bank A
B. There is no significant difference in the variations.
C. The waiting times at Bank A have considerably less variation than the waiting times at Bank B

14.Waiting times​ (in minutes) of customers at a bank where all customers enter a single waiting line and a bank where customers wait in individual lines at three different teller windows are listed below. Find the coefficient of variation for each of the two sets of​ data, then compare the variation

The coefficient of variation for the waiting times at Bank A is ____%.

​(Round to one decimal place as​ needed.)

The coefficient of variation for the waiting times at the Bank B is ____.

​(Round to one decimal place as​ needed.)

Is there a difference in variation between the two data​ sets?

A.There is no significant difference in the variations.

B.The waiting times at Bank B have considerably less variation than the waiting times at Bank A.

c.The waiting times at Bank A have considerably less variation than the waiting times at Bank B.

The speeds of car traveling on Interstate Highway I-35 are normally distributed with a mean of 74
miles per hour and a standard deviation of 6 miles per hour.
(a) Find the percentage of the cars traveling on this highway with a speed
i. of more than 85,
ii. between 65 to 72.
(b) If a BMW is at the speed that is faster than 90 percentage of cars, what is the speed of the
BMW?