preview

Finance

Better Essays

Data From Water Park | Type of Guest | % of visitors during peak season | Singles under 25 | 25 | Singles over 25 | 12 | Couples under 25 | 6 | Couples over 25 | 18 | Family groups | 39 |
Statistics Assignment
Part 1

a)
We have obtained the data from both hotel and water park on the basis of number of visitors categorised according to their age groups during peak season. The data has been graphically presented below to compare and see if water park is a suitable excursion place for holiday makers to stay at the hotel.

Data From Hotel | Type of Guest | % of visitors during peak season | Singles under 25 | 17 | Singles over 25 | 9 | Couples under 25 | 3 | Couples over 25 | 20 | Family groups | 51 | …show more content…

In every each band of € 10 increase there is significant drop in number of visitors. This pattern of histogram is positively skewed.

b) Determine by using a spreadsheet model and drawing an ogive, a variety of averages and measures of dispersion.
The calculations was made as shown below using MS Excel. All the calculations are done using excel and excel workbook is also attached at end.

Class Interval(Amount Paid) | Frequency(Number of visitors) | Upper boundary | Cumulative frequency | Cumulative frequency % | MID Point X | X2 | fX | fx2 | 0 | 0 | | 0 | 0 | | | | | 35 - under 45 | 98 | 44.5 | 98 | 33.79310345 | 40 | 1600 | 3920 | 156800 | 45 - under 55 | 74 | 54.5 | 172 | 59.31034483 | 50 | 2500 | 3700 | 185000 | 55 - under 65 | 58 | 64.5 | 230 | 79.31034483 | 60 | 3600 | 3480 | 208800 | 65 - under 75 | 46 | 74.5 | 276 | 95.17241379 | 70 | 4900 | 3220 | 225400 | 75 - under 85 | 14 | 84.5 | 290 | 100 | 80 | 6400 | 1120 | 89600 | Total | 290 | 322.5 | 1066 | | 300 | 19000 | 15440 | 865600 |

List of calculations made, (All the calculations are made in excel and is attached also the value of Median, Q1 and Q3 from the ogive graph generated from excel.
Mean=∑fx/∑f
=

Get Access