Step 5:
Analyze the Data
Once your have conducted your survey, you will put all of your data together. The information you collected is RAW DATA and you need to organize it and draw some conclusions from it. You will be creating a RELATIVE FREQUENCY TABLE in Microsoft Excel which allows you to see how many people chose each answer in the survey (called the frequency) along with the relative frequency (a ratio of how many people picked each answer out of the total) and the percentage for each one.
I have created a survey of my own as an EXAMPLE for you. My DATA ANALYSIS page is shown below. You will need to refer to this example often while you are completing this step of the project so that you know you are completing the work as expected. My EXAMPLE is a MINIMUM EXPECTATION. You are welcome to format your data or your graphs with more attention to detail and creativity, but all elements must still be present. You may click on the link below to view the EXAMPLE DATA ANALYSIS SHEET at any time.
I have created a survey of my own as an EXAMPLE for you. My DATA ANALYSIS page is shown below. You will need to refer to this example often while you are completing this step of the project so that you know you are completing the work as expected. My EXAMPLE is a MINIMUM EXPECTATION. You are welcome to format your data or your graphs with more attention to detail and creativity, but all elements must still be present. You may click on the link below to view the EXAMPLE DATA ANALYSIS SHEET at any time.
GETTING STARTED: Create Your Excel DATA ANALYSIS SHEET
Click below to see a video showing you how to set up your DATA ANALYSIS SHEET.
NEXT: Watch videos showing how to create your
RELATIVE FREQUENCY TABLE
This video shows how to calculate relative frequency in Microsoft Excel. THEN watch the next video to see how to calculate the percents.
This video shows how to calculate the PERCENTAGES you will need. You only need to watch from 2:00 minutes until 3:25 to see how to do this.
FINALLY: Create GRAPHS of your data
Once you have your data collected in an organized fashion, you need to create graphs or charts of the data for each question. Below are tutorials for how to create different types of data displays in Microsoft Excel.