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.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.2: Representing Data
Problem 22PFA
icon
Related questions
Question

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.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell