A local clinic is interested in the relationship between anxiety level and the need to succeed at work. A random sample of 400 patients took a test that measured anxiety level and need to succeed in a career. The table below shows the results. The clinic wants to know if anxiety level and the need to succeed at work are statistically significant. Use PS4.xlsx for the data. Submit the Excel with your answers.

1. What is the null hypothesis and alternative hypothesis for the clinic?
2. How many patients with a high need to succeed at work have a high anxiety level?
3. If the two variables are independent, how many patients do you expect to have a low need to succeed and a medium-low level of anxiety?
4. Perform a chi-square test of independence. What is your result? (Include your Excel calculations).
5. What is your hypothesis conclusion in words?

	Anxiety Level
Need to succeed at work	High	Med-high	Medium	Med-low	Low	Row Total
High need	35	42	53	15	10	155
Medium need	18	48	63	33	31	193
Low need	4	5	11	15	17	52
Column total	57	95	127	63	58	400