It is possible to draw world maps for “lent words” or words exported from Japanese into foreign countries using an internet search engine. A numerical data of Google Trends can be downloaded; factor analysis was applied after putting the data in order, and the general tendencies of the maps were grasped. United States, Western Europe and South East Asia stood out as the area where “lent words” are used much, but Latin America showed the tendency different from other countries as a state group. Data of Google Trends could elucidate global distribution of “lent words” which has been impossible in the past.
Part two of a series of introductory essays on graph construction in Microsoft Excel, this paper explains how to create line graphs and scatter plots. As in the previous installment, I use screenshots to demonstrate how to move from initial data output to optimizing display for black and white printing, and introduce additional options that may be used to emphasize key trends in the data.