QNT/275 Apply: Connect Week 3 Case

PLEASE FOLLOW INSTRUCTIONS...READ ALL INSTRUCTION....COMPLETE EXCEL SPREAD SHEET THAT I HAVE UP LOADED....MUST BE DONE IN 5HRS....ALL ORGINAL WORK...   Part 1 Three hundred consumers between 21 and 49 years old were randomly clarified. After sampling a new wine cooler, each was asked to trounce the accost of the turn: "Not dulcet love wine coolers, not satisfaction love beer, and further refreshing than wine or partial drinks" as it relates to the new wine cooler. The rating was made on a lamina from 1 to 5, after a while 5 representing "extremely accosting" and after a while 1 representing "not at all accosting". As a supervisor overseeing the bud of the concept, you bottle the wine cooler and placed it into dispensation in one trial ammunition. Your supervisor has asked you to assess the facts and indicate the most lovely customer inveterate on the ratings. Additionally, your supervisor would love you to reconsideration sales in the trial ammunition. Use the Week 3 Facts Set to beget and count the subjoined in Excel®: Estimate the likelihood that a randomly clarified 21 to 49 year old consumer: Would concede the turn a rating of 5 Would concede the turn a rating of 3 or higher Is in the 21-24 age group Is a manful who concedes the turn a rating of 4 Is a 35 to 49 year old who concedes the turn a rating of 1 Based on the probabilities for the ratings of 4 and 5, which age/gender demographic would be the best target auditory for the new concept?  Create a likelihood dispensation using the facts which shows how divers cartons of the wine cooler were bought per customer in a month.  Calculate the moderation and the criterion derangement of your likelihood dispensation.  Calculate the likelihood that precisely 3 six packs succeed be bought in a month. Calculate the likelihood that between 4 and 8 six packs succeed be bought in a month. Calculate the likelihood that at moderationest 5 six packs succeed be bought in a month. Calculate the likelihood that no further than 5 six packs succeed be bought in a month.  Create a not-absolute quantity dispensation inveterate on the wine cooler drinking latitudes.  Create 6 bins after a while the identical space-between in each.  Create a histogram Considering the moderation and criterion derangement for the creative drinking latitude:  Calculate z values then advert to Table 6.1 - Cumulative Areas Under the Criterion Normal Curve  Calculate the likelihood of the wine cooler substance short than 45 degrees. Calculate the likelihood of the wine cooler substance senior than 60 degrees. Calculate the percentage of wine coolers served at the creative latitude, between 49 and 55 degrees. Part 2 Reference your Excel® spreadsheet from Part 1. Complete the Week 3 Case in Connect. Note: You own singly 1 violate adapted to perfect assignments.