Edit the title as you need, see screenshot:ġ2. If you are using the Microsoft Excel 2007, you can paste these calculated percentages with selecting a blank cell, and then clicking the Home > Paste > Transpose. Select the columns' titles of the survey (A1:K1 in this case), and right click > Copy and then paste them into another blank worksheet by right clicking > Transpose (T). Now, you can make a survey result report.ġ0. Part 3: Generate a survey report with calculated results above Repeat the step 8 to calculate the percentage of each feedback in every question. You can also show these results as percentages with selecting them and clicking the % (Percent style) in the Number group on the Home tab.ĩ. Then format the cell as percentage by right clicking > Formats Cells > Percentage. In the Cell B62 type this formula =B57/$B$61 (the Cell B57 indicates the special feedback you want to count its number, the Cell $B$61 stands the total number of feedbacks, you can change them as you need) to sum the total feedback and press Enter button on the keyboard, then drag the fill handle to the range you want to use this formula. Then you need to calculate the percentage of each feedback on every question.Ĩ. Part 2: Calculate the percentages of all feedbacks In the Cell B61 type this formula =SUM(B57:B60) (the range B2:B51 is the range of the feedback on question 1, you can change it as you need) to sum the total feedback and press Enter button on the keyboard, then drag the fill handle to the range you want to use this formula, here I fill it to the range B61: K61. Repeat step 5 or 6 to count the number of each feedback on the every question. Type =COUNTIF(B2:B51,$B$11) (the range B2:B51 is the range of the feedback on question 1, the cell $B$11 is the criteria you want to count, you can change them as you need) in to cell B58, and press Enter button on the keyboard, then drag the fill handle to the range you want to use this formula, here I fill it to the range B58: K58. In the Cell B57, type this formula =COUNTIF(B2:B51,$B$51) (the range B2:B51 is the range of the feedback on question 1, the cell $B$51 is the criteria you want to count, you can change them as you need) in to it, and press Enter button on the keyboard, then drag the fill handle to the range you want to use this formula, here I fill it to the range B57: K57. Then count the number of each Strongly Agree, Agree, Disagree and Strongly Disagree on every question.Ĥ.
In the Cell B55, type this formula =SUM(B53:B54) (the range B2:B51 is the range of the feedback on question 1, you can change it as you need) in to it, and press Enter button on the keyboard, then drag the fill handle to the range you want to use this formula, here I fill it to the range B55: K55. Then drag the fill handle to the range you want to use this formula, here I fill it to the range B54: K54. In the Cell B54, type this formula =COUNTA(B2:B51) (the range B2:B51 is the range of the feedback on question 1, you can change it as you need) into it, and press Enter button on the keyboard. Then drag the fill handle to the range you want to use this formula, here I fill it to the range B53: K53. Select a blank cell, for instance, the Cell B53, type this formula =COUNTBLANK(B2:B51) (the range B2:B51 is the range of the feedback on question 1, you can change it as you need) in it, and press Enter button on the keyboard. Super Filter: Create advanced filter schemes and apply to any sheets Sort by week, day, frequency and more Filter by bold, formulas, comment.Ģ007-2019 and 365 Supports all languages Easy deploying in your enterprise or organization.Īmazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!įirstly, you need to count the total number of feedback in each question.ġ.
How to use data analysis in excel equation pdf#
Split Tools: Split Data into Multiple Sheets Based on Value One Workbook to Multiple Excel, PDF or CSV Files One Column to Multiple Columns.Merge Tools: Multiple Workbooks and Sheets into One Merge Multiple Cells/Rows/Columns Without Losing Data Merge Duplicate Rows and Sum.More than 20 text features: Extract Number from Text String Extract or Remove Part of Texts Convert Numbers and Currencies to English Words.Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by