provide an r program that uses the retinol xlsx data to do the following

/in /by

1. Read the data into a R dataframe.

2. Use an appropriate statistical procedure to check if there is a difference in the Plasma beta-carotene levels between the two genders. Provide appropriate graphical displays to check the assumptions of the method you used. Make sure the graph has appropriate title, labels, and font size, and make sure the order of the categories in the graph makes sense.

3. Use an appropriate statistical procedure to check if there is a relationship (difference) between the calory intake of a person and their smoking habits. Provide appropriate graphical displays to check the assumptions of the method you used. Make sure the graph has appropriate title, labels, and font size, and make sure the order of the categories in the graph makes sense.

4. Use an appropriate statistical procedure to check if there is a relationship between the gender of a person and their smoking habits.

5. Use the data to built a model that can be used to predict a person’s Plasma Retinol levels from al remaining factors.

(a) Provide appropriate graphical displays to check the assumptions of the method you used. Make sure the graph has appropriate title, labels, and font size, and make sure the order of the categories in the graph makes sense.

(b) Have the assumptions of the method been met?

(c) Are all the variables you used important for predicting a person’s Plasma Retinol levels? Yes, No? Which ones? Explain your answer.

6. Use a method that will allow you to remove from the model variables that are not relevant/significant.

(a) Provide appropriate graphical displays to check the assumptions of the method you used. Make sure the graph has appropriate title, labels, and font size, and make sure the order of the categories in the graph makes sense.

(b) Have the assumptions of the method been met?

Retinol Data:

AGE: Age (years) SEX: Sex (M,F)

SMOKSTAT: Smoking status (Never, Former, Current)

QUETELET: Quetelet (weight/(height2 ))

VITUSE: Vitamin Use (1=Yes, fairly often, 2=Yes, not often, 3=No)

CALORIES: Number of calories consumed per day

FAT: Grams of fat consumed per day

FIBER: Grams of fiber consumed per day

ALCOHOL: Number of alcoholic drinks consumed per week

CHOLESTEROL: Cholesterol consumed (mg per day)

BETADIET: Dietary beta-carotene consumed (mcg per day)

RETDIET: Dietary retinol consumed (mcg per day)

BETAPLASMA: Plasma beta-carotene (ng/ml)

RETPLASMA: Plasma Retinol (ng/ml)