Use a Multi Voting template to determine the mode of entertainment for the weekend within a family of 4 people (Father, Mother, Son, Daughter).
Step 3: Specify analysis options
A new worksheet will be added to your workbook. Analysis Setup will be automatically opened, in the setup tab specify the following details.
If you need to make changes to the charts, specify the optional settings in the Charts tab.
Labels:
- Add a title for the chart.
- Label the X-axis and Y-axis appropriately.
Appearance:
- Adjust colors, font sizes, or other visual elements as needed.
- Enable/disable gridlines or background shading.
Step 4: Enter the details in worksheet
Click Create, the worksheet will created and then enter all the details. A sample is provided below:
Click on the Analysis Setup and then click Verify tab to ensure all the inputs are okay and shown in a green checkmark.
Step 5: Generate analysis result
Click Analyze and then click Compute Outputs to get the final results
Interpreting Results
Top Choice - "Eat Out" Wins Majority Votes
- The
option "Eat Out" received the highest number of votes (Sum = 3),
indicating that it is the most preferred entertainment choice for the
weekend among the family members.
Movies and
Bowling as Secondary Preferences
- Both
"Movies" and "Bowling" received a total of 2 votes
each, showing they are moderately preferred alternatives.
Least Preferred
Activities
- "Computer
Games," "Archery," and "Relax at Home" received
only 1 vote each, making them the least popular choices for the weekend
entertainment.
Variation in Voting Preferences (Mean & Standard
Deviation)
- The
mean values range from 0.25 to 0.75, with standard deviations indicating
variability in preference.
- "Eat
Out" has a mean of 0.75, suggesting it was voted on by more members,
whereas "Computer Games," "Archery," and "Relax
at Home" have a mean of 0.25, showing minimal interest.
Graphical
Representation Confirms Trends
- The
bar chart visually confirms that "Eat Out" has the highest
votes, followed by "Movies" and "Bowling," while
"Computer Games," "Archery," and "Relax at
Home" lag behind.
Conclusion:
Decision Based on Majority Vote
- Since
"Eat Out" has the highest votes, the family is likely to choose
this option for their weekend entertainment. If further refinement is
needed, another round of voting could be conducted to finalize among the
top 3 choices.