Please help me do this case study with explanations with the answers and the calculations on excel CASE STUDY: Ya Ya's Yogurt. Last year Ya Ya Yogurt's decided to enter the flavored yogurt market, and it began cautiously by producing, distributing, and marketing a single flavor—a blueberry-flavored yogurt. The company’s initial venture into the yogurt market has been very successful; sales of blueberry are higher than expected, and consumers’ ratings of the product have a mean of 80 and a standard deviation of 25 on a 100-point scale for which 100 is the most favorable score and zero is the least favorable score. Past experience has also shown Ya Ya's that a consumer who rates one of its products with a score greater than 75 on this scale will consider purchasing the product, and a score of 75 or less indicates that the consumer will not consider purchasing the product. Emboldened by the success and popularity of its blueberry-flavored yogurt, Ya Ya's management is now considering the introduction of a second flavor. Ya Ya's marketing department is pressing to extend the product line through the introduction of a strawberry-flavored yogurt, but senior managers are concerned about whether or not a strawberry option will increase Ya Ya's market share by appealing to potential customers who do not like blueberry. That is, the goal in offering the new product is to increase Ya Ya's market share rather than cannibalize existing sales of blueberry yogurt. The marketing department has proposed giving tastes of both blueberry and strawberry to a simple random sample of 50 customers and asking each of them to rate the two yogurts on the 100-point scale. If the mean score given to blueberry by this sample of consumers is 75 or less, Ya Ya's senior management believes the sample can be used to assess whether strawberry will appeal to potential customers who do not like blueberry. (NOTE: A separate data file is not necessary to perform the following calculations.) Prepare a report that addresses the following: a. Calculate the probability that the mean score of blueberry given by the simple random sample of Ya Ya's customers will be 75 or less. b. If the Marketing Department increases the sample size to 150, what is the probability that the mean score of blueberry given by the simple random sample of Ya Ya's customers will be 75 or less? c. Explain to Ya Ya's senior management why the probability that the mean score of blueberry given by the simple random sample of Ya Ya's customers will be 75 or less is different for these two sample sizes.

Please help me do this case study with explanations with the answers and the calculations on excel

CASE STUDY:

Ya Ya's Yogurt. Last year Ya Ya Yogurt's decided to enter the flavored yogurt market, and it began cautiously by producing, distributing, and marketing a single flavor—a blueberry-flavored yogurt. The company’s initial venture into the yogurt market has been very successful; sales of blueberry are higher than expected, and consumers’ ratings of the product have a mean of 80 and a standard deviation of 25 on a 100-point scale for which 100 is the most favorable score and zero is the least favorable score. Past experience has also shown Ya Ya's that a consumer who rates one of its products with a score greater than 75 on this scale will consider purchasing the product, and a score of 75 or less indicates that the consumer will not consider purchasing the product.

Emboldened by the success and popularity of its blueberry-flavored yogurt, Ya Ya's management is now considering the introduction of a second flavor. Ya Ya's marketing department is pressing to extend the product line through the introduction of a strawberry-flavored yogurt, but senior managers are concerned about whether or not a strawberry option will increase Ya Ya's market share by appealing to potential customers who do not like blueberry. That is, the goal in offering the new product is to increase Ya Ya's market share rather than cannibalize existing sales of blueberry yogurt. The marketing department has proposed giving tastes of both blueberry and strawberry to a simple random sample of 50 customers and asking each of them to rate the two yogurts on the 100-point scale. If the mean score given to blueberry by this sample of consumers is 75 or less, Ya Ya's senior management believes the sample can be used to assess whether strawberry will appeal to potential customers who do not like blueberry. (NOTE: A separate data file is not necessary to perform the following calculations.)