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.) 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.

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

Related questions

Question

100%

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.

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Expert Solution