[Solved]: Nutrition Education Programs solve using excel with…

Nutrition Education Programs solve using excel with help of data analysis tool kit : Nutrition education programs, which teach clients how to lose weight or reduce cholesterol levels 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. A random sample was drawn of 33 clients who attended a nutrition education program for those with elevated cholesterol levels. The study recorded the 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 and 3 months after the program. The researchers also determined the clients’ genders, ages, and heights. The data are stored in the following way: Column 1: Gender (1 = female, 2 = male) Column 2: Age Column 3: Height (in meters) Columns 4 and 5: Weight, before and after (in kilograms) Columns 6 and 7: Cholesterol level, before and after Columns 8 and 9: Total dietary fat intake per average day, before and after (in grams) Columns 10 and 11: Dietary cholesterol intake per average day, before and after (in milligrams) Columns 12 and 13: Percent daily calories from fat, before and after The nurse would like the following information: a. In terms of each of weight, cholesterol level, fat intake, cholesterol intake, and calories from fat, is the program a success? b. Does gender affect the amount of reduction in each of weight, cholesterol level, fat intake, cholesterol intake, and calories from fat? c. Does age affect the amount of reduction in weight, cholesterol level, fat intake, cholesterol intake, and calories from fat cholesterol?