Looking for trustworthy answers? Westonci.ca is the ultimate Q&A platform where experts share their knowledge on various topics. Explore a wealth of knowledge from professionals across different disciplines on our comprehensive platform. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform.

(Use Excel) The See Me marketing agency wants to determine if time of day for a television advertisement influences website searches for a product. They have extracted the number of website searches occurring during a one-hour period after an advertisement was aired for a random sample of 30 day and 30 evening advertisements. A portion of the data is shown in the accompanying table. Use Table 2. ay Searches Evening Searches 96670 118379 97855 111005 96368 100482 98465 122160 98550 117158 101623 101556 95753 98875 104384 102036 99475 110932 103780 101963 97608 123513 99859 102195 101764 111388 97287 116287 98066 119660 95390 112553 96125 98245 96767 98062 99494 101657 102498 106451 99260 104247 102020 105507 102468 118339 96543 109847 102491 123996 96557 122545 102627 113248 95048 104941 96969 111829 95103 114721 Click here for the Excel Data File

Sagot :

a) The correct option is A

The null hypothesis in the question states that the mean number of website searches does not differ between the day and evening advertisements and the alternative hypothesis states that the mean number of website searches differs between the day and evening advertisements. It can be written as:

[tex]H_{0} :[/tex] μ[tex]_{x}[/tex]-μ[tex]_{y}[/tex] = 0

[tex]H_{a} :[/tex] μ[tex]_{x}[/tex]-μ[tex]_{y}[/tex] ≠ 0

b-1) From the below excel output screenshot the t-test statistical value is I -0.3476.

b-2) From the below excel output the critical t value comes as 2.0017. So, the rejection region includes all the values greater than 2.0017 and less than -2.0017.

c) The calculated t-statistic value is not falling in the rejection region. So we do not reject the null hypothesis.

Do not reject [tex]H_{0}[/tex]. At the 5% significance level, we conclude the mean number of website searches not differ between the day and evening advertisements.

(The below excel screenshot shows the customized formula and the output which is required to find the values required to test the hypothesis.)

To learn more about the hypothesis visit:brainly.com/question/29519577

#SPJ4

View image debjitbhowal4568