I need help creating an excel document determining rating for a new wine cooler for a statistics class
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.
Please see the attached document with the full details
