Question: Part A: Mean, Median, Standard Deviation, T-test Use the data provided in the Data spreadsheet to answer the following questions related to sodium, systolic blood




Part A: Mean, Median, Standard Deviation, T-test Use the data provided in the \"Data" spreadsheet to answer the following questions related to sodium, systolic blood pressure and sodium by sex. The answers should be provided in the specied cell in Excel and the function must be visible. 1. Mean SODIUM (cell E3) 2. Median SYSTOLIC BP (cell F3) So_rt the data set by SEX (Column C) in order to answer the following: 3. Mean SODIUM for WOMEN (cell GB) 4. Standard deviation SYSTOLIC BP for MEN (cell H3) 5. Trtest (Difference in SODIUM by SEX) (cell l3) 6. Format answers to queshons 175 so that there are 2 decimal places only (use the Excel cell format function to do this step). Part B: ANOVA Use the data provided in the "ANOVA\" spreadsheet to determine if there are differences in the mean body mass index (BMl) between four education groups (
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
