Economic Statistics Using Microsoft Excel

IR Web Site

Bibliographic Information

Other Title
  • Excelによる経済統計分析(その1)
  • Excel ニ ヨル ケイザイ トウケイ ブンセキ ソノ 1

Search this article

Abstract

application/pdf

The purpose of this note is to present the methods of drawing assorted charts, graphs and curves using Excel. This note consists of five parts. In the first part, we present the method of drawing the Exponential Curve. The Exponential Curve is used to calculate the average growth rates. In the second, we present the method of drawing the Lorenz Curve. The Lorenz Curve is one of the most widely used techniques to represent and analyze the size distribution of income and wealth. In the third, we present the method of drawing the Population Pyramid. This Pyramid is a well-known graphic way to show the age and sex composition of a population. Next, we present the method of drawing the Bivariate Density Chart. This is useful, for example, in presenting population density among economic sectors. In the last part, we present the method of drawing the Triangular Graph. This is a method of diagrammatically representing the three proportions of variable.

Journal

Keywords

Details 詳細情報について

Report a problem

Back to top