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.
Using the frequency table of responses, create a pie chart showing the percentage of responses for each category.
Label the pie slices with the percentages and the category name.
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.
Data Analysis – Answer the following questions by typing the questions and the answers into your MS Word document. Your answers should be written in clear, complete sentences.
What is the purpose of this study?
Describe the data you are analyzing and how you analyzed it.
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.
Which type of social media was most used and which was least used?
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