Skip to content

平成21年度 春期 ITパスポート試験 問95

This question's explanation and your answers so far.

問95
頻出度★★★

フィットネスジムに勤める A さんは,会員管理システムのデータを基に,PC のデータベースソフトを利用して,利用状況の分析を行うことにした。図 1 に示す構造をもつ会員管理システムの会員表及び入館表から,20 代 ~ 50 代の会員についてのデータを 1 か月分取得した。 図1 会員表及び入館表のデータ構造 - 会員表:会員番号,会員名,性別,年齢 - 入館表:会員番号,日付,入館時刻 利用状況の分析を始めるために,取得した会員表及び入館表から図 2 に示す構造をもつ会員利用分析表を作成した。 図2 会員利用分析表のデータ構造 - 会員利用分析表:会員番号,会員名,性別,年齢,日付,入館時刻 作成した会員利用分析表のデータを基に,表に示す性別年代別利用者数一覧を作成した。人数は延べ人数であり,1 か月間の利用回数を表している。 表 性別年代別利用者数一覧

性別年代人数(人)
男性20 代56
男性30 代114
男性40 代227
男性50 代295
男性小計692
女性20 代100
女性30 代215
女性40 代348
女性50 代227
女性小計890

表の性別年代別利用者の構成比が分かるようにグラフ化した。次の図の性別年代別構成比グラフの Z に入る項目名として, 適切なものはどれか。

出典 平成21年度 春期 ITパスポート試験 問95
解説

問 95

  • Incorrectア

    Women in their 30s account for 215 ÷ 1,582 = 13.6%, which rounds to 14% and does not become 19%. There are three sectors labeled 14% in the chart (men in their 40s 14.3%, women in their 50s 14.3%, women in their 30s 13.6%), and women in their 30s is the smallest of them, so among those three 14% sectors arranged in descending order it is the third (leftmost) one. That is a different position from the sector of Z (19%).

  • Incorrectイ

    Women in their 40s account for 348 ÷ 1,582 = 22.0%, the largest composition ratio among the 8 groups. It is already drawn in the chart as the “22%” sector placed first clockwise from the 12 o'clock position, immediately before Z. Therefore it is not the item that goes into Z, which is 19%.

  • Incorrectウ

    Men in their 40s account for 227 ÷ 1,582 = 14.3%, which rounds to 14% and does not match 19%. Furthermore, women in their 50s also number 227 (14.3%), so men in their 40s is merely one of the three sectors labeled 14% and cannot by itself occupy the 19% sector.

  • エ

    正解 The composition ratio (percentage) is obtained as “the number of people in that group ÷ the total number of people overall × 100”. The total is the male subtotal 692 + the female subtotal 890 = 1,582 people. Calculating all 8 groups this way gives women in their 40s 22.0%, men in their 50s 18.6%, men in their 40s 14.3%, women in their 50s 14.3%, women in their 30s 13.6%, men in their 30s 7.2%, women in their 20s 6.3%, and men in their 20s 3.5%; rounded to integers, they are 22 / 19 / 14 / 14 / 14 / 7 / 6 / 4 (%). The labels of the pie chart run clockwise from the 12 o'clock position as 22% → Z(19%) → 14% → 14% → 14% → 7% → 6% → 4%, that is, in descending order of composition ratio. The only group that comes to 19% is “men in their 50s”, at 295 ÷ 1,582 = 18.6% ≒ 19%; moreover the sector of Z sits in the second position, right after the largest 22% (women in their 40s), and it corresponds exactly to men in their 50s, the group with the second-largest ratio. Therefore the item name that goes in Z is “men in their 50s” = エ.

ここがポイント
  • The denominator of a composition ratio (percentage) is the overall total. Here the denominator is 1,582 people, the male subtotal 692 plus the female subtotal 890; if the subtotal of only one gender is used as the denominator, every value goes wrong (for example, 295 ÷ 692 = 42.6%, which no longer corresponds to any choice).
  • A pie chart (composition ratio chart) usually arranges its sectors clockwise from the 12 o'clock position in descending order of composition ratio. By matching the sequence of labels written in the chart (22 → 19 → 14 → 14 → 14 → 7 → 6 → 4) against the descending order of the composition ratios you calculate yourself from the table, you can uniquely identify the hidden item. When several values are tied, using a value that appears only once (19% here) as the clue is the surest approach.
用語

Your answers