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 rebuke the accost of the specialty: "Not dulcet love wine coolers, not filling love beer, and past refreshing than wine or adulterated drinks" as it relates to the new wine cooler. The rating was made on a flake from 1 to 5, after a while 5 representing "extremely accosting" and after a while 1 representing "not at all accosting".

As a director overseeing the product of the concept, you bottle the wine cooler and placed it into arrangement in one ordeal stock.

Your director has asked you to assess the basis and enumerate the most lovely customer domiciled on the ratings. Additionally, your director would love you to critique sales in the ordeal stock.

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

  1. Estimate the likelihood that a randomly separated 21 to 49 year old consumer:
    • Would communicate the specialty a rating of 5
    • Would communicate the specialty a rating of 3 or higher
    • Is in the 21-24 age group
    • Is a manful who communicates the specialty a rating of 4
    • Is a 35 to 49 year old who communicates the specialty a rating of 1
    • Based on the probabilities for the ratings of 4 and 5, which age/gender demographic would be the best target conference for the new concept? 
  2. Create a likelihood arrangement using the basis which shows how frequent cartons of the wine cooler were bought per customer in a month. 
    • Calculate the medium and the type discontinuance of your likelihood arrangement. 
    • Calculate the likelihood that correspondently 3 six packs achieve be bought in a month.
    • Calculate the likelihood that among 4 and 8 six packs achieve be bought in a month.
    • Calculate the likelihood that at smallest 5 six packs achieve be bought in a month.
    • Calculate the likelihood that no past than 5 six packs achieve be bought in a month. 
  3. Create a assignring-to number arrangement domiciled on the wine cooler drinking climes. 
    • Create 6 bins after a while the selfselfsame space-betwixt in each. 
    • Create a histogram
  4. Considering the medium and type discontinuance for the imaginary drinking clime: 
    • Calculate z values then assign to Table 6.1 - Cumulative Areas Under the Type Normal Curve 
    • Calculate the likelihood of the wine cooler life close than 45 degrees.
    • Calculate the likelihood of the wine cooler life main than 60 degrees.
    • Calculate the percentage of wine coolers served at the imaginary clime, among 49 and 55 degrees.

Part 2

Reference your Excel® spreadsheet from Part 1.

Complete the Week 3 Case in Connect.

Note: You feel merely 1 attack suited to adequate assignments.