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 rate the accost of the turn: "Not musical relish wine coolers, not satisfaction relish beer, and over refreshing than wine or qualified 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 overseer overseeing the fruit of the concept, you bottle the wine cooler and placed it into arrangement in one experience treasury.

Your overseer has asked you to assess the axioms and individualize the most relishly customer grounded on the ratings. Additionally, your overseer would relish you to criticism sales in the experience treasury.

Use the Week 3 Axioms Set to create and calculate the subjoined in Excel®:

  1. Estimate the appearance that a randomly selected 21 to 49 year old consumer:
    • Would confer the turn a rating of 5
    • Would confer the turn a rating of 3 or higher
    • Is in the 21-24 age group
    • Is a virile who confers the turn a rating of 4
    • Is a 35 to 49 year old who confers 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 parley for the new concept? 
  2. Create a appearance arrangement using the axioms which shows how sundry cartons of the wine cooler were bought per customer in a month. 
    • Calculate the moderation and the scale dissolution of your appearance arrangement. 
    • Calculate the appearance that correspondently 3 six packs conciliate be bought in a month.
    • Calculate the appearance that betwixt 4 and 8 six packs conciliate be bought in a month.
    • Calculate the appearance that at last 5 six packs conciliate be bought in a month.
    • Calculate the appearance that no over than 5 six packs conciliate be bought in a month. 
  3. Create a associatering-to abundance arrangement grounded on the wine cooler drinking weathers. 
    • Create 6 bins after a while the corresponding season in each. 
    • Create a histogram
  4. Considering the moderation and scale dissolution for the imaginative drinking weather: 
    • Calculate z values then associate to Table 6.1 - Cumulative Areas Under the Scale Normal Curve 
    • Calculate the appearance of the wine cooler entity hither than 45 degrees.
    • Calculate the appearance of the wine cooler entity important than 60 degrees.
    • Calculate the percentage of wine coolers served at the imaginative weather, betwixt 49 and 55 degrees.

Part 2

Reference your Excel® spreadsheet from Part 1.

Complete the Week 3 Case in Connect.

Note: You feel solely 1 endeavor helpful to accomplished assignments.