Looking for reliable answers? Westonci.ca is the ultimate Q&A platform where experts share their knowledge on various topics. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.
Since vacation travel is a discretionary expense, consumers want to make the most out of the money they have budgeted. They often check travel
websites for hotel ratings before making any reservations. A popular travel website offers travelers the opportunity to rate a hotel experience based on
five categories: Excellent, Very Good, Average, Poor, and Terrible. Use the spreadsheet to answer the questions below.
1
2
3
4
5
6
7
A
Rating
Excellent
Very Good
Average
Poor
Terrible
Total
B
Frequency
491
448
144
40
27
1150
C
Relative
Frequency
0.427
0.390
0.125
0.05
0.023
D
Cumulative
Frequency
491
939
1083
1123
1150
E
Relative
Cumulative
Frequency
0.427
0.817
0.942
0.977
1.000
Write the spreadsheet formula that was used to calculate the amount in cell B7.
Write the spreadsheet formula that was used to calculate the amount in cell C3.
Write the spreadsheet formula that was used to calculate the amount in cell D5. (there are two possible formulas, include both in your answer pacing
the word "or" between them)
Write the spreadsheet formula that was used to calculate the amount in cell E6.
What percentage of the reviews were "Poor" as indicated by the amount in cell C5?
What is the number of reviews that were "Average" or better as indicated by the amount in cell D4?
What percentage of the reviews were "Very Good" or better as indicated by the amount in cell E3?
