) Seek to understand the format/layout of the raw survey data (results). Identify each question in the results, as well as each customer’s responses…
1.) Seek to understand the format/layout of the raw survey data (results). Identify each question in the results, as well as each customer’s responses to those questions. This may take some time to figure out how the raw survey results are organized.
Note: You might need to “clean up” or re-label some of the headers in the second row of the Survey Data sheet, especially where the header shows the word “response”. Do not delete any data and do not insert columns between the data – the data all need to be connected to be able to complete #3.
2.) For each one of the twelve survey questions, they would like to have a summary table and a chart (graph) that appropriately summarizes the results for each question. This means that there would be a total of twelve summary tables and twelve graphs for this requirement. On these graphs, generally a count of respondents (the number of people who answered in each category) should be shown. However, for survey questions 3, 5, and 9, you should show averages of the responses for each question instead of a count of respondents. All of the tables and graphs should be very intuitive and clear–the user should be able to quickly and easily determine exactly what the data are saying when looking at your summarized results.
3.)Also, we want to create the ability to summarize or “slice” the data (both tables and graphs) for survey questions 1-10 according to key demographic information (i.e., gender and age). These table summaries and graphs should be interactive; in other words, the user should be able to quickly and easily select any combination of gender and/or age category, and all tables and graphs for survey questions 1-10 should automatically reflect the selection(s). Note: If the gender and/or age selections exist in more than one place, they must be connected to each other, so that if, for example, “male” is selected in one location, then “male” is automatically selected in all the other locations where that selection exists.
4.)In addition to the tables and graphs above, you will need an additional table and graph for survey questions 3, 5, and 9. (NOTE: these tables and graphs should NOT be done using pivot tables and slicers.) Each additional table and graph should show a count of respondents for one of the response categories. That response category should be selected from a drop-down list. The table and graph should automatically change when the category is changed or “toggled” in the drop-down list. For example, on question 3, if “Shakespeare” were selected as the genre category in the drop-down list, then the table and graph would show 5 columns that summarize only the Shakespeare genre. The first column would show how many individuals selected “1” as their response, the second column would show how many individuals selected “2” as their response, etc. (up to the fifth column which would show how many individuals selected “5” as their response).
Get 20% discount on your first order with us. Place an order and use coupon: GET20