I mainly need help working through what to enter into Excel to simulate the 52 weeks of demand. Weekly demand for golf balls at the Happy Valley Golf Club pro shop is normally distributed with a mean of 23 cases and a standard deviation of 6.5 cases. The club gets a profit of $24 per case. a. Simulate 52 weeks of demand, and calculate the average weekly profit. b. What is the probability that weekly profit will exceed $500?

I mainly need help working through what to enter into Excel to simulate the 52 weeks of demand. Weekly demand for golf balls at the Happy Valley Golf Club pro shop is normally distributed with a mean of 23 cases and a standard deviation of 6.5 cases. The club gets a profit of $24 per case. a. Simulate 52 weeks of demand, and calculate the average weekly profit. b. What is the probability that weekly profit will exceed $500?

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

A bakery owner tabulated sales to 50 customers and obtained the distribution. Find the mean and standard deviation for the data. Sales in dollars Number of customers0.00 – 1, 99 18 2.00 – 3.99 164.00 – 5.99 9 6.00 – 7.99 48.00 – 9.99 3
Students in the psychology department at General State University consumes an average of 7 sodas per day with a standard deviation of 2.5. the distribution is normal. Explain how you would go about answering the following questions (include your answer to the question in your response): How many sodas would an individual at the 75thpercentile drink per day?
Consider an investment whose return is normally distributed with mean of 8% and a standard deviation of 5%. A. Determine the probability of losing money. B.Find the probability of losing money when the standard deviation is equal to 10%.
Assume that women's heights have a distribution that is symmetric and unimodal, with a mean of 64 inches, and the standard deviation is 2.5 inches. Assume that men's heights have a distribution that is symmetric and unimodal, with mean of 73 inches and a standard deviation of 2 inches. a. What women's height corresponds to a z-score of −1.80? b. Professional basketball player Evelyn Akhator is 75 inches tall and plays in the WNBA (women's league). Professional basketball player Draymond Green is 79 inches tall and plays in the NBA (men's league). Compared to his or her peers, who is taller?
K A commuter tallied the time to work for 200 days and found that it resembled a normal curve. The mean time was 50 minutes, and the standard deviation was 2 minutes. For the 200-work-day experiment, find the percent of time commuting to work less than 44 minutes. 44 Minutes to Commute to Office 1 46 48 68%- 95% 99/7% 50
Use the normal distribution of SAT critical reading scores for which the mean is 514 and the standard deviation is 115. Assume the variable x is normally distributed. (a) What percent of the SAT verbal scores are less than 650? (b) If 1000 SAT verbal scores are randomly selected, about how many would you expect to be greater than 550? Click to view page 1 of the standard normal table. LOADING... Click to view page 2 of the standard normal table. LOADING... Question content area bottom Part 1 (a) Approximately 1.181.18% of the SAT verbal scores are less than 650. (Round to two decimal places as needed.) Part 2 (b) You would expect that approximately 0.880.88 SAT verbal scores would be greater than 550. (Round to the nearest whole number as needed.)
C.28. A car dealership records the number of cars sold each month and finds the mean =56 and the standard deviation =8.2. What does a standard deviation of 8.2 mean?
The average number of milligrams (mg)of cholesterol in a cup of certain brand of rice is 660 mg,the standard deviation is 35 mg.assume the variable is normally distributed .if a sample of 10 cups of ice cream is selected what is probable that the mean of the sample will be larger than 670 mg? Solution (Box your final answer)
In an Algebra class, the scores on a test are normally distributed. The middle 68% of the scores fall between 69 and 81. What are the mean and standard deviation for this data? Standard Normal Curve Mean: Standard Deviation:
The Internal Revenue Service reports that the mean federal income tax paid in the year 2010 was $8040. Assume that the standard deviation is $4900. The IRS plans to draw a sample of 1000 tax returns to study the effect of a new tax law. Do you think it would be unusual for an individual to pay a tax of less than $7800? Explain. Assume the variable is normally distributed. Round the answer to at least four decimal places.