What tests do I need to run?

Nutrition education programs, which teach clients how to lose weight, reduce cholesterol intake, or reduce fat intake through better eating patterns, have been growing in popularity. The nurse in charge of one such program at a local hospital wanted to know whether the programs actually work to improve health measures. A random sample was drawn of 66 clients who attended a nutrition education program.The study recorded the following health measures: weight, cholesterol levels, total dietary fat intake per average day, total dietary cholesterol intake per average day, and percent of daily calories from fat. These data were gathered both before the program started and 3 months after the program. The researcher also determined the clients' genders, ages, and heights. The data are stored in the following way:

Column A: Gender (1 = female; 2 = male)

Column B: Age

Column C: Height (in feet)

Columns D and E: Weight, before and after (in pounds)

Columns F and G: Cholesterol Level, before and after

Columns H and I: Total Dietary Fat Intake per average day, before and after (in grams)

Columns J and K: Dietary Cholesterol Intake per average day, before and after (in milligrams)

Columns L and M: Percent Daily Calories from fat, before and after

(Adapted from Keller, Statistics for Management and Economics)

Each of you should have already received 2 assigned health measures variables. For each of the variables you are assigned, answer the following research questions. Consider each heath measures variable individually. Do not try to incorporate both of your variables into one test for any of the research questions.Also, be aware that you may need to reorganize the data to run the tests and/or create new variables. Remember that required conditions are dependent on the test chosen, so you MUST decide the test for each question BEFORE you check required conditions. You WILL have separate required conditions for each research question!

a) In terms of each of the health measures (weight, cholesterol intake), is there enough evidence to conclude that the program is a success?

b) Can the researchers conclude that age impacts the amount of reduction in each measure (weight, cholesterol intake)?

c) Do males and females differ in the amount of reduction for each measure (weight, cholesterol intake)?

Your answer should be written in narrative form with appropriate graphs and output included as needed and should be submitted in one Word document.Please include page numbers and your name in the document. (I plan to print these, so this helps). I don't use a rubric to grade these. You should use Excel for all your analysis and the p-value criteria to make your decisions.I do not need to see the seven-step hypothesis testing process, but be sure you include everything I specify below:

Your write up must include:

A brief overall introduction describing the case including your chosen alpha. I do not need a detailed justification for your alpha, but it must be stated here.

For each research question, for each of your variables, you must include:

1.A statement of the test chosen and a clear and complete explanation for why you chose that specific test. This needs to be more than simply running through the flowchart steps and must show that you clearly understand why that is the correct choice.

2.Any analysis required to check for outliers.

3.Any analysis required to check the required conditions for your chosen test. Include any histograms or hypothesis tests and your decision based on these tests. (NOTE that if you find that you cannot meet the required conditions for the test you expected to do, you must use the appropriate non-parametric test.

4.A clear statement of your hypotheses, using proper symbols and notation.

5.Your Excel output for the test for each variable pasted into the document with the p-values you used clearly identified

6.A clear statement of your conclusion for each hypothesis test and research question

An overall conclusion pulling everything together.

Gender Age Height Weight 1 Weight 2 Dietary Chol intake 1 Dietary Chol intake 2

1 46 5.59 71.63 136.59 232.70 217.90

1 56 5.57 73.06 154.30 243.29 124.07

1 54 4.90 103.20 117.76 326.33 213.57

1 50 5.03 105.20 165.61 154.21 163.64

2 61 6.01 115.39 206.44 338.76 110.54

1 40 5.76 120.68 143.77 62.66 131.17

1 42 5.30 123.09 120.66 170.49 171.04

1 68 5.53 123.42 190.78 -5.91 4.37

1 64 5.40 126.03 148.42 349.75 123.75

1 40 5.61 127.70 178.54 223.81 137.14

2 42 5.84 128.41 180.38 233.84 218.86

2 68 5.96 130.90 123.20 596.02 96.20

2 69 5.37 137.41 208.30 615.87 32.31

1 44 5.14 139.48 141.44 317.16 191.34

1 49 5.03 140.72 176.17 239.63 174.15

1 37 5.82 141.12 158.39 338.57 181.17

1 64 5.62 141.14 232.18 349.97 171.60

1 54 5.11 141.77 166.08 213.62 115.39

1 35 6.03 144.13 157.28 86.16 246.24

2 50 5.75 146.82 234.65 732.80 242.78

1 55 5.49 147.67 131.64 160.93 134.43

2 35 4.97 149.94 133.86 36.45 265.31

1 37 5.07 151.11 180.82 388.85 -50.61

1 52 5.35 151.23 153.44 136.51 347.42

2 42 5.81 152.29 190.96 74.90 324.51

2 58 5.56 154.93 199.96 191.00 302.56

2 60 4.92 158.53 201.08 116.25 298.73

1 48 5.01 159.52 122.21 88.60 263.77

1 47 5.38 162.03 210.77 388.74 83.10

1 47 5.13 162.93 221.32 153.69 166.95

1 37 5.56 169.41 151.59 198.43 313.37

2 47 5.77 175.33 194.86 -16.76 -98.55

2 57 5.39 175.54 210.96 260.83 1.96

2 50 5.37 177.02 184.02 231.96 134.25

2 35 5.41 180.28 190.29 159.30 -13.31

2 53 5.91 184.58 188.87 194.64 395.50

2 53 5.44 185.51 169.29 397.75 50.23

2 54 5.59 185.57 210.91 201.35 446.84

2 66 5.58 186.25 160.57 215.44 164.64

2 42 5.04 188.03 141.25 -231.35 228.56

1 49 5.18 189.17 141.97 257.57 117.01

2 48 5.68 189.45 172.99 351.51 249.29

2 49 5.44 190.23 162.16 526.01 106.39

1 27 5.38 192.09 202.68 121.88 125.81

2 58 5.75 195.66 149.87 297.48 273.91

2 53 5.46 195.90 177.38 286.59 133.05

2 63 5.84 197.03 172.47 77.78 188.54

2 46 5.05 200.76 108.00 114.57 361.34

2 59 5.55 202.77 219.42 431.08 116.78

2 61 5.40 202.89 190.78 310.06 401.21

1 55 5.42 204.37 162.31 323.05 260.04

1 40 5.57 206.14 145.40 192.40 172.23

1 56 5.26 207.03 209.81 17.45 233.22

2 50 5.23 207.59 211.37 -133.31 348.32

1 45 5.72 207.74 144.36 282.43 68.36

2 55 5.72 207.94 172.53 339.04 -7.08

2 51 5.57 211.34 166.27 347.39 277.28

1 49 5.33 213.61 163.01 125.05 128.19

2 58 5.74 216.90 168.54 224.88 200.41

2 53 6.01 219.37 180.14 428.57 200.92

2 42 6.05 226.33 114.56 582.25 388.13

1 53 5.42 229.00 138.20 124.48 112.03

2 72 5.35 232.82 173.77 577.17 238.28

1 47 5.50 234.91 164.41 250.49 181.73

2 52 5.80 249.76 137.17 612.17 -88.44

1 56 5.77 250.29 132.01 208.93 277.69