n a recent 5-year period, mutual fund manager Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the market index are given for comparison.

a. Calculate (a) the average return on both the Fund and the index, and (b) the standard deviation of the returns on each. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

b. Did Ms. Sauros do better or worse than the market index on these measures?

Suppose that we randomly select 50 billing statements from each of the computer databases of the Hotel A, the Hotel B, and the Hotel C chains, and record the nightly room rates. The means and standard deviations for the data are given in the table.

(a) Find a 95% confidence interval for the difference in the average room rates for the Hotel A and the Hotel B chains. (Use Hotel A − Hotel B. Round your answers to two decimal places.)

$______ to $______

(b)Find a 99% confidence interval for the difference in the average room rates for the Hotel B and the Hotel C chains. (Use Hotel B − Hotel C. Round your answers to two decimal places.)

$______ to $______

Suppose that we randomly select 50 billing statements from each of the computer databases of the Hotel A, the Hotel B, and the Hotel C chains, and record the nightly room rates. The means and standard deviations for the data are given in the table.

(a) Find a 95% confidence interval for the difference in the average room rates for the Hotel A and the Hotel B chains. (Use Hotel A − Hotel B. Round your answers to two decimal places.)

$______ to $______

(b)Find a 99% confidence interval for the difference in the average room rates for the Hotel B and the Hotel C chains. (Use Hotel B − Hotel C. Round your answers to two decimal places.)

$______ to $______

Suppose that we randomly select 50 billing statements from each of the computer databases of the Hotel A, the Hotel B, and the Hotel C chains, and record the nightly room rates. The means and standard deviations for the data are given in the table.

(a) Find a 95% confidence interval for the difference in the average room rates for the Hotel A and the Hotel B chains. (Use Hotel A − Hotel B. Round your answers to two decimal places.)

$______ to $______

(b)Find a 99% confidence interval for the difference in the average room rates for the Hotel B and the Hotel C chains. (Use Hotel B − Hotel C. Round your answers to two decimal places.)

$______ to $______

1. The owner of Showtime Movie Theaters, Inc. would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow.

1. Develop an estimated regression equation in Excel with the amount of television advertising as the independent variable
2. Develop an estimated regression equation in Excel with both television advertising and newspaper advertising as the independent variables
3. Develop an estimated regression equation in Excel with all three independent variables: television advertising, newspaper advertising, and radio advertising
4. Is the estimated regression equation coefficient for television advertising expenditures the same in par a), in part b) and in part c)? Interpret the coefficient in each case
5. Obtain and compare the multiple coefficient of determination and the adjusted multiple coefficient of determination for parts a), b) and c). How does the coefficient of determination changes as a result of adding more independent variables in the equation?
6. What is the estimate of the weekly gross revenue for a week when $3500 is spent on television advertising, $1800 is spent on newspaper advertising, and $350 in radio advertising?

I ONLY need help with D through F. Please show how to do in Excel. Thank you!!

For the decision problem in Figure 6.1, use data tables to perform the following sensitivity analyses. The goal in each is to see whether decision 1 continues to have the largest EMV. In each part, provide a brief explanation of the results.

a. Let the payoff from the best outcome, the value in cell A3, vary from $30,000 to $50,000 in increments of $2500.

b. Let the probability of the worst outcome for the first decision, the value in cell B5, vary from 0.7 to 0.9 in increments of 0.025, and use formulas in cells B3 and B4 to ensure that they remain in the ratio 1 to 2 and the three probabilities for decision 1 continue to sum to 1.

c. Use a two-way data table to let the inputs in parts a and b vary simultaneously over the indicated ranges.

Please provide solution as per Excel.

10. The director of the project wants to test if the weight of wood needed for cooking with the improved stove is significantly less than the weight of wood needed for cooking with the old stove.

A. What are the appropriate hypotheses for this test? Note: Consider the intended test in context of the reduction variable.

B. Based only on the previous parts, which of the following options is true for the value of the p-value for this test? a. The p-value is less than 0.05. b. The p-value is less than 0.10. c. The p-value is greater than 0.05. d. The p-value is greater than 0.10.

C. Based only on the previous parts, is there sufficient evidence to reject the null hypothesis at the 10% level of significance? Explain.

D. Based only on the previous parts, state the appropriate conclusion of the test in context.

E. Interpret the level of significance, α = 0.1, in context.

F. What is the power of this test using the pilot study design to detect an improvement of 0.3 kg? G. Based on the result from part F., what is the probability of a Type II error? please help!

You may assume that the conditions needed for inference to be reliable are satisfied. You may assume (based on many similar studies) that the population standard deviation of reduction of firewood used is 0.7 kg

1. An electron, initially moving in the +x-direction enters a uniform magnetic field in the +y-direction. What is the direction of the initial magnetic force on the electron?

2.

A small light source radiates light uniformly in all directions at a rate of 10 W. What is the light intensity at a distance of 2 m from the source?

After buying a computer system, Sim Thomas must decide whether to purchase (1) a complete maintenance (or service) policy at a cost of $500, which would cover all maintenance costs; (2) a partial maintenance policy at a cost of $300, which would cover some of the costs of maintenance; or (3) no maintenance policy. The consequences, costs and probabilities are given in the following table:

Using EMV, what do you recommend?

Internal Control Case Study

Harper Theater is located in Midtown Mall. The cashier’s booth is near the entrance to the theater. Two cashiers are employed. Once works from 1-5 pm, the other from 5-9 pm.   Each cashier is bonded. The cashiers receive cash from customers and operate a machine that ejects serially numbered tickets. The rolls of tickets are inserted and locked into the machine by the theater manager at the beginning of each cashier’s shift.

After purchasing a ticket, the customer takes the ticket to an usher stationed at the entrance to the theater lobby some 60 feet from the cashier’s booth. The usher tears the ticket in half, admits the customer, and returns the ticket stub to the customer. The other half of the ticket is dropped into a locked box by the usher.

At the end of each cashier’s shift, the theater manager removes the ticket roll from the machine and makes a cash count. The cash count sheet is initialed by the cashier. At the end of the day, the manager deposits the receipts in total in a bank night deposit vault located in the mall. The manager also sends copies of the deposit slip and the initialed cash count sheets to the theater company treasurer for verification and to the company’s accounting department. Receipts from the first shift are stored in a safe located in the manager’s office.

Required: using Microsoft Word, answer the following questions and attach the document to this assignment:

1. Identify the internal control procedures and their application to the cash receipts transactions of the Harper Theater. You will find the Internal Control Procedures (Proper documentation, Adequate insurance, Separation of assets from custody, Separation of duties, and Use of technology). For each Internal Control Procedure, identify any Internal Control Procedures that Harper Theater has in place and/or is missing. Be specific and use at least 300 words for your answer.
2. If the usher and cashier decide to collaborate to misappropriate cash, what actions might they take? For each action, what internal control might be employed to stop the misappropriation of cash? Be specific and use at least 200 words for your answer.

DO NOT COPY PREVIOUS ANSWERS THEY ARE INCORRECT