i have to do part 5 of the picture the results of the survey are attached to the excel file the pdf file will have the questions that were asked during this suvey.
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