2. Use the data in the following table to
• Prepare a frequency distribution of the respondents’ ages • Cross-tabulate the respondents’ genders with cola preference • which was the preferred cola
Individual Gender Age Cola Preference Weekly
Purchases
Emily F 16 Pepsi 2
Frank M 19 Pepsi 5
Tony M 17 Coke 7
Jane F 21 Coke 2
Alice F 21 Pepsi 4
Mike M 18 Coke 4
Eddie M 17 Pepsi 8
Joe M 20 Coke 1
I can conclude just by looking at the table that 20 people purchased Pepsi 20 times per week. 14 people purchased Cok weekly so Pepsi is the preferred drink over Coke.
I have been researching the Internet on how to prepare a frquency table and I am getting conflicting info. Would you gaive me some tips?
If you tried to copy and paste, it obviously didn't work. You'll need to type your message here.
Sure, I'd be happy to help you prepare a frequency distribution table using the given data.
To create a frequency distribution of the respondents' ages, follow these steps:
1. Start by creating two columns in a new table: "Age" and "Frequency".
2. Write down all the distinct ages from the given data in the "Age" column. In this case, we have ages 16, 19, 17, 21, and 18.
3. In the "Frequency" column, count how many respondents have each age. For example, we have one respondent who is 16 years old, one who is 19, two who are 17, two who are 21, and one who is 18.
4. Add up the frequencies to get the total number of respondents.
5. Optionally, you can also include a row for the cumulative frequency, which shows the running total of frequencies as you go down the table.
Here's how the frequency distribution table for respondents' ages would look like based on the given data:
Age | Frequency
-----------------
16 | 1
17 | 2
18 | 1
19 | 1
21 | 2
-----------------
Total | 7
Now, for cross-tabulating the respondents' genders with cola preference, you can use the same approach. Create a new table and label the columns as "Gender," "Cola Preference," and "Frequency." Write down all the distinct combinations of gender and cola preference and count how many respondents fall into each category.
Once you have the cross-tabulation table, you can determine which cola is preferred by comparing the frequencies. In this case, it seems that Pepsi is preferred since it has a higher frequency compared to Coke.
I hope this helps! Let me know if you have any further questions.