exam for provide an r program that uses the diabetes xlsx data

1. Read the data into a R dataframe.

2. Create two (2) new variables:

(a) The waist to hip ratio

(b) According to the World Health Organization, a waist-to-hip ratio can be used to assess the risk of developing heart disease. The ranges they suggest are: less than .9 indicates low, between .9 and 1 elevated, and greater than 1 high risk. Using these ranges, create a variable that holds the heart disease risk status for each study participant.

3. Create a pie chart that shows the frequency of the heart risk status of the study participants. 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. Create a horizontal barchart that shows the frequency of the different frame types among the study participants. Make sure the graph has appropriate title, labels, and font size, and make sure the order of the categories in the graph makes sense. Display the frequency of each category on the top of corresponding bar.

5. Create a visual display that displays the frequency of the genders within each heart risk status. Make sure the graph has appropriate title, labels, and font size, and make sure the order of the categories in the graph makes sense.

6. Find the min, max, mean, median, sd, and IQR of the cholesterol/HDL ratio values of the study participants.

7. Create an appropriate graph to display the cholesterol/HDL ratio values of the study participants. Make sure the graph has appropriate title, labels, and font size, and make sure to use appropriate class endpoints.

8. Create a graphical display that compares the cholesterol levels for the different types of body frames. Make sure the graph has appropriate title, labels, and font size, and make sure the order of the categories in the graph makes sense. Does the graph imply that there is a difference in the heart rate between the two groups?

9. Create a visual display that helps you figure out if there is a relationship between the stabilized glucose levels and the waist to hip ratio of a person. Use different symbols/colors to distinguish the gender of a person. Make sure the graph has appropriate title, labels, and font size.