You are working on a team that is examining social media use at your facility. You have been given the results of a short survey that was conducted. You have been asked to create some graphs for the survey and to determine which social media applications are used the most frequently.
Directions:
Download the Excel workbook named 5380-Survey-Data-Student.
Create a frequency table showing the number of Males and Females in the study.
Create a frequency table showing the number of responses for each type of social media in the study. E.g. Facebook, You Tube, etc.
Create an MS Word document named 5380-Question3-YourLastName and add a page title with the course name, question number and your name each on separate lines.
What is the purpose of this study?
How many men and how many women were in the study. What is the percentage of men and women in the study?
What types of social media did the survey respondents say they used? For each category of social media use (i.e. Facebook) state how many and what percentage of respondents used that type of social media.
If your manager wanted to do some marketing on social media, which two types of social media would you recommend using to reach the most people and why?
Gender
Facebook
You Tube Twitter
Female
Facebook
You Tube
Male
Facebook
Male
Female
Female
Female
Male
Female
Male
Male
Female
Female
Male
Male
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Male
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
Facebook
LinkedIn
Instagram
Instagram
Twitter
LinkedIn
You Tube
You Tube
Instagram
Twitter
You Tube
You Tube
You Tube
LinkedIn
LinkedIn
You Tube
You Tube
You Tube
LinkedIn
LinkedIn
Twitter
You Tube
You Tube
You Tube
You Tube
You Tube
You Tube
You Tube
You Tube
You Tube
You Tube
Twitter
LinkedIn
Twitter
LinkedIn
Instagram
LinkedIn
Instagram
Twitter
Twitter
LinkedIn
Twitter
LinkedIn
Instagram