In: Statistics and Probability
3. Plot the below scores using the most appropriate type of graph. The goal is to see how these bowlers have performed over time.
|
Day |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
Bob |
111 |
133 |
122 |
144 |
124 |
155 |
133 |
166 |
133 |
147 |
|
Ted |
89 |
99 |
111 |
121 |
133 |
133 |
124 |
122 |
120 |
155 |
|
Carol |
144 |
145 |
133 |
155 |
166 |
133 |
177 |
188 |
179 |
157 |
|
Alice |
166 |
177 |
184 |
168 |
147 |
198 |
167 |
178 |
187 |
201 |
4. Plot the scores below for the bowler's scores as a function of their ages. The goal is to see a relationship between two variables...scores vs. ages. Also, create a list according to their ages (oldest first), then their scores (highest first), then their names (alphabetically).
|
Name |
Age |
Score |
|
Matilda |
11 |
121 |
|
Gretel |
21 |
204 |
|
Gertrude |
15 |
144 |
|
Frances |
7 |
34 |
|
Winifred |
33 |
220 |
|
Heather |
26 |
215 |
|
Esther |
9 |
55 |
|
Beulah |
17 |
155 |
|
Marnie |
29 |
178 |
|
Ilse |
14 |
98 |
5. Graph the percentages of the students at a college:
Freshmen = 40%,
Sophomores = 30%, Juniors = 20%, Seniors = 10%
6. Make a spread sheet that calculates your grades in this class.
3.

4.

List according to age (with oldest first)
| Name | Age | Score |
| Winifred | 33 | 220 |
| Marnie | 29 | 178 |
| Heather | 26 | 215 |
| Gretel | 21 | 204 |
| Beulah | 17 | 155 |
| Gertrude | 15 | 144 |
| Ilse | 14 | 98 |
| Matilda | 11 | 121 |
| Esther | 9 | 55 |
| Frances | 7 | 34 |
Sorted List based on Score
| Name | Age | Score |
| Winifred | 33 | 220 |
| Heather | 26 | 215 |
| Gretel | 21 | 204 |
| Marnie | 29 | 178 |
| Beulah | 17 | 155 |
| Gertrude | 15 | 144 |
| Matilda | 11 | 121 |
| Ilse | 14 | 98 |
| Esther | 9 | 55 |
| Frances | 7 | 34 |
Alphabetical list.
| Name | Age | Score |
| Beulah | 17 | 155 |
| Esther | 9 | 55 |
| Frances | 7 | 34 |
| Gertrude | 15 | 144 |
| Gretel | 21 | 204 |
| Heather | 26 | 215 |
| Ilse | 14 | 98 |
| Marnie | 29 | 178 |
| Matilda | 11 | 121 |
| Winifred | 33 | 220 |
5.

6.
Please ask this problem separately and provide your marking scheme and the your course subjects in order to solve this problem.