Problem 1. Using the data in the xlsx file (attached), create a contingency table (called a Pivot Table in excel) like those in chapter 3. You can use Excel or the apps in artofstat. com. What do you notice from the table? Draw some tentative conclusions.

• What’s the probability of picking a person at random from this sample and having that person be over 50 with normal blood pressure?

• What % of all people are under 30?

• What is the most likely blood pressure for a person over 50?

What kind of variables (quantitative or qualitative) do you have? Could you create a contingency table with different types of variables? Why or why not?

Two pivot tables, one with counts and one with probabilities. Your narrative should include how you created the tables and what you observe.

Explain the difference between counts and probabilities.

A chart that shows the relationship between the two variables. Your narration should include why you chose the chart you did.

Answers to the probability questions including how you calculated the probabilities that you did.