Question

i realize that you do not have the excel file in the question but please explain how to solve it

The file testquestions.xlsx contains data on the sales of four products across five provinces for 35 weeks, along with other information on how much money 23 different customers spent on several products using a two tailed test, and a 5% level of significance, the null hypothesis that the average Tablet spending across customers was $75 higher than the average Headphone spending across customers is rejected, with a pvalue of 0.023 and a calculated t-statistic value of-2.108 is not rejected, with a pvalue of 0.043, which is larger than half of alpha is not rejected, with a calculated t-statistic of 0.141 is not rejected, with a calculated pvalue of 2.0738 is rejected, with a calculated t-statistic of 0.01 and a critical value of t0.0197 →

Answer 1

In excel

data -> data analysis-> t-Test: Two-Sample Assuming Equal Variances

select first variable as range of tablet data

second variable as headphone data

Hypothesized difference = 75

check on labels if you selected the variable names in variables range above

you can take alpha = 0.05

click on Ok

now in result

go to t stat (this is test statistic}

p-value for one tail { this is right tailed test}

if p-value < alpha then we reject the null hypothesis