Answer this question on Excel.

14% of Canadian are worry the war in Ukraine one month ago. Suppose you interview people on the street today, 500 people on the street answered your question about the Ukraine war. You are using this information to determine whether the Canadian are more worry about the war than one month ago.

a) Formulate the hypothesis that can be used to determine whether the Canadian are more worry about the war than one month ago.

b) If the sample results show that 75. of the Canadian are worry about the war in Ukraine, what is the p-value for your hypothesis test?

C)

At what is your conclusion?

a) The hypothesis will be as follows:

H₀: P = 0.14

H_a: P > 0.14

b) P-value = 0.2597 

c) We fail to reject the null hypothesis and conclude that the Canadians are NOT more worried about the war in Ukraine than one month ago.

Step-by-step explanation

a) The hypothesis will be as follows:

H₀: P = 0.14

H_a: P > 0.14

b) The test statistic is given by the formula;

Z = (p - P)/√(P(1-P)/n)

p = x/n = 75/500 = 0.15

P = 14% = 0.14

So we have;

Z = (0.15 - 0.14)/√(0.14(1-0.14)/500) = 0.644424

The P-value will be given by;

P(Z > 0.644424)

= P(Z < -0.644424)

To obtain the P-value, we enter the following Excel function

=NORM.S.DIST(-0.644424,TRUE)

We get the P-value to be 0.2597 to four decimal places.

c) Since the P-value is larger than the convectional 0.05 significance level, we fail to reject the null hypothesis and conclude that the Canadians are NOT more worried about the war in Ukraine than one month ago.

Please see attached file