ASSIGNMENT

Using the Sample code book and spreadsheet_Diet Study.xlsx Download Sample code
book and spreadsheet_Diet Study.xlsx follow the directions: IA#3 Summarizing Data in Excel.docx and submit the 4 elements listed below in ONE (1) word doc.
IA#3 Summarizing Data in Excel (3).pdf

1.Create a frequency table and pie chart for the variable gender. Copy/past the table and pie chart in a word doc.

• 2. Perform a t-test (or dependent/paired t-test) to test for a statistically significant
difference between wgt0 (weight at baseline) and wgt4 (weight at 4th follow up).
Copy/paste the output onto the word doc.

• 3 State whether there is a statistically significant difference in an average
weight between baseline and 4 month follow up (alpha <.05) .

4. Create a 2-dimensional column bar graph showing mean pre-test (wgt0), weekly
check-ins (wgt1,wgt2, wgt3) and post-test scores (wgt4). Copy/paste the chart in
the word doc