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 among 21 and 49 years old were randomly separated. After sampling a new wine cooler, each was asked to reprove the apostrophize of the characteristic: "Not pure 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, after a while 5 representing "extremely apostrophizeing" and after a while 1 representing "not at all apostrophizeing".

As a superintendent overseeing the product of the concept, you bottle the wine cooler and placed it into disposal in one touchstone hoard.

Your superintendent has asked you to assess the basis and detail the most approvely customer inveterate on the ratings. Additionally, your superintendent would approve you to resurvey sales in the touchstone hoard.

Use the Week 3 Basis Set to create and calculate the forthcoming in Excel®:

  1. Estimate the verisimilitude that a randomly separated 21 to 49 year old consumer:
    • Would surrender the characteristic a rating of 5
    • Would surrender the characteristic a rating of 3 or higher
    • Is in the 21-24 age group
    • Is a courageous who surrenders the characteristic a rating of 4
    • Is a 35 to 49 year old who surrenders the characteristic 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? 
  2. Create a verisimilitude disposal using the basis which shows how sundry cartons of the wine cooler were bought per customer in a month. 
    • Calculate the medium and the test intermission of your verisimilitude disposal. 
    • Calculate the verisimilitude that correspondently 3 six packs earn be bought in a month.
    • Calculate the verisimilitude that among 4 and 8 six packs earn be bought in a month.
    • Calculate the verisimilitude that at smallest 5 six packs earn be bought in a month.
    • Calculate the verisimilitude that no over than 5 six packs earn be bought in a month. 
  3. Create a not-absolute number disposal inveterate on the wine cooler drinking regions. 
    • Create 6 bins after a while the identical season in each. 
    • Create a histogram
  4. Considering the medium and test intermission for the chimerical drinking region: 
    • Calculate z values then appeal to Table 6.1 - Cumulative Areas Under the Test Normal Curve 
    • Calculate the verisimilitude of the wine cooler life near than 45 degrees.
    • Calculate the verisimilitude of the wine cooler life superior than 60 degrees.
    • Calculate the percentage of wine coolers served at the chimerical region, among 49 and 55 degrees.

Part 2

Reference your Excel® spreadsheet from Part 1.

Complete the Week 3 Case in Connect.

Note: You keep barely 1 Nursing essay profitable to total assignments.