The Ministry of Tourism in Trinidad and Tobago is interested in developing a campaign to increase the number of visitors to the island. The Ministry in collaboration with the island’s hotels collected data to be used as a guide to determine what steps should be taken going forward. Using the data in the Microsoft Excel file attached you are required to use the knowledge you have acquired during the semester to answer the following question. Ensure that your responses are detailed and all the necessary steps are clearly outlined. Please note that JASP should only be used if stated in the question. The Description of the variables in the data set is given below Name Description ID Visitor Number (1-150) Length_stay Length of stay in the island (days) Age_years Age of visitor (years) Return_pct Average estimated probability of returning to the island Attraction Number of attractions visited in the island Trip_ratio Number of trips taken off the resort Spending Average money spent during visit (US$) Region_num Geographic region : 1 = North East, 2 = North Central, 3 = South, 4 = West Rating Rating of the property visited (1 – 5) Visit_decision Factor determining visit : 1 = Cost, 2 = Distance, 3 = Attractions, 4 = Other Return_pct Spending 0.85 3476 0.07 2587 0.73 1717 0.39 2337 0.73 2885 0.03 3586 0.96 1113 0.94 2025 0.41 1078 0.41 4251 0.88 4711 0.26 4154 0.68 4307 0.07 3484 0.58 3547 0.51 4503 0.31 3866 0.09 2219 0.84 2011 0.59 2891 0.97 1990 0.02 3193 0.23 1784 0.01 4609 0.25 1138 0.70 4923 0.50 4496 0.67 4177 0.80 3547 0.28 3238 0.26 3627 0.19 4442 0.63 1137 0.39 2728 0.76 1905 0.85 3146 0.42 2077 0.31 4136 0.95 1727 0.03 2779 0.27 3102 0.68 4601 0.45 2524 0.90 3784 0.01 1978 0.20 1520 0.02 4435 0.72 1616 0.73 2692 0.91 2967 0.19 2604 0.52 4941 0.36 2396 0.31 1451 0.96 4133 0.31 4166 0.65 4412 0.46 4648 0.97 1227 0.15 4837 0.40 4608 0.22 2826 0.43 1688 0.45 2521 0.75 3608 0.93 1240 0.15 2773 0.43 2917 0.65 1899 0.69 3773 0.56 3045 0.54 2693 0.49 4826 0.51 3660 0.24 2716 0.21 2751 0.99 1859 0.01 3931 0.16 3134 0.46 1847 0.60 4303 0.37 4757 0.35 2421 0.24 2218 0.20 2407 0.56 2910 0.47 3815 0.29 2193 0.02 2355 0.41 4717 0.51 2883 0.16 4622 0.18 1863 0.40 1230 0.99 4310 0.17 4629 0.64 3513 0.58 2529 0.10 2922 0.86 1511 0.06 1499 0.18 3580 0.76 1589 0.15 1039 0.85 3581 0.72 1586 0.01 3388 0.08 2647 0.29 2073 0.32 4276 0.03 1192 0.63 1872 0.34 4225 0.37 3319 0.24 2589 0.3 2898 0.62 2797 0.77 1941 0.94 4928 0.79 4468 0.59 2830 0.48 3874 0.75 1482 0.5 1043 0.82 1275 0.39 2943 0.24 4461 0.8 4742 0.58 3208 0.64 2962 0.46 3308 0.6 3556 0.02 4251 0.2 4612 0.62 4531 0.7 1396 0.24 1647 0.19 4404 0.35 4954 0.12 3227 0.25 4471 0.46 1662 0.51 3753 0.81 2502 0.05 4604 0.07 1451 0.15 2507 0.03 3373 0.66 1244 0.85 4468 Derive a model for the estimation of the probability of returning to the island from the average money spent during the visit.
The Ministry of Tourism in Trinidad and Tobago is interested in developing a campaign to increase the number of visitors to the island. The Ministry in collaboration with the island’s hotels collected data to be used as a guide to determine what steps should be taken going forward. Using the data in the Microsoft Excel file attached you are required to use the knowledge you have acquired during the semester to answer the following question. Ensure that your responses are detailed and all the necessary steps are clearly outlined.
Please note that JASP should only be used if stated in the question.
The Description of the variables in the data set is given below
Name |
Description |
ID |
Visitor Number (1-150) |
Length_stay |
Length of stay in the island (days) |
Age_years |
Age of visitor (years) |
Return_pct |
Average estimated probability of returning to the island |
Attraction |
Number of attractions visited in the island |
Trip_ratio |
Number of trips taken off the resort |
Spending |
Average money spent during visit (US$) |
Region_num |
Geographic region : 1 = North East, 2 = North Central, 3 = South, 4 = West |
Rating |
Rating of the property visited (1 – 5) |
Visit_decision |
Factor determining visit : 1 = Cost, 2 = Distance, 3 = Attractions, 4 = Other |
Return_pct | Spending |
0.85 | 3476 |
0.07 | 2587 |
0.73 | 1717 |
0.39 | 2337 |
0.73 | 2885 |
0.03 | 3586 |
0.96 | 1113 |
0.94 | 2025 |
0.41 | 1078 |
0.41 | 4251 |
0.88 | 4711 |
0.26 | 4154 |
0.68 | 4307 |
0.07 | 3484 |
0.58 | 3547 |
0.51 | 4503 |
0.31 | 3866 |
0.09 | 2219 |
0.84 | 2011 |
0.59 | 2891 |
0.97 | 1990 |
0.02 | 3193 |
0.23 | 1784 |
0.01 | 4609 |
0.25 | 1138 |
0.70 | 4923 |
0.50 | 4496 |
0.67 | 4177 |
0.80 | 3547 |
0.28 | 3238 |
0.26 | 3627 |
0.19 | 4442 |
0.63 | 1137 |
0.39 | 2728 |
0.76 | 1905 |
0.85 | 3146 |
0.42 | 2077 |
0.31 | 4136 |
0.95 | 1727 |
0.03 | 2779 |
0.27 | 3102 |
0.68 | 4601 |
0.45 | 2524 |
0.90 | 3784 |
0.01 | 1978 |
0.20 | 1520 |
0.02 | 4435 |
0.72 | 1616 |
0.73 | 2692 |
0.91 | 2967 |
0.19 | 2604 |
0.52 | 4941 |
0.36 | 2396 |
0.31 | 1451 |
0.96 | 4133 |
0.31 | 4166 |
0.65 | 4412 |
0.46 | 4648 |
0.97 | 1227 |
0.15 | 4837 |
0.40 | 4608 |
0.22 | 2826 |
0.43 | 1688 |
0.45 | 2521 |
0.75 | 3608 |
0.93 | 1240 |
0.15 | 2773 |
0.43 | 2917 |
0.65 | 1899 |
0.69 | 3773 |
0.56 | 3045 |
0.54 | 2693 |
0.49 | 4826 |
0.51 | 3660 |
0.24 | 2716 |
0.21 | 2751 |
0.99 | 1859 |
0.01 | 3931 |
0.16 | 3134 |
0.46 | 1847 |
0.60 | 4303 |
0.37 | 4757 |
0.35 | 2421 |
0.24 | 2218 |
0.20 | 2407 |
0.56 | 2910 |
0.47 | 3815 |
0.29 | 2193 |
0.02 | 2355 |
0.41 | 4717 |
0.51 | 2883 |
0.16 | 4622 |
0.18 | 1863 |
0.40 | 1230 |
0.99 | 4310 |
0.17 | 4629 |
0.64 | 3513 |
0.58 | 2529 |
0.10 | 2922 |
0.86 | 1511 |
0.06 | 1499 |
0.18 | 3580 |
0.76 | 1589 |
0.15 | 1039 |
0.85 | 3581 |
0.72 | 1586 |
0.01 | 3388 |
0.08 | 2647 |
0.29 | 2073 |
0.32 | 4276 |
0.03 | 1192 |
0.63 | 1872 |
0.34 | 4225 |
0.37 | 3319 |
0.24 | 2589 |
0.3 | 2898 |
0.62 | 2797 |
0.77 | 1941 |
0.94 | 4928 |
0.79 | 4468 |
0.59 | 2830 |
0.48 | 3874 |
0.75 | 1482 |
0.5 | 1043 |
0.82 | 1275 |
0.39 | 2943 |
0.24 | 4461 |
0.8 | 4742 |
0.58 | 3208 |
0.64 | 2962 |
0.46 | 3308 |
0.6 | 3556 |
0.02 | 4251 |
0.2 | 4612 |
0.62 | 4531 |
0.7 | 1396 |
0.24 | 1647 |
0.19 | 4404 |
0.35 | 4954 |
0.12 | 3227 |
0.25 | 4471 |
0.46 | 1662 |
0.51 | 3753 |
0.81 | 2502 |
0.05 | 4604 |
0.07 | 1451 |
0.15 | 2507 |
0.03 | 3373 |
0.66 | 1244 |
0.85 |
4468 |
Derive a model for the estimation of the probability of returning to the island from the average money spent during the visit.

Trending now
This is a popular solution!
Step by step
Solved in 3 steps









