Video instructions and help with filling out and completing Will Form 843 Brackets

Instructions and Help about Will Form 843 Brackets

Hi everybody this is an emery with Excel for evaluation in this tutorial I'm gonna cover satisfaction survey data tables troubleshooting tips a few months ago I created the video shown on the right called putting it all together satisfaction survey data tables it's one of the most popular videos on YouTube a lot of people said that they've used the technique of their own work but sometimes it's very easy to run into some problems with this process so I'm going to show you one of the most common problems and how to fix it it's very very easy so here's a data set that a YouTube user sent me Helen and Owen she had this survey data on a five-point scale from strongly agree to strongly disagree and there were four different questions on this survey so let's scroll to the bottom and check out the calculations that she made she calculated the ends the blanks and added them up to make sure that the sum sounded correct then she used the countif formula to find how many people responded to each of those categories so for example we can see that 12 people selected strongly agree here she emailed me because she was getting a zero in this neutral category even though she knew that that was incorrect she knew that there were a few neutrals there so the very first thing that I did was I checked out the neutrals here's one right here and as I suspected there was an extra space at the end of the word this sometimes happens when you download your data from Survey Monkey or zoomerang or some other survey software there's this random space so all you have to do is delete it so just hit the backspace key press Enter and now you can see that instead of a zero there's a one here let's scroll down and look at the percentages that automatically adds up down there and shows that two percent of the respondents selected the neutral category so there you go some very easy troubleshooting when you're creating your own satisfaction survey data tables thank you