Marketing research Assignment do it on excel then answer the following questions

Business Finance

You will need to allow the Data Analysis add-in to function in Excel.

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.