Question: How to solve part C on excel or stat crunch i mainly want excel tho Scientists investigated the level of caffeine of 16-ounce cups of
How to solve part C on excel or stat crunch i mainly want excel tho

Scientists investigated the level of caffeine of 16-ounce cups of a certain blend of coffee. In one phase of the experiment, cups of this blend of coffee were purchased on six consecutive days from a single specialty coffee shop. The amount of caffeine in each of the six cups (measures in milligrams) is provided in the table below. Complete parts a through d below. 602 356 543 389 350 351 D 3. Suppose the scientists are interested in determining whether the median amount of caffeine in this coffee blend exceeds 350 milligrams. Set up the null and alternative hypotheses of interest. H0: 11 = 350 Ha: n > 350 b. How many of the cups in the sample have a caffeine content that exceeds 350 milligrams? 5 cup(s) (Type a whole number.) c. Assuming that p = 0.5, nd the probability that at least as many of the 6 cups as were counted in part b have caffeine amounts that exceed 350 milligrams. The probability is :|. (Round to three decimal places as needed.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
