I need an email to send through the data please, I cannot upload the file.

(a) The department wants your help to understand the relationship between admission rates (ADM_RATE) and completion rates for first-time, full-time students at four-year institutions (C150_4). Before you may do any advanced analysis they want you to provide some descriptive information about the two variables (ADM_RATE, C150_4). Provide them with the mean, median, and standard deviation of these variables and comment on them. They ask you to interpret the output for them in plain English as they don't know much about statistics. Please attach screenshots or the Excel file to receive part marks if you make a mistake. (5 marks)

(b) The department asks you to identify which states (field name: STABBR) have the highest and lowest average completion rate. Please attach screenshots or the Excel file to receive part marks if you make a mistake. (4 marks)

(c) They are wondering if admission rates can explain why some institutions have low completion rates, whereas others have high completion rates. They ask you to perform regression analysis and interpret the output for them in plain English as they don't know much about statistics. Please attach screenshots or the Excel file to receive part marks if you make a mistake. (13 marks)

(d) Based on your answer in part a, do you think the department should restrict funding to institutions with low rates of completion? Are there any unintended consequences of this action? What other information may you need to consider? (13 marks)