Can I get some explanation on this and send the spreadsheet or save in the drive.

1. Open the file and save your working file as a .xIsx file in another folder. 2. Select cell C2 and use the View...Freeze Panes feature to lock in the headings at that location. Notice you can scroll down in the data, and the headings stay in place. This is helpful for large data sets. 3. Insert a column between Median SAT and Acceptance Rate, and move the Graduation % column into the blank column to the right of Median SAT. 4. Using the Data Analysis feature (under Data menu, then far right), prepare Descriptive Statistics (select Summary Statistics checkbox) and place the output starting in cell M1. The input data is found in the Median SAT and Graduation % columns. The output should look like this (click on the image below to open it in a new tab): Median SAT Graduation 9% Mean 1263. 102041 Mean 83.244 89796 Standard Error 8.953785583 Standard Error 1.064074209 Media 1260 Median Mode 1300 Mode Standard Deviation 62.67649908 Standard Deviation 7.4485 19462 Sample Variance 3928.343537 Sampe Variance 55.48044218 Kurtosis -0.128573066 Kurtosis 0.19554016 Skewness -0.12881003 Skew ne sa 0.80484938 Range 291 Range 32 Minimum 1109 Minimum Maximum 1400 Maximum Sun 61892 Sum 4079 Count 49 Count 5. Create a Pivot Table and Pivot Chart showing the Average Expenditure by Student by School, using the Type variable as the Legend. (Hints: you can use the Insert Pivot Table and Pivot Chart feature. Also, your PivotChart fields should look like this. Name this tab PC-By School. The chart should look like the below image (click on the image below to open it in a new tab):Graduation Axis Title School - $20,000 $60,000 $100,000 $40,000 $120,000 $80,000 so Average of Expenditures/Student Amherst Barnar Bates Berkeley Bowdoin Brown Correlation tab. School Bryn Mawr Y Filters Cal Tech Axis (Categories) Carleton Graduate % vs Median SAT Carnegie Mellon Drag fields between areas below: Median SAT Score 1000 1050 1100 1150 1200 1250 1300 1350 1400 1450 Claremont Mckenna Colby Colgat Columbia Cornell format all numeric values correctly. Type Davisdson Values Duke I Legend (Series) Correlation between Median SAT and 6. Use the Data Analysis tool to create the Georgetown Grinnell Average of Expenditure. Hamilton match the scale presented in Figure 4.40 on 7. Remember to add main, x, and y-axis titles and Harvard Graduation %. Save this on a new tab named Haverford Correlation. Now, return to the source data and prepare a Scatterplot using these two variables, Johns Hopkins open it in a new tab). Save the scatterplot on the page 153 of the text (click on the image below to then add a trendline. Format the X and Y axes to Middlebury Axis Title MIT Average Student Expenditure by School Mount Holyoke Northwestern Oberlin Occidental Pomona Princeton Rice Smith Stanford Swarthmore U Michigan U of Chicago U of Rochester U Pennsylvania U Va UCLA UNC Vassar Washington U [MO Washinton and Lee Wellesley Wesleyan (CT Williams Yale Type Lib Arts UniversitySchool Type Median SAT Graduation % Acceptance Rate Expenditures/Student Top 10% HS 85 Amherst Lib Arts 1315 93 22 26636 69 Lib Arts 1220 80 53 17653 Barnard 58 Bates Lib Arts 1240 88 36 17554 95 Berkeley University 1176 68 37 23665 78 1300 90 25703 Bowdoin Lib Arts 24 24 24201 80 90 Brown University 1281 56 18847 70 Bryn Mawr Lib Arts 1255 84 75 31 102262 98 Cal Tech University 1400 1300 80 40 15904 75 Carleton Lib Arts 77 64 33607 52 Carnegie Mellon University 1225 1260 74 36 20377 68 Claremont Mckenna Lib Arts Lib Arts 1200 84 46 18872 52 Colby 1258 85 38 17520 61 Colgate Lib Arts University 1268 90 29 45879 78 Columbia University 1280 83 30 37137 85 Cornell 89 36 17721 77 Davisdson Lib Arts 1230 University 1310 25 39504 91 Duke 91 Georgetown University 1278 89 24 23115 79 67 22301 65 Grinnell Lib Arts 1244 73 38 51 Hamilton Lib Arts 1215 85 20722 University 1370 90 18 46918 90 Harvard 71 Haverford Lib Arts 1285 87 35 19418 48 45460 69 Johns Hopkins University 1290 86 65 Middlebury Lib Arts 1255 92 25 24718 30 56766 95 MIT University 1357 86 Lib Arts 1200 61 23358 47 Mount Holyoke 83 University 1230 82 47 28851 77 Northwestern Oberlin Lib Arts 1247 77 54 23591 64 54 Occidental Lib Arts 1170 72 49 20192 1320 80 33 26668 79 Pomona Lib Arts 89 Princeton University 1340 93 17 48123 24 26730 85 Rice University 1327 88 Lib Arts 1195 87 57 25271 65 Smith 92 Stanford University 1370 88 18 61921 78 Swarthmore Lib Arts 1310 88 24 27487 U Michigan University 1195 77 60 21853 71 45 38937 U of Chicago 73 74 University 1300 University 1155 73 56 38597 52 U of Rochester 30882 87 University 1280 86 41 U Pennsylvania 77 U Va University 1218 88 37 19365 University 1142 61 43 26859 96 UCLA 82 UNC University 1109 73 32 19684 Lib Arts 1287 84 43 20179 53 Vassar University 1225 76 54 39883 71 Washington U (MO) 29 17998 61 Washinton and Lee Lib Arts 1234 78 Lib Arts 1250 86 49 27879 76 Wellesley Lib Arts 1290 91 35 19948 73 Wesleyan (CT) 28 Williams Lib Arts 93 23772 86 1336 93 19 52468 90 Yale University 1350