PLEASE UPLOAD EXCEL FILE. Produce an Excel file Show all of your calculations for this grouped data on an Excel file..

Show all of your calculations for this grouped data on an Excel file. All work must be supported with and Excel file. If the Excel file is not provided, the student will receive zero credit.

77. FILE The enrollments of the 13 public universities in the state of Ohio are listed below College University of Akron Bowling Green State University Central State University University of Cincinnati Cleveland State University Kent State University Miami University Ohio State University Ohio University Shawnee State University University of Toledo Wright State University Youngstown State University Enrollment 26,106 18,864 1,718 44,354 17,194 41,444 23,902 62,278 36,493 4,230 20,595 17,460 12,512 a. Is this a sample or a population? A b. What is the mean enrollment? A c. What is the median enrollment? A d. What is the range of the enrollments?A