Westonci.ca offers quick and accurate answers to your questions. Join our community and get the insights you need today. Our platform provides a seamless experience for finding reliable answers from a knowledgeable network of professionals. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.
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?
