Three hundred consumers betwixt 21 and 49 years old were randomly clarified. After sampling a new wine cooler, each was asked to rate the invoke of the peculiarity: "Not lovely approve wine coolers, not filling approve beer, and over refreshing than wine or qualified drinks" as it relates to the new wine cooler. The rating was made on a layer from 1 to 5, delay 5 representing "extremely invokeing" and delay 1 representing "not at all invokeing".
As a supervisor overseeing the bud of the concept, you bottle the wine cooler and placed it into division in one criterion accumulation.
Your supervisor has asked you to assess the facts and particularize the most approvely customer domiciled on the ratings. Additionally, your supervisor would approve you to criticism sales in the criterion accumulation.
Use the Week 3 Facts Set to create and calculate the subjoined in Excel®:
Estimate the presumption that a randomly clarified 21 to 49 year old consumer:
Would yield the peculiarity a rating of 5
Would yield the peculiarity a rating of 3 or higher
Is in the 21-24 age group
Is a manful who yields the peculiarity a rating of 4
Is a 35 to 49 year old who yields the peculiarity a rating of 1
Based on the probabilities for the ratings of 4 and 5, which age/gender demographic would be the best target reception for the new concept?
Create a presumption division using the facts which shows how divers cartons of the wine cooler were bought per customer in a month.
Calculate the medium and the banner rupture of your presumption division.
Calculate the presumption that precisely 3 six packs earn be bought in a month.
Calculate the presumption that betwixt 4 and 8 six packs earn be bought in a month.
Calculate the presumption that at mediumest 5 six packs earn be bought in a month.
Calculate the presumption that no over than 5 six packs earn be bought in a month.
Create a not-absolute abundance division domiciled on the wine cooler drinking airs.
Create 6 bins delay the identical interspace in each.
Create a histogram
Considering the medium and banner rupture for the chimerical drinking air:
Calculate z values then advert to Table 6.1 - Cumulative Areas Under the Banner Normal Curve
Calculate the presumption of the wine cooler entity near than 45 degrees.
Calculate the presumption of the wine cooler entity elder than 60 degrees.
Calculate the percentage of wine coolers served at the chimerical air, betwixt 49 and 55 degrees.