2. Problem 2 is adapted from the Problem 39 at the end ofChapter 11. Please solve this problem in Excel and submit yourExcel spreadsheet. The problem is as follows: The state of Virginiahas implemented a Standard of Learning (SOL) test that all publicschool students must pass before they can graduate from highschool. A passing grade is 75. Montgomery County High Schooladministrators want to gauge how well their students might do onthe SOL test, but they don't want to take the time to test thewhole student population. Instead, they selected 20 students atrandom and gave them the test. The results are as follows: 83 79 5693 48 92 37 45 72 71 92 71 66 83 81 80 58 95 67 78 Assume that SOLtest scores are normally distributed. a. Compute the mean andstandard deviation for these data. b. Determine the probabilitythat a student at the high school will pass the test. c. How manypercent of students will receive a score between 75 and 95? d. Whatscore will put a student in the bottom 15% in SOL score among allstudents who take the test? e. What score will put a student in thetop 2% in SOL score among all students who take the test? 3. Theaverage male drinks 2 L of water when active outdoors (with astandard deviation of 0.8L). You are planning a full day naturetrip for 100 men and will bring 210 L of water. What is theprobability that you will run out? Please solve this problem inExcel and submit your Excel file.