## qnt 275

Part 1
Three hundred consumers between 21 and 49 years old were randomly selected. After sampling a new wine cooler, each was asked to rate the appeal of the phrase: “Not sweet like wine coolers, not filling like beer, and more refreshing than wine or mixed drinks” as it relates to the new wine cooler. The rating was made on a scale from 1 to 5, with 5 representing “extremely appealing” and with 1 representing “not at all appealing”.

As a manager overseeing the development of the concept, you bottle the wine cooler and placed it into distribution in one test store.

Your manager has asked you to assess the data and determine the most likely customer based on the ratings. Additionally, your manager would like you to review sales in the test store.

Use the Week 3 Data Set to create and calculate the following in Excel®:

1. Estimate the probability that a randomly selected 21 to 49 year old consumer:
• Would give the phrase a rating of 5
• Would give the phrase a rating of 3 or higher
• Is in the 21-24 age group
• Is a male who gives the phrase a rating of 4
• Is a 35 to 49 year old who gives the phrase a rating of 1
• Based on the probabilities for the ratings of 4 and 5, which age/gender demographic would be the best target audience for the new concept?
2. Create a probability distribution using the data which shows how many cartons of the wine cooler were bought per customer in a month.
• Calculate the mean and the standard deviation of your probability distribution.
• Calculate the probability that exactly 3 six packs will be bought in a month.
• Calculate the probability that between 4 and 8 six packs will be bought in a month.
• Calculate the probability that at least 5 six packs will be bought in a month.
• Calculate the probability that no more than 5 six packs will be bought in a month.
3. Create a relative frequency distribution based on the wine cooler drinking temperatures.
• Create 6 bins with the same interval in each.
• Create a histogram
4. Considering the mean and standard deviation for the ideal drinking temperature:
• Calculate z values then refer to Table 6.1 – Cumulative Areas Under the Standard Normal Curve
• Calculate the probability of the wine cooler being less than 45 degrees.
• Calculate the probability of the wine cooler being greater than 60 degrees.
• Calculate the percentage of wine coolers served at the ideal temperature, between 49 and 55 degrees.

Part 2

Complete the Week 3 Case in Connect.

Note: You have only 1 attempt available to complete assignments.

### Get Rewriting & Paraphrasing Help!

We have more than 1500 academic writers and we promise 0% plagiarism in your paper.

#### Paper's Detail

 Category Business & Management Paper Type Case Study Writing Reference Type APA Words 360

## Our Online Writers

online

Study Table

Australia

Dear respected Client, I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. …

online

Helping Door

Pakistan

Dear respected Client, I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. …

online

Homework Specialist

United Kingdom

I am an admired writer in all fields of writing with over 5 years of …

## 241

Orders In Progress

### Private and Confidential

Yours all information is private and confidential; it is not shared with any other party. So, no one will know that you have taken help for your Academic paper from us.

## 7025 Total Reviews

4.998 Overall Rating

Order Now

##### Private and Confidential

Client’s all information is private and confidential; it is not shared with any other party. Even, we don’t ask client name and give user name to his/her profile. So, no one will know that you have taken help for your Academic paper from us.

##### Payment Safeguard

We only accept PayPal as our payment method. It is 100% secure. As, We don’t take and store any Credit/Debit card information.

##### Plagiarism Free

It is guaranteed all your Homework/Assignments Solutions are plagiarism free and original. Writers here charge for their efforts not for Copy/Paste work and TOS management takes strict action against those writers.

##### Guaranteed Quality

All the writers working here are recruited and chosen after taking strict evaluation of their Academic degrees, Experience and background. Then, they are allowed to work here as providing quality homework solution is our first priority.

Our website is worldwide forum, where 100s of experts all over the world remain online round a clock, so, you can come at anytime and get the help from any of your homework. Even Urgent within 1 hour!

##### Prices at TutorsOnSpot.com

Prices at tutorsonspot.com are very competitive and low. As, tutorsonspot.com is marketplace so, all the writers bid for getting the work and competition among the writers lowers the price and you get your work done at low minimal prices.

Guarantees

• Our service provides you with original content that does not have plagiarism in it. We are renowned for providing our customers with customized content that is written specifically for them. If you are thinking, can someone help me with my research paper? You can depend on us to help you out.
• Our motto is to meet deadlines and deliver your solution right on time.We understand that you want to save your time and we respect it. Regardless of the difficulty, we deliver an unparalleled solution without any delay. Moreover, you get a money back guarantee in case you are not satisfied with our service. To understand this guarantee, check our terms and conditions related to it.
• We perform a detailed research when writing your paper. With all of our services, we ensure to perform extensive research before creating your solution. Furthermore, if you have any questions, just reach out to our customer service team that is available all the day.
• It is our primary goal to satisfy you. Thus, if you are thinking: can someone write my research paper? Just contact us and get the best services that you can get.

### Best Service for the Struggling Students

##### Services For All Subjects

We have experienced tutors and assignment experts from all over the world for all subjects.

100's of qualified phd tutors round the clock.

##### Best Price Guarantee

Compare our price. Our services are of highest quality and lowest price, Guaranteed.