I have to do part 5 of the picture that was attached.
I have attached an excel workbook with the results of the survey. The first worksheet contains the results from the 12 people that Katie surveyed, and the second worksheet contains the results from the 12 people I surveyed. I have attached the survey so that you could see what the questions and responses are. Your part is to do the following (in this order preferably):
1.) Create a table of data (check the picture I texted you in the group text) – Also he discussed how to do this in class once.
2.) Frequency for each – create a histogram for each question using excel. (There will be a total of 18 histograms because there are 18 questions in the survey.
3.) Analysis of demographics – write a paragraph analyzing what you found for the demographics (Questions 2-8 in the survey).
4.) Favorability rating – find out the % of 4’s and 5’s (4= Agree, 5 = Strongly Agree)
5.) Correlation Coefficient – make a quality grid table
Lmk if you have questions!
0 comments