Skip to content

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

This question's explanation and your answers so far.

問96
頻出度★★★

フィットネスジムに勤める 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

女性会員について,年代別に各時間帯に入館した人数の推移が分かるようにグラフ化した。次の図の女性会員の年代別時間帯推移グラフの分析として,適切なものはどれか。 積み上げ棒グラフ。縦軸:人数(人),0~600。横軸:入館時間帯(時),3区分(10~14,14~18,18~22)。凡例:50代,40代,30代,20代。各棒の積み上げ値(下から20代/30代/40代/50代):

入館時間帯(時)20代30代40代50代
10~1415257544
14~1835755345
18~2250115220138
出典 平成21年度 春期 ITパスポート試験 問96
解説

問 96

  • ア

    正解 The correct answer is ア. First, read the number of female members for each age group from the graph. Those in their 20s: 15 → 35 → 50; those in their 30s: 25 → 75 → 115; those in their 40s: 75 → 53 → 220; those in their 50s: 44 → 45 → 138 (from the left, the 10-to-14, 14-to-18, and 18-to-22 time slots). What ア compares is the following two increase rates. (1) Those in their 30s, comparing the 10-to-14 and 14-to-18 time slots ... (75 − 25) ÷ 25 = 2.0, that is, an increase of 200% (3 times as many). (2) Those in their 40s, comparing the 14-to-18 and 18-to-22 time slots ... (220 − 53) ÷ 53 ≈ 3.15, that is, an increase of about 315% (about 4.2 times as many). Since an increase of 315% is larger than an increase of 200%, the increase rate of those in their 40s is larger. The key point is that increase rates are compared not by the difference in the number of people, but by the ratio to the original value. Intuitively, those in their 40s gained 167 people on top of the original 53 (the increase is about 3.2 times the original value), whereas those in their 30s gained only 50 people on top of the original 25 (the increase is 2 times the original value); therefore, in terms of increase rate, those in their 40s exceed those in their 30s. It helps to grasp it this way, by comparing the sizes of the ratios.

  • Incorrectイ

    When the 10-to-14 and 14-to-18 time slots are compared, the increase rate of each age group is as follows: those in their 20s, 15 → 35, an increase of about 133%; those in their 30s, 25 → 75, an increase of 200%; those in their 40s, 75 → 53, a decrease of about 29%; those in their 50s, 44 → 45, an increase of only about 2%. The largest increase rate is that of those in their 30s, and those in their 50s are almost flat, going from 44 people to 45 (the smallest among the three age groups that increased). Therefore this option is wrong.

  • Incorrectウ

    When the 14-to-18 and 18-to-22 time slots are compared, the increase rates are as follows: those in their 20s, 35 → 50, an increase of about 43%; those in their 30s, 75 → 115, an increase of about 53%; those in their 40s, 53 → 220, an increase of about 315%; those in their 50s, 45 → 138, an increase of about 207%. The largest is those in their 40s, not those in their 30s. For those in their 30s, both the increase in the number of people (40) and the increase rate are on the smaller side among the four age groups, so this option is wrong.

  • Incorrectエ

    Those in their 40s decreased from 75 people in the 10-to-14 time slot to 53 people in the 14-to-18 time slot, so it is not the case that every age group keeps increasing. The overall height of the stacked bars (159 → 208 → 523) does grow as the time slot gets later, but that is about the totals, which is a separate matter from the trend of each age group that makes up the breakdown. Applying an overall trend directly to the components of the breakdown is a typical mistake.

ここがポイント
  • Increase rate (rate of change) = (later value − earlier value) ÷ earlier value. The size of the increase in the number of people (a difference) and the increase rate (a ratio) are different things; when comparing increase rates, match up ratios in the form of “by how many times the original value it increased”. Always read carefully whether an option is talking about the “increase rate” or the “number of people”.
  • In a stacked bar chart, the overall height of a bar represents the total, and each segment inside the bar represents a component of the breakdown. Even when the total is increasing, part of the breakdown may be decreasing, so when a question asks about the breakdown, such as by age group, read the value of each segment to make the judgment.
用語

Your answers