Among many other things, the United Nations Development Program collects data from various countries on the percentage of the adult workforce made up by women. Here are the percentages for 25 countries included in a study done by the program in the mid-1990’s: 37; 39; 46; 39; 46; 42; 39; 27; 48; 39; 42; 42; 45; 45; 42; 39; 30; 47; 42; 30; 37; 42; 46; 42; 42.
Show your work for each of the following (for repetitive calculations, such as relative frequency, you only have to show work for the first few repetitions):
(A) Determine absolute and relative frequencies (i.e., proportions) of each value as well as the cumulative relative frequencies at each point. Do this by filling out a table that follows the following format:
% women in the workforce ( X) | Frequency
( f) |
Relative Frequency ( p) | Relative Cumulative Frequency ( p) |
27 | 1 | 4 | 4 |
30 | 2 | 8 | 12 |
37 | 2 | 8 | 20 |
39 | 5 | 20 | 40 |
42 | 8 | 32 | 72 |
45 | 2 | 8 | 80 |
46 | 3 | 12 | 92 |
47 | 1 | 4 | 96 |
48 | 1 | 4 | 100 |
(Note: you should include as many rows as you need to display frequencies for each data value). Do not group the data into class intervals. Instead, use one row for each value present in the dataset.
(B) Plot your data on a frequency histogram. Now you will need to group your data into class intervals. Describe how you determine the intervals.
(C) Describe the shape of your frequency histogram.
image1.emf
Microsoft_Excel_Worksheet.xlsx
Sheet1
Example 1-1: Department vs. College | |||||||||
Male | Female | ||||||||
# of applicants | % admitted | # of applicants | % admitted | ||||||
College | 2175 | 47 | 0 | 849 | 31 | ||||
Dept A | 825 | 62 | 108 | 82 | 511.5 | 88.56 | |||
Dept B | 560 | 63 | 25 | 68 | 352.8 | 17 | |||
Dept C | 417 | 33 | 375 | 35 | 137.61 | 131.25 | |||
Dept D | 373 | 6 | 341 | 7 | 22.38 | 23.87 | |||
1024.29 | 260.68 |
Sheet2
Sheet3
image2.emf
Microsoft_Excel_Worksheet1.xlsx
Sheet1
THE BIG PICTURE | |||||
Tabular | Graphic | Numerical | |||
Univariate | Discrete | Nominal | Frequency Table | Bar Chart | Mode |
Ordinal | Mode, Median, Mean | ||||
Continuous | Interval | Histogram | |||
Ratio | |||||
Bivariate | Discrete-Discrete | Contingency Table | TBC | TBC |