Can you help me with this in excel please A marketing firm is advising a client on their display advertising strategy. The client wants to knowhow best to target a display campaign based on device. Choice of device results in differentadvertising fees. Therefore, the client wants to know how to allocate their advertising budget. Asurvey of 1000 adult internet users matching the firms target market found 810 own adesktop, 950 own a smartphone, 570 own a tablet, and 90 own a smart watch. Theirconsultant suggests a 50/50 split of the budget between desktops and smart phones. Is thisrecommendation justified? Test whether the proportions for desktop and smart phone usersare statistically equal? (a = .05).

Name: Can you help me with this in excel please A marketing firm is advising
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Can you help me with this in excel please A marketing firm is advising a client on their display advertising strategy. The client wants to knowhow best to target a display campaign based on device. Choice of device results in differentadvertising fee

State the appropriate hypothesis: Let p1 be the population proportion of desktop users. Let p2 be the population proportion of smartphone users. The researcher’s objective is to test whether there is any significant difference between the proportion of desktop users and smartphone users. The hypotheses are given below: Null hypothesis: H0 : p1 = p2 That is, there is no significant difference between the desktop users and smartphone users. Alternative hypothesis: Ha : p1 ≠ p2 (Two tailed test) That is, there is a significant difference between the desktop users and smartphone users.Compute the sample proportions: It is given that among a sample of 1000 adult internet users, 810 own a desktop. The sample size is n1 = 1000. The number of specified characteristics is x1 = 810. The sample proportion of desktop users is p1^ = 810/1000 = 0.81. It is given that among a sample of 1000 adult internet users, 950 own a smartphone. The sample size is n2 = 1000. The number of specified characteristics is x2 = 950. The sample proportion of smartphone users is p2^ = 950/1000 = 0.95. Obtain the pooled estimate of proportion: Here, n1 = n2 = 1000, x1 = 810, x2 = 950. The pooled estimate of proportion is obtained as 0.88 from the calculation given below: Obtain the test statistic value: Here, (π1– π2) = 0, p1^ = 0.81, p2^ = 0.95, n1 = n2 = 1000. The test statistic value is obtained as -9.655 from the calculation given below: Obtain the critical value: The level of significance value is α = 0.05. The critical value corresponding to the 95% confidence level is obtained as z(α/2) = ±1.96 from the calculation given below: Since, the normal distribution is symmetric, the two critical values are –z(α/2) = -.196 and +z(α/2) = +1.96. P-value: The P-value is obtained as given below: Therefore, the P-value is 0. The level of significance is 0.05.Decision rule based on critical approach: If z ≤ –z(α/2) (or) z ≥ z(α/2), then reject the null hypothesis H0. If –z(α/2) < z < z(α/2), then fail to reject the null hypothesis H0. Conclusion: Conclusion based on critical value approach: The test statistic value is -9.655 and critical value is ±1.96. Here, z ≤ –z(α/2). That is, -9.655 (= z) < -1.96 (= -z(α/2)). Thus, the test statistic is in the critical region. By the rejection rule, reject the null hypothesis H0. That is, there is a significant difference between the desktop users and smartphone users. There is no sufficient evidence to support the claim that the proportions for desktop and smartphone users are statistically equal.