• Please include the formula or show the steps to find the answers.

1. Lets assume that you would like to invest in stock. The following is the year-by-year returns of two companies.

Year	Return (Company A)	Return (Company B)
1	5%	8%
2	-15%	10%
3	35%	9%
4	0%	10%
5	25%	10%
6	-10%	12%
7	50%	9%
8	5%	10%
9	10%	9%
10	-5%	12%

1. Using Excel to compute the average return for both stocks over the last 10 years and provide the results. Is there big difference between two stocks?
2. Using Excel to compute the range, sample variance, and sample standard deviation for the two samples and provide the results. Which one you would like to invest and why?
3. Please find the answers for the following questions using Excel. New York City is the most expensive city in the United States for lodging. The mean hotel room rate is $204 per night (USA Today, April 30, 2012). Assume that room rates are normally distributed with a standard deviation of $55.
4. what is the probability that a hotel room costs $225 or more per night?
5. what is the probability that a hotel room costs less than $140 per night?
6. What is the probability that a hotel room costs between $200 and $300 per night?
7. What is the cost of the 20% most expensive hotel rooms in New York City?