Market Analysis and Probability Concepts

This tutorial explores whether a product, Coke Z, sells better than Coke R using a marketing survey. It covers data collection, calculating relative frequency, and visualizing data with charts in Excel. The tutorial also discusses cumulative distribution analysis and concludes with a summary of findings.

What is the main question addressed in this tutorial?

• Will people buy Coke Z over Coke R?

• How to improve the taste of Coke Z?

• How to increase sales of Coke Z?

• What is the best marketing strategy for Coke R?

How many people strongly agree to buy Coke Z over Coke R?

• 150

• 450

• 300

• 600

What is the total number of survey participants?

• 2,500

• 4,000

• 3,000

• 3,500

How is relative frequency calculated?

• By multiplying the number of agreements by total participants

• By adding the number of agreements and disagreements

• By subtracting the number of disagreements from agreements

• By dividing the number of agreements by total participants

What is cumulative probability?

• The probability of a single event

• The sum of probabilities up to a certain point

• The difference between two probabilities

• The average of all probabilities

Which chart is recommended for visualizing categories?

• Scatter plot

• Histogram

• Pie chart

• Line chart

What percentage of people might buy the new Coke?

• 20%

• 80%

• 30%

• 50%

What is the purpose of using a cumulative distribution graph?

• To compare different datasets

• To highlight the highest probability

• To display the sum of probabilities

• To show individual probabilities

What is the final step in the market analysis process?

• Displaying graphs

• Formatting the data

• Creating a table

• Summarizing findings