California State University East Bay Testing of Hypothesis Using Excel Lab Report Assignment – People with money or education or having criminal charges a

California State University East Bay Testing of Hypothesis Using Excel Lab Report Assignment

– People with money or education or having criminal charges are more likely to win. This was true in 2009 as well as in 2014

– Politics is attracting more and more individuals with money and/or criminal charges.

Q: Test the following hypotheses which may help you to check the above statements the best.

Present them in the language of Null hypotheses, alternate hypotheses, type of test, tails, confidence levels, test statistics, inference etc.

Data:

LokSabha elections data (2014) – Attached file

LokSabha elections data (2009) – Attached file

Hypothesis Formation

**Consider Alpha as 0.05

Please check whether assets of winners are more than assets of losers in 2009.

Please check whether assets of winners are more than assets of losers in 2014.

Attached Data file below.