QBA GROUP TASK 2 – MANAGERIAL REPORT
(BASED ON VISITOR ARRIVALS TO HAWAII - JUNE 2003)

1.0 FOUR MAIN DATA VARIABLES

NUMERIC VARIABLES IMPLICATIONS for HAWAII VISITORS BUREAU
No. of trips to Hawaii (including repeat visits)  Success of tourism promotion
 Hawaii as preferred destination
Total No. of days in Hawaii  Traveler behaviour
 Facilitating tourist spending
NON-NUMERIC VARIABLES
Reason for trip  Package to offer to tourists
 Meeting tourist preferences
Where I plan to stay  Accommodation planning
 Promotions coverage

2.0 DESCRIPTIVE STATS

For the purpose of this report we will focus only on:
 Total No. of days in Hawaii (numeric)
 Reason for Trip (non-numeric)

2.1 Total No. of Days

 Correct average formula is – Total days stayed\Visitors per country
 From our raw data (Grp Task 1) I’ve reduced it to 20 countries (and taken out Taiwan 70\Indonesia 169\Malaysia153 - as these ave. days stayed are too high)

Country Ave.
1. US 1
2. Canada 2
3. Germany 2
4. China 3
5. Australia 3
6. Korea 6
7. UK 7
8. France 8
9. Philippines 8
10. Switzerland 9
11. Brazil 10
12. Japan 12
13. Mexico 14
14. Italy 17
15. Singapore 20
16. Ireland 21
17. Argentina 25
18. Hong Kong 28
19. Thailand 29
20. New Zealand 37
Total – 20countries 262

Measure Calculation Value
Sample mean
(total\n)
262
20 13.1
Median
(sort data in order)
(ave of 10th and 11th) 10th Switzerland
11th Brazil

9+10
2 9.5
Mode
(most common) 2
6
8 Multi-modal
2-6-8
Range
(highest – lowest) 37-1 36
IQR
(inter-quartile range) Q1 (ave 5th and 6th)
= 3+6\2 = 4.5

Q3 (ave 15th and 16th)
= 20+21\2 = 20.5

IQR = 20.5 – 4.5 16

Standard deviation data
No. Data Mean (Data – Mean) (Data – Mean) squared
1 1 13 -12 144
2 2 13 -11 121
3 2 13 -11 121
4 3 13 -10 100
5 3 13 -10 100
6 6 13 -7 49
7 7