You are interning at a tourism operator. They have found some files that haven't been finished....

Transcribed Image Text:

You are interning at a tourism operator. They have found some files that haven't been finished. You have been asked to prepare a professional report on the attached data analysis. The data was collected from 656 US tourists visiting New Zealand. Prepare a report that includes a short executive summary, a table of contents, and the analyses and interpretation in a sensible order. For each analysis you should: identify the hypotheses interpret the statistical results, making sure you pay attention to the direction of the scales (see below) given what you know, communicate a managerial interpretation. Try to avoid speculation and stick to what you can know from the data and analysis The variable view of the file is below Q Search application 1 Name segment 2 organise Type Numeric Numeric 9 Width Decimals Label Values Missing Columns Align Measure 8 0 Tourist Segment None None 8 Right Nominal 0 3 active Numeric 9 0 In New Zealand, tourist find things well organized New Zealand is mainly for active people (1, not at all)... None 8 Right Ordinal {1, not at all)... None 8 Right Ordinal 4 paradise Numeric 9 0 5 bungy Numeric 9 0 New Zealand is the last paradise on earth Bungy-jumping {1, not at all)... None 8 Right Ordinal (1, never)... None 8 Right Ordinal 6 maori Numeric 9 0 Maori performances {1, never)... None 8 Right Ordinal 7 walks Numeric 9 0 Walks {1, never)... None 8 Right Ordinal 8 gender Numeric 9 0 gender (1, Female)... None 8 Right Ordinal 9 age Numeric 9 10 Age in years None None 8 Right Scale 10 kids Numeric 9 0 Children living in household. (5, 5 and more)... None 8 Right Ordinal 11 income Numeric 9 total household income before tax per year? (20, Less than $10,000)... None 8 Right Ordinal 12 You've been asked to interpret and make managerially useful the following analyses (in attached file); Who the sample are Describe the sample from the descriptive statistics Chi-square test The tourists were divided into three segments/clusters and some comparisons have been made between the segments; Correlations Correlations have been run (the data is listed as ordinal, but has been treated as interval in this analysis. That is in keeping with standard practice) T tests Two t tests are presented in the papers that have been given to you SPSS output Descriptives Descriptive Statistics N Range Minimum Maximum Mean Std. Deviation Tourist Segment 656 2 1 3 1.98 .696 gender 656 1 1 2 1.46 .499 Age in years 649 74 15 89 54.20 12.981 Children living in 600 5 0 5 .36 .878 household total household income 560 10 20 30 27.28 2.735 before tax per year? Valid N (listwise) 511 Crosstabs Case Processing Summary Cases Valid Missing Total N Tourist Segment gender Percent 656 100.0% N Percent N Percent 0 0.0% 656 100.0% Tourist Segment * gender Crosstabulation gender Female Male Total Tourist Segment 1 Count 68 98 166 2 Expected Count Count 88.8 77.2 166.0 170 168 338 Expected Count 180.9 157.1 338.0 3 Count 113 39 152 Expected Count 81.3 70.7 152.0 Total Count 351 Expected Count 351.0 305 305.0 656 656.0 Chi-Square Tests Asymptotic Significance Value df (2-sided) Pearson Chi-Square 38.423a 2 Correlations Correlations New Zealand is mainly for active people Age in years Children living in household total household income before tax per year? New Zealand is the last paradise on earth In New Zealand, tourist find things well organized ** New Zealand is mainly for Pearson Correlation active people 1 -.075 -.008 .058 .185 .061 Sig. (2-tailed) .056 .843 .171 T-Test Group Statistics Std. Error gender N Mean Std. Deviation Mean Age in years Female 346 53.13 12.868 .692 Male 303 55.43 13.022 .748 Age in years Equal variances assumed Equal variances not assumed T-Test total household income before tax per year? Independent Samples Test Levene's Test for Equality of Variances t-test for Equality of Means 95% Confidence Interval of the Significance F Sig. t df One-Sided p Two-Sided p Mean Difference Std. Error Difference Difference Lower Upper 1.046 .307 -2.258 -2.256 647 633.701 .012 .024 .012 .024 -2.299 -2.299 1.018 1.019 -4.298 -4.300 -.300 -.298 Group Statistics Std. Error gender N Female Male 295 Mean 26.92 Std. Deviation Mean 265 27.69 2.919 2.458 .170 .151 Independent Samples Test Levene's Test for Equality of Variances F Sig. total household income Equal variances assumed 14.809 Value Labels: Value 20 21 Label Less than $10,000 $10,000 19,000 22 $20,000 $29,000 23 $30,000 $39,000 24 $40,000 $49,000 25 $50,000 $59,000 26 $60,000 27 22 28 29 30 $69,000 $70,000 $79,000 - $80,000 $89,000 - $90,000 $99,000 $100,000+ You are interning at a tourism operator. They have found some files that haven't been finished. You have been asked to prepare a professional report on the attached data analysis. The data was collected from 656 US tourists visiting New Zealand. Prepare a report that includes a short executive summary, a table of contents, and the analyses and interpretation in a sensible order. For each analysis you should: identify the hypotheses interpret the statistical results, making sure you pay attention to the direction of the scales (see below) given what you know, communicate a managerial interpretation. Try to avoid speculation and stick to what you can know from the data and analysis The variable view of the file is below Q Search application 1 Name segment 2 organise Type Numeric Numeric 9 Width Decimals Label Values Missing Columns Align Measure 8 0 Tourist Segment None None 8 Right Nominal 0 3 active Numeric 9 0 In New Zealand, tourist find things well organized New Zealand is mainly for active people (1, not at all)... None 8 Right Ordinal {1, not at all)... None 8 Right Ordinal 4 paradise Numeric 9 0 5 bungy Numeric 9 0 New Zealand is the last paradise on earth Bungy-jumping {1, not at all)... None 8 Right Ordinal (1, never)... None 8 Right Ordinal 6 maori Numeric 9 0 Maori performances {1, never)... None 8 Right Ordinal 7 walks Numeric 9 0 Walks {1, never)... None 8 Right Ordinal 8 gender Numeric 9 0 gender (1, Female)... None 8 Right Ordinal 9 age Numeric 9 10 Age in years None None 8 Right Scale 10 kids Numeric 9 0 Children living in household. (5, 5 and more)... None 8 Right Ordinal 11 income Numeric 9 total household income before tax per year? (20, Less than $10,000)... None 8 Right Ordinal 12 You've been asked to interpret and make managerially useful the following analyses (in attached file); Who the sample are Describe the sample from the descriptive statistics Chi-square test The tourists were divided into three segments/clusters and some comparisons have been made between the segments; Correlations Correlations have been run (the data is listed as ordinal, but has been treated as interval in this analysis. That is in keeping with standard practice) T tests Two t tests are presented in the papers that have been given to you SPSS output Descriptives Descriptive Statistics N Range Minimum Maximum Mean Std. Deviation Tourist Segment 656 2 1 3 1.98 .696 gender 656 1 1 2 1.46 .499 Age in years 649 74 15 89 54.20 12.981 Children living in 600 5 0 5 .36 .878 household total household income 560 10 20 30 27.28 2.735 before tax per year? Valid N (listwise) 511 Crosstabs Case Processing Summary Cases Valid Missing Total N Tourist Segment gender Percent 656 100.0% N Percent N Percent 0 0.0% 656 100.0% Tourist Segment * gender Crosstabulation gender Female Male Total Tourist Segment 1 Count 68 98 166 2 Expected Count Count 88.8 77.2 166.0 170 168 338 Expected Count 180.9 157.1 338.0 3 Count 113 39 152 Expected Count 81.3 70.7 152.0 Total Count 351 Expected Count 351.0 305 305.0 656 656.0 Chi-Square Tests Asymptotic Significance Value df (2-sided) Pearson Chi-Square 38.423a 2 Correlations Correlations New Zealand is mainly for active people Age in years Children living in household total household income before tax per year? New Zealand is the last paradise on earth In New Zealand, tourist find things well organized ** New Zealand is mainly for Pearson Correlation active people 1 -.075 -.008 .058 .185 .061 Sig. (2-tailed) .056 .843 .171 T-Test Group Statistics Std. Error gender N Mean Std. Deviation Mean Age in years Female 346 53.13 12.868 .692 Male 303 55.43 13.022 .748 Age in years Equal variances assumed Equal variances not assumed T-Test total household income before tax per year? Independent Samples Test Levene's Test for Equality of Variances t-test for Equality of Means 95% Confidence Interval of the Significance F Sig. t df One-Sided p Two-Sided p Mean Difference Std. Error Difference Difference Lower Upper 1.046 .307 -2.258 -2.256 647 633.701 .012 .024 .012 .024 -2.299 -2.299 1.018 1.019 -4.298 -4.300 -.300 -.298 Group Statistics Std. Error gender N Female Male 295 Mean 26.92 Std. Deviation Mean 265 27.69 2.919 2.458 .170 .151 Independent Samples Test Levene's Test for Equality of Variances F Sig. total household income Equal variances assumed 14.809 Value Labels: Value 20 21 Label Less than $10,000 $10,000 19,000 22 $20,000 $29,000 23 $30,000 $39,000 24 $40,000 $49,000 25 $50,000 $59,000 26 $60,000 27 22 28 29 30 $69,000 $70,000 $79,000 - $80,000 $89,000 - $90,000 $99,000 $100,000+