15799
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 Data Set to create and calculate the following in Excel
.
