Create an Excel Spreadsheet With Tabs
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages Description/Paper Instructions
Create an Excel Spreadsheet With Tabs
Final Excel 2Description / paper instructions
Create an Excel spreadsheet with tabs for each problem. If possible send as soon as finished
1. Suppose you invest in six different stocks. The dollar returns on the investments are normally distributed and each return is independent probabilistically. Assume the mean is $50,000 and standard deviation is $10,000 for each return. There is a 1% chance that the total return on the 6 investment is less than what value?
2. Suppose the distribution of purchase amounts by customers entering a store follows normal distribution with mean $70 and standard deviation $20. Find two dollar amounts, equidistant from the mean, such that 95% of all customer purchases are between these two values.
3. A production process manufactures items with weights that are normally distributed with mean = 12 pounds and standard deviation = 0.1 pounds. The item is considered defective when its weight is less than 11.8 pounds or greater than 12.2 pounds. Suppose the items are produced in batches of 1000 units. Find the probability that at least 95% of the items in a given batch will be acceptable.
4. Suppose the average number of customers arriving a particular CVS for one hour is 5. What is the probability that you have between 6 and 8 customers for next hour?
5. Suppose that the time between successive phone calls to a local bank is 25 seconds on average. If you just got a phone call, what is the probability that you would wait for at least one minute to receive the next call?
6. A family is considering a move from a Midwest City to Virginia. The distribution of housing costs where the family currently lives follows normal distribution, with mean $105,000 and standard deviation $18,200. Suppose the housing cost in VA also has normal distribution with mean of $235,000 and standard deviation $30,400. The family’s current home has a value of $110,000. What percentage of houses in the Midwest City cost less than the family’s current house? What price house will the family need to purchase to be in the same percentile of housing costs in the new city of VA as they are in the current city?