Have to answer the questions from the document
I’m attaching doc file(Final_Questions).
have to answer all questions in excel.
Each question should be answered in separate sheet.
Q#339 – The Netherlands is one of the world leaders in the production and sale of tulips. Suppose the heights of the tulips in the greenhouse of Rotterdam’s Fantastic Flora follow a continuous uniform distribution with a lower bound of 7 inches and an upper bound of 16 inches. You have come to the greenhouse to select a bouquet of tulips, but only tulips with a height greater than 10 inches may be selected.
What is the probability that a randomly selected tulip is tall enough to pick?
Q#226 – Akiko Hamaguchi, manager of a small sushi restaurant, Little Ginza, in Phoenix, Arizona, has to estimate the daily amount of salmon needed.
Akiko has estimated the daily consumption of salmon to be normally distributed with a mean of 12 pounds and a standard deviation of 3.2 pounds.
Buying 20 lbs of salmon every day has resulted in too much wastage.
Therefore, Akiko will buy salmon that meets the daily demand of customers on 90% of the days.
Based on this information, Akiko would like to:
A. Calculate the proportion of days that demand for salmon at Little Ginza was above her earlier purchase of 20 pounds.
B. Calculate the proportion of days that demand for salmon at Little Ginza was below 15 pounds.
C. Determine the amount of salmon that should be bought daily so that it meets demand on 90% of the days
Q#3 The U.S. Department of Transportation maintains statistics for mishandled bags per 1,000 airline passengers. In a recent month, airlines had 2.77 mishandled bags per 1,000 passengers. What is the probability that in the next 1,000 passengers, airlines will have?
(a) no mishandled bags?
(b) at least one mishandled bag? (c) at least two mishandled bags?
How do prices at online grocers compare to prices at supermarkets? A market basket of 14 items was purchased with the following results:
Source: Data extracted from G. A. Fowler, “Price Check: Do Online Grocers Beat Supermarkets?” The Wall Street Journal, 8 January 2014, p. D1–D2.
For supermarkets and online grocers separately,
(a) Compute the mean and median.
(b) Compute the variance, standard deviation, and range.
(c) Based on the results of (a) and (b), what conclusions can you reach concerning the cost of a basket of products between online grocers and supermarkets?
Q#225 – At a convenience store in Morganville, New Jersey, the manager randomly inspects five mangoes from a box containing 20 mangoes for damages due to transportation. Suppose the chosen box contains exactly 2 damaged mangoes.
What is the probability that one out of five mangoes used in the inspection are damaged?
Q#334 – The manager at a water park constructed the following frequency distribution to summarize attendance for 60 days in July and August
|1000 up to 1250||5|
|1250 up to 1500||6|
|1500 up to 1750||10|
|1750 up to 2000||20|
|2000 up to 2250||15|
|2250 up to 2500||4|
1. Calculate mean attendance
2. Calculate the variance and the standard Deviation
Q#220 – Samantha Greene, a college senior, contemplates her future immediately after graduation. She thinks there is a 25% chance that she will join the Peace Corps and a 35% chance that she will enroll in a full-time law school program in the United States.
What is the probability that she does not choose either of these options?
Q#223 – According to data from the National Health and Nutrition Examination Survey, 33% of white, 49.6% of black, 43% of Hispanic, and 8.9% of Asian women are obese. In a representative town, 48% of women are white, 19% are black, 26% are Hispanic, and the remaining 7% are Asian.
a. Find the probability that a randomly selected woman in this town is obese.
b. Given that a woman is obese, what is the probability that she is white?
c. Given that a woman is obese, what is the probability that she is black?
d. Given that a woman is obese, what is the probability that she is Asian?
Q#440 – Butterfly wings: Do larger butterflies live longer? The wingspan (in millimeters) and the lifespan in the adult state (in days) were measured for 22 species of butterfly. Following are the results.
a. Construct a scatterplot of the lifespan (y) versus the wingspan (x).
b. Compute the correlation coefficient between wingspan and lifespan.