Excel Basic Tasks:

Add a column of data to the set to include the number of children each participant has. $(1$

point$)$

Odd ID numbers have $3$ children

Even ID numbers have $2$ children

Use Custom Sort to organize the worksheet based on Serum Cholesterol from highest to

lowest. $(1$ point$)$

Calculate the mean of all variables $($except $"$ID Number", "Gender", and "Marital Status"$)$ for

each of the following groups: $($A$)$ Married Woman, $($B$)$ Divorced Woman, $($C$)$ Widowed Woman,

and $($D$)$ Single Woman. Create a table that includes all this information. $(1$ point$)$

Making Graphs:

Make a graph to highlight the mean difference in Serum Cholesterol between the $4$ exercise

groups $($i$.$e$.,"$no$"(0),$ "light" $(1),$ "moderate" $(2),$ and "heavy" $(3)$ exercise$).(1$ point$)$

Are people with higher sodium levels likely to have higher systolic blood pressure? Show on a

graph. Add a trendline and display the $y=mx+b$ equation. Write a sentence explaining the results

of the graph. $(1$ point$)$

Create a scatter graph that addresses the following statement: Are people with higher weight

likely to have higher systolic blood pressure? Add a trendline and display the $y=mx+b$ equation.

Write a sentence explaining the results of the graph. $(1$ point$)$

Testable Hypothesis:

Based on your updated version of the healthdata worksheet, come up with your own testable

question $($testable hypothesis$).(1$ point$)$

Your hypothesis must be unique and different from the tasks you previously completed for the

Excel basics and making graphs assignments. $($i$.$e$.,$ you CAN'T investigate that people with

higher sodium levels have higher systolic blood pressure or people that weigh more have higher

systolic blood pressure$).$

Create a figure that addresses your question and briefly $(1-2$ sentences$)$ describe your findings. $(2$

points$)$