Question

You are doing a study where you wait outside of ocal bar and survey the college students who come in as to what year they are in. The respasses are Freshman, Sophomore, Junior, Senior, and Graduate Student. Suppose you see 200 college students, and that the tallies of the evening amount to:

Freshman Sophomore Junior Senior Graduate
20 25 47 64 44
Display this data in an array on a spread sheet and then create a pie chart and a bar graph to illustrate this data.

Answer 1

The data can be displayed in an array on a spreadsheet as follows:

Year Tally

Freshman 20

Sophomore 25

Junior 47

Senior 64

Graduate 44

A pie chart and a bar graph can be created to illustrate this data.

Step-by-step explanation:

To display the data in an array on a spreadsheet, we list the years in one column and their respective tallies in the next column. The pie chart will visually represent the proportion of each year group by dividing a circle into sectors, with each sector representing a year group’s percentage of the whole. The bar graph will show the frequency of each year group using bars of different heights.

In the pie chart, the percentages for each year group can be calculated by dividing each tally by the total number of students surveyed (200) and multiplying by 100 to get the percentage. For example, the percentage for Freshman would be (20/200) * 100 = 10%. Similarly, these percentages can be used to create the sectors in the pie chart. In the bar graph, the tallies for each year group are represented by the height of the bars. For instance, there will be a bar at 20 for Freshman, 25 for Sophomore, 47 for Junior, 64 for Senior, and 44 for Graduate.

Creating these visual representations will provide a clear and concise way to understand and compare the distribution of college students across different academic years.