Visit the
dataset link
to view the datasets that accompany our textbook. Review the dataset titles and select a data set of interest to you. (Note: You may need to use more than one data set to complete this Discussion.)
State the dataset that you selected. For each variable in your data, identify it as either qualitative or quantitative. (If your dataset does not have both types of variables, please pick an additional dataset to share at least one qualitative and one quantitative variable.)
Select one of your quantitative variables and determine whether it is discrete or continuous. (Please do not select the same variable as a classmate.)
For that same variable create a frequency distribution table including frequency, relative frequency and cumulative relative frequency. Copy and paste the table directly into your discussion post or attach it as a separate file.
Please let me know if the links don’t work so I can get you the datasets needed
Unit 1 Discussion: What’s Your Frequency?! Describing Data with Numbers and Graphs
Unit 1 Discussion Example – Main Post
Main Post: Visit the dataset link to view the datasets that accompany our textbook. Review the dataset titles
and select a data set of interest to you. (Note: You may need to use more than one data set to complete this
Discussion.) See the DB starter video in the Unit 1 LiveBinder.
1. State the dataset that you selected. For each variable in your data, identify it as either qualitative and
quantitative. (If your dataset does not have both types of variables, please pick an additional dataset to
share at least one qualitative and one quantitative variable.)
2. Select one of your quantitative variables and determine whether it is discrete or continuous. (Please
do not select the same variable as a classmate.)
3. For that same variable create a frequency distribution table including frequency, relative frequency
and cumulative relative frequency. Copy and paste the table directly into your discussion post or
attach it as a separate file.
******************************************************************************************
1. I choose to download and analyze the Cereal_Data.xlsx
Qualitative variables: Shelf, Name, Manufacturer, Type
Quantitative variables: Calories, Protein, Fat, Sodium, Fiber, Carbohydrates, Sugars, Potassium, Vitamins,
Weight (of One Serving Cup), Cups in Serving
2. I will consider the quantitative variable, Calories. It is a measurement that can take on any value in an
interval so it will be considered continuous. Note, usually it is measured in whole number precision and that is
what is recorded in the data spreadsheet.
3. Frequency Distribution table for Calories:
Cereal_Data
BINS
61
72
83
94
105
116
127
138
149
160
More
Frequency Relative Frequency Cumulative %
3
3.90%
3.90%
2
2.60%
6.49%
1
1.30%
7.79%
7
9.09%
16.88%
17
22.08%
38.96%
29
37.66%
76.62%
10
12.99%
89.61%
2
2.60%
92.21%
3
3.90%
96.10%
3
3.90%
100.00%
0
0.00%
100.00%
Purchase answer to see full
attachment