You are developing 4 websites for a firm that advertises to individuals that ten
ID: 3267889 • 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 65Explanation / 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.69Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.