Problem 2. A study has been conducted to determine the distribution of the blood type of medical students at 0U. A sample of 100 medical students attending Oil has been selected and their blood type was identied. 35 students had type A blood, 40 had blood type B, 13 students had blood type AB and 12 students had blood type 0. (a). What is the variable under this study 1? (b). Is the variable under investigation categorical or quantitative '3' Justify your answers. (c). Use Microsoft Excel to plot a bar graph of blood type for the 100 students selected for this study. (d). Use Microsoft Excel to plot a pie chart of the blood type of the 100 medical students seieeted for this study. To make a bar graph in Excel, (1] rst input the data into Exec] spreadsheet, make a table of two columns, blood type and the counts. Label the oolumns,hlood type and counts. respectively. (2) Select the table and go to insert and you will see a number of plots (Bar graphs, Pie charts). If you click on the plot that looks like a bar graph (vertical bars). you will get a bunch of options. Pick the fist one. it will give you the bar chart. Do the same for the pie chart. If you need help with implementing the excel amignment, let me know