Go to: File. Options. Add-ins. Click Analysis Tool Pack. Click Go.
To check if it allowed access, go back to your Excel sheet, click the Data ribbon. In the Analysis group it should say Data Analysis.
To get descriptive statistics for “Current Salary” “Education Level” and “Employment Category” click on Data Analysis. Descriptive Statistics. OK. Your input range is the column of data you want to look at. Column F has “Current Salary” Select column F. Then check the boxes: Labels in First Row, Summary Statistics and Confidence Level for Mean. You will repeat this for Education Level and Employment Category.
check the Word document and answer the questions on it. and the excel folder that had all of the info is up loaded too.
please follow the instructions.
0 comments