Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

You are developing 4 websites for a firm that advertises to individuals that ten

ID: 3294511 • Letter: Y

Question

You are developing 4 websites for a firm that advertises to individuals that tend to the Right and Left of the political spectrum. You have interviewed 29 individuals to assess their preferences for 4 websites, as either good or bad. You wonder if there is an association between being either Right or Left leaning (politically) and assessing a site as bad. Develop a contingency table that organizes the Right/Left and bads in the various sites. So, count the joint occurrence of Right/bad and Left/bad for the various sites. (See the table below.) PLEASE LIST ALL STEPS IN ORDER TO COMPLETE THE ASSIGNMENT IN EXCEL. THANK YOU SO MUCH!

1) Create the contingency table to test for independence of the Right/Left variable and the bads assessed at sites. (Hint: the grand-total of bads should equal 65 and the mechanics of the tables were done in the novice/practice problems)

2) Perform the chi-square test. Is there independence between Political Leaning (Right and Left) and bads for the various sites? Use an alpha of 0.05

   Quality Opinion Right/Left Site 1 Site 2 Site 3 Site 4 L good good good bad L good good bad bad R good good good bad L good good bad bad R bad good bad good R bad good bad bad R good bad bad bad L bad bad bad bad R good good bad bad L bad good good bad L good good bad bad R bad good bad bad R good bad good bad L good bad good good L bad bad bad bad R bad bad bad bad R bad good bad bad L good good good bad L good bad good bad L good good good bad L good bad good good L good good good bad R good bad good good R good bad bad bad L good bad bad good L bad bad bad bad R bad bad good bad R bad bad bad bad R good good good bad total "bads"= 11 14 16 24 65

Explanation / Answer

Ans:

Chi square test:

H0:Right /left and bads assets variables are independent.

H1:Right/Left and bad assets variables are not independent.

Expected count=row sum*column sum/overall total

degree of freedom=(2-1)*(4-1)=3

p-value=0.875

As,p-value>0.05,We fail to reject H0.

We have sufficient evidence to conclude that right /left and bads assets variables are independent.

Observed(O) Site 1 Site 2 Site 3 Site 4 Total Left 4 7 7 12 30 Right 7 7 9 12 35 Total 11 14 16 24 65 Expected(E) Site 1 Site 2 Site 3 Site 4 Total Left 5.08 6.46 7.38 11.08 30 Right 5.92 7.54 8.62 12.92 35 Total 11 14 16 24 65 (O-E)^2/E Site 1 Site 2 Site 3 Site 4 Left 0.23 0.04 0.02 0.08 Right 0.20 0.04 0.02 0.07 Total chi square score=0.69
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote