Share
Explore BrainMass

Statistics: Averages, percentages, range, variance, standar

1. Ratings for nine places to stay in Europe
Name of Property Country Room Rate Number of Rooms Overall Score
Graveteye Manor England $$ 18 83.6
Villa d' Este Italy $$$$ 166 86.3
Hotel Prem Germany $ 54 77.8
Hotel d' Europe France $$ 47 76.8
Palace Luzern Switzerland $$ 326 80.9
Royal Crescent Hotel England $$$ 45 73.7
Hotel Sacher Austria $$$ 120 85.5
Duc De Bourgogne Belgium $ 10 76.9
Villa Gallici France $$ 22 90.6

From the table above answer the following questions:
a. What is the average number of rooms for the nine hotels?
b. Compute the average overall score.
c. What is the percentage of hotels located in England?
d. What is the percentage of hotels with a room rate of $$?

2. A psychologist developed a new test of adult intelligence. The test was administered to 20 individuals, and the following data were obtained:
114 99 131 124 117 102 106 127 119 115
98 104 144 151 132 106 125 122 118 118
Construct a stem-and-leaf display for the data.

3. Consider a sample with data values of 27, 25, 20, 15, 30, 34, 28, and 25. Compute the following descriptive statistics:
a. Range
b. Interquartile range
c. Variance
d. Standard deviation
e. Coefficient of variation

Solution Summary

The tutorial is attached in Excel.

The strategy and the computations of each of the statistics for questions 1 - 3 are in Excel to make it easy to follow for other similar assignments. Click in cells to see the computations.

$2.19