Question

Question 9 (1 point) Questions 6-10 is one hypothesis testing problem using an Excel data called vacation. We want to know if there is a difference between the average individual vacation budget of this year and that of last year. We collected two independent samples of 15 individuals' vacation from each year. We assume population variances are unequal. You already downloaded the data file in Question 6, so you do not have to open it again. Just run a correct tool in the Excel file. but if you want to open it again, click the Excel data file name above. Do we reject the null hypothesis (Ho)? level of significance is 0.05. O a) Yes Ob) No Question 10 (1 point) Questions 6-10 is one hypothesis testing problem using an Excel data called vacation. We want to know if there is a difference between the average individual vacation budget of this year and that of last year. We collected two independent samples of 15 individuals vacation from each year. We assume population variances are unequal. You already downloaded the data file in Question 6, so you do not have to open it again. Just run a correct tool in the Excel file. but if you want to open it again, click the Excel data file name above. Is there evidence of difference? a) No Ob) Yes

Answer 1

we want to know if there is difference between the average individual vacation budget of this year and that of last year

for this use Data Analysis tool in excel for t test: Two sample assuming unequal variances. we get the following table

t-Test: Two-Sample Assuming Unequal Variances Variable 1 1436.733333 830854.3524 15 Variable 2 831.3333333 214026.6667 15 0 Mean Variance Observations Hypothesized Mean df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail 21 2.293795129 0.016109004 1.720742871 0.032218009 2.079613837

from this table it is observed that , that is t-statistic =2.2939 is greater than the two sided critical value. hence it is then concluded that the null hypothesis is rejected.

yes we reject the null hypothesis.

It is concluded that the null hypothesis Ho is rejected. Therefore, there is enough evidence to claim that the average individual vacation budget of this year is different than that of last year​, at the 0.05 significance level.

yes there is evidence of difference.