Need Sunday By 8:30pm EST Assignment Part 1: Facebook Audience And Assignment Part 2: Facebook Audience
uniqueone1463
Part1.xlsxData
| Age | Gender | Ethnicity | |||
| Age- write the person's age | |||||
| Gender- write either M for Male or F for Female | |||||
| Ethnicity- refer to this chart | |||||
| W | White Alone | ||||
| B | Black or African American Alone | ||||
| H | Hispanic or Latino Alone | ||||
| AI | American Indian or Alaska Native Alone | ||||
| A | Asian Alone | ||||
| NH | Native Hawaiian or Pacific Islander Alone | ||||
| O | Other Race Alone | ||||
| 2 | Two or more races | ||||
| U | Unknown Race | ||||
You will need to randomly sample 100 of your Facebook friends and provide the following information: age, gender and ethnicity. Fill in the chart on the left using the specified letters and numbers that are stated above. This part of the activity is worth 10 points. Once you are finished follow the steps on the next tab of the Excel file.
Your Demographics
| Gender (in %) | Ethnicity (in %) | |||||||||||||||
| Median Age | Male | Female | White | Black/ African American | Hispanic/ Latino | American Indian/ Alaska Native | Asian | Native Hawaiian/ Pacific Islander | Other Race Alone | Two or more races | Unknown Race | |||||
| Question #1 (5 points) | What do you think your Facebook audience should look like based on the content you provide? | |||||||||||||||
| Age Range Categories (15 points) | Frequency | Percent | ||||||||||||||
| 5 to 9 years | Mean Age | 5 points | ||||||||||||||
| 10 to 14 years | ||||||||||||||||
| 15 to 19 years | ||||||||||||||||
| 20 to 24 years | Median Age | 5 points | ||||||||||||||
| 25 to 34 years | ||||||||||||||||
| 35 to 44 years | ||||||||||||||||
| 45 to 54 years | ||||||||||||||||
| 55 to 59 years | ||||||||||||||||
| 60 to 64 years | ||||||||||||||||
| 65 to 74 years | ||||||||||||||||
| 75 to 84 years | ||||||||||||||||
| 85 years and over | ||||||||||||||||
| Gender (5 points) | ||||||||||||||||
| Male | ||||||||||||||||
| Female | ||||||||||||||||
| Ethnicity (15 points) | ||||||||||||||||
| White Alone | ||||||||||||||||
| Black or African American Alone | ||||||||||||||||
| Hispanic or Latino Alone | ||||||||||||||||
| American Indian or Alaska Native Alone | ||||||||||||||||
| Asian Alone | ||||||||||||||||
| Native Hawaiian or Pacific Islander Alone | ||||||||||||||||
| Other Race Alone | ||||||||||||||||
| Two or more races | ||||||||||||||||
| Unknown Race |
Before making any calculations, answer Question #1 of what you think your Facebook audience looks like. Using the results from the Data tab, please provide the statistics in the tables on the left. All cells highlighted in yellow need to be filled in. Note: The frequency will count how many times a particular category appears. For example, if you have 34 Facebook friends that are males the frequency would be 34. When finding the frequency try using the COUNTIF function in Excel. Once you have these tables filled in, create a bar (or column) graph for age, gender and ethnicity. Each graph should use either the frequency or percentage (not both) and you should include proper titles for the x-axis and y-axis.
PLACE YOUR GRAPHS HERE (40 points)
