I'm sending out a survey to approx. Unfortunately we can't afford to use a 3rd-party survey company, so I'll need to process the survey results myself, hopefully harnessing the power of Excel! Can anybody provide advice or point me towards great online resources on this subject matter? In particular I imagine I'd have to use PivotTables to really extrapolate information from the results, though I've never used PivotTables before. I'm thinking that I'd create a master spreadsheet with all the survey results, from which I'd build a PivotTable. Should the spreadsheet be laid out in any particular way?
You may want to see if free online systems will give you what you want. Search google (or bing) for 'free survey site' (or some search phrase. One site that comes to mind is though I have no experience with it.
If you decide to go with Excel, put your data so that the results from each question are in separate columns with one or more columns for identification of each respondent. Then, each row should have the result from one survey. You will then be able to use Excel tools like PivotTable for this data set. Tushar Mehta (Technology and Operations Consulting) www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials) Microsoft MVP Excel 2000-Present Tushar Mehta (MVP Excel 2000-2015) Excel and PowerPoint tutorials and add-ins www.tushar-mehta.com. Hi Phill Are you able to email the questionnaire to your target audience? If so consider using Excel dialog sheets to capture the data.
Better yet Microsoft Infopath though there may be a steep learning curve on that piece of software depending on your level of expertise. I'm thinking that I'd create a master spreadsheet with all the survey results, from which I'd build a PivotTable.
Should the spreadsheet be laid out in any particular way? Things to bear in mind when designing the data capture and the analysis. Keep coding to a minimum number of characters, eg. Colours, brw, blu, blk, gre, gry. Try to use the same number of characters for all codes.
When using numeric values for range of opinions, never use an odd number. As for the layout of the spreadsheet, do not use blank rows and columns in order to make the data easier for you to read this will lead to problems. If legibility does become an issue alter the row heights and column widths do not have unnecessary spacing in the data. So row 1 will be filled with column headings, these are the questions or brief meaningful summaries of the questions eg, gender, location, driver.
Column 1 contains an index number of questionnaire record number or a file name if you are using emails to capture the data. This allows for second data entry verification if needed always a good idea if you want people to have faith in the resulting analysis. This much data entry can be a nightmare to verify and if you are capturing discursive data you may need to refer to the original so get yourself a filing system organisation plan in place before you start collecting. Row 2 column 2 (B2) is the response to question 1 from the first respondent, C2 the response from Question 2 from the first respondent, and so on.
If you have access to a web server, you may like to investigate how to feed the data straight into an SQL database using a php script to form the questionnaire then import the data into Excel. Just a few hours work there I feel;-) may be not what you are looking for at this point. Especially if you are collecting data for a thesis for your masters.
Pat PS If you found this useful please vote. Thank you:¬). Hi Patrick, thanks for the insight. Yes, I'll be e-mailing the questionnaire directly to our list of clientele. By dialog sheets, do you mean the UserForm feature?
(did a Google search of course as I wasn't previously familiar with it). It looks like a great way to input data. I may or may not go this route depending on how I deal with issues listed below.
We don't have Infopath here in the office (workplace office, not Microsoft). Thanks for the tips on the codes. As there are a few open questions on the survey, I think i'll be using 'codes' for each response, e.g.
'I greatly enjoyed the service provided' would become 'HAP'. Now if the person gave a long answer for the open question, the answer may fit into multiple catagories and codes, e.g.: HAP, 123, ABC, DEF. How would I be able to input all these into the same cell, but still have Excel calculate them independently (e.g.
I want to see the total number of 'HAP' responses vs. '123' Also I've been slowly exploring Pivot Tables. I see that when I 'build' the Pivot Table, I can 'drag' the column header around in the table to build it as I see fit. Would it be possible to also be able to drag 'HAP', '123', etc. Around, and do cross-comparisons against other column headers? Right now I'm thinking I'll be building a 'master spreadsheet' with all my data. Yes, my list of clients would run down Column A, with Row A being my question headers.
Raptor Call Of The Shadows Free Download FULL PC Game Raptor Call Of The Shadows Free Download Full Version RG Mechanics Repack PC Game In Direct Download Links. F 22 raptor pc game system requirements. This Game Is Cracked And Highly Compressed Game.
From this I'll generate a Pivot Table. From the Pivot Table i'll go through every permutation to create information/charts for my report. So the readability of my master data sheet is of no concern to me as only I'll be looking at it, and I'm ok with ugly duckling spreadsheets (with my report being the beautiful swan of course). How does that sound? Haha yes, I do have access (no Microsoft pun intended) to a web server (e.g. Where we host our website on).
However the learning curve for scripting (zero knowledge) may be too much as the report is due next month. Sorry I did not reply sooner, I have been working away from home. In response to some of your subsequent questions. Hi Patrick, thanks for the insight. Yes, I'll be e-mailing the questionnaire directly to our list of clientele. By dialog sheets, do you mean the UserForm feature? (did a Google search of course as I wasn't previously familiar with it).
It looks like a great way to input data. I may or may not go this route depending on how I deal with issues listed below.
Yes a dialog sheet is like a user form but you do not have to construct it in Visual Basic. We don't have Infopath here in the office (workplace office, not Microsoft). Thanks for the tips on the codes. As there are a few open questions on the survey, I think i'll be using 'codes' for each response, e.g. 'I greatly enjoyed the service provided' would become 'HAP'.
Now if the person gave a long answer for the open question, the answer may fit into multiple catagories and codes, e.g.: HAP, 123, ABC, DEF. How would I be able to input all these into the same cell, but still have Excel calculate them independently (e.g. I want to see the total number of 'HAP' responses vs. '123' What a good question. I might use the countif function to gather some stats on that field rather than the pivot table, =countif(d2:d1000,'.HAP.' ) will return the number of occurances of the text string HAP in the column D no matter where the string appears in the combination of codes as the.
is a wild card and will ignore everything but your search string. This could be extended to =countif(d2:d1000,AND('.HAP.'
,'.ABC.' ) which will capture those who gave two responses you are interested in analysing. Alternatively, set up sub fields for that question, one for each particular code. So hap column contains a 1 or 0. This is a lengthy process which is why I would avoid it with a short deadline as you have. There are means of processing the data within one column of multiple string sets based on the method above but rather than me explain at length here give me a shout if you need further help. Also I've been slowly exploring Pivot Tables.
I see that when I 'build' the Pivot Table, I can 'drag' the column header around in the table to build it as I see fit. Would it be possible to also be able to drag 'HAP', '123', etc. Around, and do cross-comparisons against other column headers?
Right now I'm thinking I'll be building a 'master spreadsheet' with all my data. Yes, my list of clients would run down Column A, with Row A being my question headers.
From this I'll generate a Pivot Table. From the Pivot Table i'll go through every permutation to create information/charts for my report. So the readability of my master data sheet is of no concern to me as only I'll be looking at it, and I'm ok with ugly duckling spreadsheets (with my report being the beautiful swan of course). How does that sound? Haha yes, I do have access (no Microsoft pun intended) to a web server (e.g. Where we host our website on). Mac os could not be installed on your computer.
However the learning curve for scripting (zero knowledge) may be too much as the report is due next month. Good luck and let me know if you require any further clarification of the points I have made. Pat PS If you found this useful please vote.
Thank you:¬).
Excel Templates For Survey Results
. As a company that deals with customers, it is important that they are satisfied and happy with your or service.
It is a constant search for improvement as they take on the road towards being the best. And one of the ways to find out what can be improved on is by conducting a. The Customer Satisfaction Survey Template for Excel is a convenient and reliable template that will allow you to find out the points in your products or services that make your customers happy and satisfied. This will also allow you to get immediate from your customers and find out aspects of your service that needs to be changed or improved on.
This template is in Excel and contains premade formula that allows you to see the results of the immediately. Get Survey Results in Real Time With this survey template, anyone with any Excel knowledge level can create, edit, and send out their own customer satisfaction survey to their customers either online or offline. It comes with a set of easy to understand instructions in the Instructions worksheet tab. Meanwhile, the other worksheet tab, the Survey tab, contains a table for all the survey questions. This table is set to automatically reflect the responses of the customers as they answer it online. You only need to send them a link via email or through your social media accounts, making it easy for your customers to answer and send back their answers to you. Easily Customizable Survey Form Template The questions on the survey form template include the customer’s overall satisfaction on the service that day, the first time they used the service, how frequently they have used the service, if they would recommend the service to a friend, and suggestions to improve the service.
Aside from these questions, you can also add more questions or modify the existing ones to customize to your own company. Related Posts. Whether you are a teacher, public speaker, motivational speaker, or even a professional tasked to create a workshop on your expertise, you can benefit from. Today, replies to RSVPs are hard to come. In this digital world, it doesn’t seem to be taken as seriously as in the earlier. Providing employees with survey forms across a large organization can be time consuming.
Moreover, estimating responses and making sense out of data to calculate an. Customer profitability is the profit that a company makes in serving a particular customer or client over a specific timeframe.
This is the difference between. If you are a business owner involved in providing services to your customers, then you would need to give out service invoice as a record.
Firstly, you need to count the total number of feedback in each question. 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. Then drag the fill handle to the range you want to use this formula, here I fill it to the range B53: K53. See screenshot: 2. 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 B54: K54. See screenshot: 3.
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. See screenshot: Then count the number of each Strongly Agree, Agree, Disagree and Strongly Disagree on every question. 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. See screenshot: 5. 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. See screenshot: 6.
Repeat step 5 or 6 to count the number of each feedback on the every question. See screenshot: 7. 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. See screenshot: Part 2: Calculate the percentages of all feedbacks Then you need to calculate the percentage of each feedback on every question. 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 format the cell as percentage by right clicking Formats Cells Percentage. See screenshot: You can also show these results as percentages with selecting them and clicking the% (Percent style) in the Number group on the Home tab. Repeat the step 8 to calculate the percentage of each feedback in every question. See screenshot: Part 3: Generate a survey report with calculated results above Now, you can make a survey result report. 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). See screenshot: 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.
See the following screenshot: 11. Edit the title as you need, see screenshot: 12.
Select the part you need to display in the report and right click Copy, and then go to the worksheet you need to paste it and select one blank cell such as Cell B2, a click Home Paste Paste Special. See screenshot: 13. In the Paste Special dialog, check Values and Transpose in the Paste and Transpose sections, and click OK to close this dialog.
See screenshot: Repeat step 10 and 11 to copy and paste the data you need, and then the survey report has been made. See screenshot.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |