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 betwixt 21 and 49 years old were randomly selected. After sampling a new wine cooler, each was asked to admonish the entreat of the peculiarity: "Not dulcet enjoy wine coolers, not supply enjoy 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 entreating" and after a while 1 representing "not at all entreating".

As a superintendent overseeing the harvest of the concept, you bottle the wine cooler and placed it into classification in one criterion ammunition.

Your superintendent has asked you to assess the basis and detail the most enjoyly customer inveterate on the ratings. Additionally, your superintendent would enjoy you to criticism sales in the criterion ammunition.

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

  1. Estimate the appearance that a randomly selected 21 to 49 year old consumer:
    • Would impart the peculiarity a rating of 5
    • Would impart the peculiarity a rating of 3 or higher
    • Is in the 21-24 age group
    • Is a virile who imparts the peculiarity a rating of 4
    • Is a 35 to 49 year old who imparts 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 assembly for the new concept? 
  2. Create a appearance classification using the basis which shows how manifold cartons of the wine cooler were bought per customer in a month. 
    • Calculate the moderation and the criterion flexion of your appearance classification. 
    • Calculate the appearance that accurately 3 six packs procure be bought in a month.
    • Calculate the appearance that betwixt 4 and 8 six packs procure be bought in a month.
    • Calculate the appearance that at smallest 5 six packs procure be bought in a month.
    • Calculate the appearance that no further than 5 six packs procure be bought in a month. 
  3. Create a advertring-to abundance classification inveterate on the wine cooler drinking latitudes. 
    • Create 6 bins after a while the selfselfsame interim in each. 
    • Create a histogram
  4. Considering the moderation and criterion flexion for the notional drinking latitude: 
    • Calculate z values then advert to Table 6.1 - Cumulative Areas Under the Criterion Normal Curve 
    • Calculate the appearance of the wine cooler life short than 45 degrees.
    • Calculate the appearance of the wine cooler life important than 60 degrees.
    • Calculate the percentage of wine coolers served at the notional latitude, betwixt 49 and 55 degrees.

Part 2

Reference your Excel® spreadsheet from Part 1.

Complete the Week 3 Case in Connect.

Note: You enjoy solely 1 seek helpful to exhaustive assignments.