exam for Provide an R program that uses the ”Diabetes.xlsx” data
Question Description
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 ofdeveloping heart disease. The ranges they suggest are: less than .9 indicates low, between .9 and1 elevated, and greater than 1 high risk. Using these ranges, create a variable that holds the heartdisease risk status for each study participant.
3. Create a pie chart that shows the frequency of the heart risk status of the study participants. Makesure the graph has appropriate title, labels, and font size, and make sure the order of thecategories in the graph makes sense.
4. Create a horizontal barchart that shows the frequency of the different frame types among the studyparticipants. Make sure the graph has appropriate title, labels, and font size, and makesure the order of the categories in the graph makes sense. Display the frequency of eachcategory on the top of corresponding bar.
5. Create a visual display that displays the frequency of the genders within each heart risk status. Makesure the graph has appropriate title, labels, and font size, and make sure the order of thecategories in the graph makes sense.
6. Find the min, max, mean, median, sd, and IQR of the cholesterol/HDL ratio values of the studyparticipants.
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 useappropriate 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 orderof the categories in the graph makes sense. Does the graph imply that there is a difference in theheart rate between the two groups?
9. Create a visual display that helps you figure out if there is a relationship between the stabilized glucoselevels and the waist to hip ratio of a person. Use different symbols/colors to distinguish the gender ofa person. Make sure the graph has appropriate title, labels, and font size.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."