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)

For each of the Weight and Calories from Fat variables, answer the following research questions. Consider each heath measures variable individually. Do not try to incorporate both variables into one test for any of the research questions. Remember that required conditions are dependent on the test chosen, so you MUST decide the test for each question BEFORE you check required conditions. There is a separate required conditions for each research question.

a) In terms of each of your assigned health measures (weight, cholesterol level, fat intake, cholesterol intake, calories from fat), 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 of your assigned measures (weight, cholesterol level, fat intake, cholesterol intake, calories from fat)?

c) Do males and females differ in the amount of reduction for each of you assigned measures (weight, cholesterol level, fat intake, cholesterol intake, calories from fat)?

answer should be written in narrative form with appropriate graphs and output included as needed.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.

My two Variables are Weight and Calories from Fat