Run Descriptive Analysis in Excel Analysis ToolPak for the S…
Run Descriptive Analysis in Excel Analysis ToolPak for the Salary variable in Baseball Salaries 2020.xlsx by following the steps below. Download and open the data file using Excel. Make sure the Analysis ToolPak add-in is installed in Excel. (If not, refer to the lecture slides on how to install the add-in program). Go to the ‘Data’ tab and click ‘Data Analysis.’ Select ‘Descriptive Statistics’ from the list. Follow the steps below. For the Input Range, select the entire Salary column by clicking on column F. Your result should look like below. Save and upload your Excel file. Do not submit screen-capture images or PDF files for file-uploading questions this semester. If the file name is “~$,” it indicates a temporary file, which cannot be opened. Be sure to attach the actual Excel file. If you have any issue, please contact the TA or IT@UMN for help.
Read Details