How to Analyze Satisfaction Survey Data in Excel (With Easy Steps)

This tutorial will show you how to analyze satisfaction survey data in Excel. Sometimes we get a list of survey data in an Excel worksheet. From that worksheet, we need to analyze the survey data and create a report in Excel. In order to make that report from Excel data is the main theme of this article. So, without any further delay let’s see the process to do this.


Download Practice Workbook

You can download the practice workbook from here.


Step-by-Step Procedures to Analyze Satisfaction Survey in Excel

Throughout this article, we will follow step-by-step procedures to analyze satisfaction surveys in Excel. We will use the following dataset to demonstrate all the steps. In the dataset, we have feedback on 4 questions from different individuals. We have used ID numbers to specify different persons. Using this dataset we will analyze the satisfaction survey.

Step-by-Step Procedures to Analyze Satisfaction Survey in Excel


STEP 1: Count All Feedback from Satisfaction Survey Data

In the first step, we will count all feedback in our dataset to analyze satisfaction survey data. We will use different Excel formulas in this step. Let’s see the action that we will follow in STEP 1:

  • To begin with, select cell C13. Type the following formula in that cell:
=COUNTBLANK(C5:C11)

Count All Feedback from Satisfaction Survey Data

  • Press Enter.
  • In addition, drag the Fill Handle tool horizontally to the range we want to use this formula.
  • So, we get results like the following image.

Count All Feedback from Satisfaction Survey Data

Here, the COUNTBLANK function returns the number of blank cells in the selected range of cells.

  • Then, select cell C14 and Insert the following formula:
=COUNTA(C5:C11)
  • Hit Enter.
  • Afterward, drag the Fill Handle tool horizontally to the range we want to use this formula.
  • So, we can see the result in the following image.

Count All Feedback from Satisfaction Survey Data

In the above formula, the COUNTA function counts the number of non-empty cells in the selected range of cells.

  • Furthermore, type the following formula in cell C15:
=SUM(C13:C14)
  • Press Enter.
  • Next, drag the Fill Handle tool to the range where we want to apply this formula.
  • As a result, we get the number of total cells.

Count All Feedback from Satisfaction Survey Data

Here, we used the SUM function to sum the number of blank and non-blank cells.

  • After that, create a new section to record the number of all feedback like the following image.
  • Select cell C17. Enter the following formula in that cell:
=COUNTIF(C5:C11,$C$11)

Count All Feedback from Satisfaction Survey Data

  • Hit Enter.
  • Then, drag the Fill Handle tool from cell C17 to F17 to copy the formula.

Count All Feedback from Satisfaction Survey Data

  • Similarly, count the number of feedback Agree with the following formula:
=COUNTIF(C5:C11,$C$5)

  • In the same way, we can count the number of other two feedbacks.
  • So, the final result will look like the following image.

  • Moreover, we will use the SUM function to find the total number of feedback for a single question.
  • So, select cell C21. Insert the following formula:
=SUM(C17:C20)

  • Press Enter.
  • Then drag the Fill Handle tool to the range that we want to copy the formula.

Read More: How to Tally Survey Results in Excel (Step by Step)


STEP 2: Evaluate Percentages of Feedback with Formula

In the second step, we will evaluate percentages of feedback to analyze satisfaction surveys in Excel. Just follow the below instructions to evaluate percentages:

  • First, we will increase the visibility of our dataset. To do that select row 5.
  • Next, go to the View tab.
  • Click on the Freeze Panes drop-down and select Freeze Panes.

Evaluate Percentages of Feedback with Formula

So, all the rows above row number 5 are frozen. We are now able to scroll through row 5 in our dataset.

  • After that, select cell C24. Insert the following formula in that cell:
=C17/$C$21

Evaluate Percentages of Feedback with Formula

  • Hit Enter.
  • Then, format the value of cell C24 in percentage. To do this right-click on cell C24 and select Format Cells > Percentage.
  • Afterward, drag the Fill Handle tool from cell C24 to C27 to copy the formula.
  • Also, format the value into a percentage.

Evaluate Percentages of Feedback with Formula

  • Then, type formulas in cells D24, E24, and F24 like the following image.

  • Moreover, we can drag the Fill handle tool to get results like the following image.

  • Additionally, in the step we will insert the following formula in cell C28:
=SUM(C24:C27)
  • Press Enter and drag the Fill Handle tool from cell C28 to F28.
  • Finally, we get results like the following image after this step.

Read More: How to Tabulate Data in Excel (4 Effective Ways)


STEP 3: Use Evaluated Results to Analyze Satisfaction Survey Data

In the final step, we will use the percentage value of the previous step to analyze the satisfaction survey data in Excel. Using the data from the previous method, we will create the final report of our analysis with satisfaction survey data. Let’s see how we can do this:

  • Firstly, select the header row of the dataset.

Use Evaluated Results to Analyze Satisfaction Survey Data

  • Secondly, go to the Home tab. Click on the Copy icon to copy the selected data. We can also press Ctrl + C to copy.

Use Evaluated Results to Analyze Satisfaction Survey Data

  • Thirdly, open a new worksheet.
  • Then, select cell B4.
  • After that, go to Home > Paste > Paste Special.

Use Evaluated Results to Analyze Satisfaction Survey Data

  • A new dialogue box will appear. Check the option Values and Transpose from the dialogue box. Then, click on OK.

Use Evaluated Results to Analyze Satisfaction Survey Data

  • So, we can see the results in the following image. We have edited the name in cell B4 to Questions from ID.

Use Evaluated Results to Analyze Satisfaction Survey Data

  • In addition, go to the 1st sheet ‘Count Feedbacks’.
  • Copy row number 5 that contains the Total number of feedback.

Use Evaluated Results to Analyze Satisfaction Survey Data

  • Then, select cell C5 and go to Home > Paste > Paste Special.

Use Evaluated Results to Analyze Satisfaction Survey Data

  • Again, check the options Values and Transpose from the new dialogue box.
  • Click on OK.

  • So, we get the number of total feedback in a new column.

  • Afterward, select cell range (B24:F28).

  • Next, go to the sheet ‘Use Calculated Result’.
  • Then, select cell D5 and go to Home > Paste > Paste Special.

  • Like the immediate step check the options Values and Transpose from the new dialogue box.
  • Now click on OK.

  • Lastly, we get results like the following image. This is the final report of our analysis of satisfaction survey data.

Read More: How to Analyze Survey Data in Excel (with Quick Steps)


Conclusion

In conclusion, this tutorial shows how to analyze satisfaction survey data in Excel with different steps. Use the practice worksheet that comes with this article to put your skills to the test. If you have any questions, please leave a comment below. Our team will try our best to respond to you as quickly as possible. Keep an eye out for more creative Microsoft Excel solutions in the future.


Related Articles

Mukesh Dipto

Mukesh Dipto

Hi there! I am Mukesh Dipto. I graduated with a bachelor's degree in engineering. Currently, I am working as a technical content writer in ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include sports and meeting new people. I also enjoy sports. My favorite sports are football (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo