B C D E 1 Japan England 2 2507 3739 3145 2397 4 4898 2554 5 1852 1266 6 3208 2631 7 3545 2036 8 2856 1588 9 3908 3490 10 3248 2126 11 4520 3006 12 3008 2678 13 2845 2664 14 4014 2051 3609 16 5302 3465 3003 06C2 18 2774 19 3013 3018 20 3178 1898 21 2204 2428 22 24 25 26 27 28 INO DOTO MO 2523 3415 2620 3480 2810 3114 2433 3677 2577 3496 3024 29 2932 2495 05 2856 3465 31 3008 1909 32 33 2094 2590 34 35 2721 Ready 2828 Bimble encounters the following in an article: "It has been reported that the average visitor from Japan spent $3,120 during a trip to the United States, while the average for a visitor from the United Kingdom was $2,654." Assuming that this Excel file (Exam 2 #3.xlsx) contains the survey data underlying these results, use the 0.05 level in helping Bimble examine whether the mean spending for Japanese visitors is significantly higher than that for visitors from the United Kingdom. search 3-1 To help her test this, complete the appropriate Ho and H by filling in the blanks: (Separately fill in the parameter, equality, and value by selecting from the dropdown menu.) Ho: Select H | Select] Select Select Select Select 3-2 What would be the most appropriate critical value (i.e., Zerit of ferit) for this test? Separately fill in the name, sign, and value by selecting from the dropdown menu (for example, Zerit = 1.96). | Select 1 Select Select 3-3 What is the calculated test statistic for this test? "Don't round intermediate calculations. Separately fill in the sign and value by selecting from the dropdown menu. test statistic = Select Select 67F Clear 3-2 What would be the most appropriate critical value (i.e., Zenit of ferit) for this test? Separately fill in the name, sign, and value by selecting from the dropdown menu (for example, Zenit +1.96). = [Select] > [Select] crit > [Select] 3-3 What is the calculated test statistic for this test? *Don't round intermediate calculations. Separately fill in the sign and value by selecting from the dropdown menu. search test statistic = [Select] 3-4 What is the p-value for this test? Select from the dropdown menu: Til [Select] [Select] 13