JPH09153101A - Data analyzing method based upon displayed graph - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily analyze numerical data corresponding to a noticed point on a graph and plural numerical data based upon a displayed graph. SOLUTION: A graph plotting processing part 5 displays numerical data in a table data 11 on a display device 12 as a graph. When a noticed point on the graph is pointed out by an input device 13, an object selecting processing part 7 registers the object number of a corresponding object in a selected object table 14. An analytical method selecting processing part 8 displays a menu for analytical methods on the device 12 in accordance with an instruction from the device 13. When a certain analytical method is selected, an analysis execution processing part 9 converts the registered object into the original numerical data, executes culculation in accordance with a specified calculation equation and displays the calculated result on the device 12.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data analysis method using a graph, which is characterized by converting a displayed graph into numerical data and performing a specified operation on the converted numerical data.

[0002]

2. Description of the Related Art Software for displaying table data stored in a table format as a graph and displaying the graph on a display device is used. Graphs are convenient for visually grasping changes in a series of numerical data, but are not suitable for checking the numerical data that is the source of the graph or for performing arithmetic operations on multiple numerical data for analysis. is there. In the past, the original tabular data had to be displayed in addition to the graph, and even if an attempt was made to analyze the data by looking at the graph, it was not possible to respond immediately.

[0003]

According to the above-mentioned prior art, the original table data must be displayed together with the graph, and in order to confirm the numerical data of the point of interest on the graph, the numerical data corresponding to the point of interest must be confirmed. Must be found in the table data. To calculate and analyze the data corresponding to multiple points of interest on the graph, either store the calculation results for all combinations of points of interest in the table data, or use a desk calculator to calculate. It had to be inconvenient.

The present invention has been made in view of the above circumstances, and an object thereof is to provide a method capable of easily analyzing numerical data based on a graph.

[0005]

[Means for Solving the Problems] In the following graph,
For example, it is assumed that a plurality of related numerical data arranged in a predetermined order, such as a series of numerical data arranged in time series, is represented by a graphic. Examples of the graph representation method include a bar graph and a line graph. In addition, a graphic forming a part of a graph refers to each bar (rectangle) forming a bar graph, points forming a line graph, and the like, and is also referred to as a graph object, an object, or a point of interest on the graph.

The present invention is characterized by a data analysis method using a graph in which, when a figure forming a part of a graph is designated, the designated figure is converted into corresponding numerical data and displayed.

Further, according to the present invention, when a plurality of figures forming a part of a graph are designated, the designated figures are converted into corresponding numerical data, and the converted numerical data is subjected to a specified operation. The data analysis method by the graph displaying the data of the calculation result is a feature.

The point of interest on the graph is associated with the numerical data in the table data, and when the point of interest on the graph is designated, the corresponding numerical data is extracted and displayed. Also, by selecting a plurality of points of interest and then selecting an analysis method from the menu, it is possible to interactively perform the desired analysis and display the results.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram of the apparatus of this embodiment. Reference numeral 11 is table data in which the data is stored in a table format. A display device 12 displays a graph, a menu indicating an analysis method, and analysis result data. 5 is table data 1
1 is a graph drawing processing unit that draws a graph on the display device 12 based on 1. Reference numeral 13 is an input device such as a mouse for instructing an analysis method in the menu and objects constituting the graph displayed on the display device 12. A selected object table 14 stores the number of the selected graph object. An object selection processing unit 7 stores the object number of the selected graph object in the selection object table and highlights the graph object displayed on the display device 12 selected via the graph drawing processing unit 5. Reference numeral 15 is an analysis method selection menu for storing a calculation formula for each analysis method and analysis methods possible according to the number of selected graph objects. Reference numeral 8 denotes an analysis method selection process for displaying a corresponding analysis method menu on the display device 12 based on the number of graph objects selected by referring to the analysis method selection menu 15 and acquiring the selected analysis method. It is a department. Numeral 9 refers to the analysis method selection menu 15 to obtain a calculation formula corresponding to the selected analysis method, refers to the selected object table 14 and table data 11 to convert the selected graph object into numerical data, and performs calculation. It is an analysis execution processing unit that executes a calculation by an expression and displays the result on the display device 12. An input determination processing unit 6 determines input information from the input device 13 and passes control to the object selection processing unit 7 or the analysis method selection processing unit 8. The device is realized by an information processing device including a personal computer and a workstation. The graph drawing processing unit 5, the input determination processing unit 6, the object selection processing unit 7, the analysis method selection processing unit 8, and the analysis execution processing unit 9 are realized by executing a program stored in the storage device of this information processing apparatus. To be done. Table data 11, selected object table 1
4 and the analysis method selection menu 15 are files or tables stored in the storage device of this information processing apparatus.

FIG. 2 is a diagram showing the data format of the table data 11. In this example, there are two types of data, and numerical data for A, B, and C are shown.
A, B, C correspond to the time of day, month, period, year, etc. Each numerical data corresponds to a graph object.

FIG. 3 is a diagram showing a data format of the selected object table 14. The selected object table 14 stores the object number of the selected graph object.

FIG. 4 is a diagram showing the data format of the analysis method selection menu 15. The analysis method selection menu 15 stores a menu of analysis methods and calculation formulas corresponding to the analysis methods corresponding to the number of selected objects of 1, 2 and 3 or more, respectively. "Data" of the analysis method indicates that the numerical data of the selected object is displayed. "Total" is the total of the numerical data of the selected objects, and "Difference" is 2 from the numerical data of the first selected object.
Subtract the numerical data of the second selected object and take the difference. "Contrast" is the numerical data of the first selected object divided by the numerical data of the second selected object to obtain the percentage. Indicates that the average value of the numerical data of the selected objects should be taken. A1, A2, ..., An respectively represent numerical data corresponding to the selected object.

When receiving a graph display request from an application program (not shown), the graph drawing processing section 5 refers to the table data 11 to convert the numerical data in the table into objects on the graph, and sets the graph of the set graph. It is displayed on the display device 12 according to the attribute information.

FIG. 5 is a flowchart showing the processing flow of the input determination processing unit 6 and the object selection processing unit 7. When there is an instruction from the input device 13, the input determination processing unit 6 acquires information about the coordinate value on the display device 12 and the button on the mouse that the input device 13 instructs (step 61). If the coordinate values are within the graph area or the analysis method menu area (step 62YE
S), to judge the mouse button information (step 6)
3). If the left button is pressed (step 63)
Left button), and passes control to the object selection processing unit 7.
The object selection processing unit 7 determines whether or not the object is in the graph (step 71). It is determined whether or not any one of the objects forming the graph has been designated by referring to the correspondence table of the object number and the coordinate value range on the display device 12 not shown. If any object in the graph is designated (step 71YE
S), the number of the designated object is acquired from the correspondence table (step 72). Next, the object selection processing unit 7
Refers to the selected object table 14 and determines whether or not the object is already selected (step 73). If it is not the selected object (NO in step 73), the number of the acquired object is added to the selected object table 14 (step 74), and the graph drawing processing unit 5 is requested to highlight the selected object (step 75). . If it is the object being selected (YES in step 73), the graph drawing processing unit 5 is requested to delete the object number acquired from the selected object table 14 (step 76) and return the selected object to the normal display (step). 77). If the right button of the mouse has been pressed (step 63, right button), control is passed to the analysis method selection processing section 8 (step 64). If the acquired coordinate value is not in the graph area (NO in step 62) or does not correspond to the object in the graph (NO in step 71), the process ends.

FIG. 6 is a flowchart showing the processing flow of the analysis method selection processing unit 8 and the analysis execution processing unit 9.
The analysis method selection processing unit 8 uses the selected object table 1
4, it is determined whether or not the number of the selected object is registered (step 81). If the object number is registered in the selected object table 14 (YES in step 81), it is determined whether the analysis method menu is displayed and the item in the menu is selected (step 82). If the analysis method menu is not displayed (step 82 NO), the analysis method selection menu 15 is referred to and the analysis method menu is acquired according to the number of objects registered in the selected object table 14 (step 83). ), A menu of analysis methods is displayed on the display device 12 (step 84). If any one of the selection items of the menu is selected by referring to the correspondence table of the selection item (not shown) and the coordinate value range on the display device 12 (YES in step 82), the selected item is acquired (step 85). ). If clear is selected as the selection item (step 86 clear), all object numbers are deleted from the selected object table 14 (step 87), and the display device 12 is displayed.
Delete the selection menu displayed in (Step 8
8) Then, the graph drawing processing section 5 is requested to return all objects to the normal display (step 89). If any analysis method is selected as the selection item (step 86 analysis method), control is passed to the analysis execution processing unit 9. The analysis execution processing unit 9 uses the selected object table 1
4 to obtain the selected object number, and to refer to the table data 11 to convert the object corresponding to the object number into the original numerical data (step 9).
1). Next, referring to the analysis method selection menu 15, the calculation formula corresponding to the number of selected objects and the analysis method is taken out and calculated (step 92). Finally, the calculation result is displayed on the display device 12 (step 93). The calculation result is displayed overlaid on the analysis method menu. When there is no object number on the selected object table 14 (step 81 NO), or when “cancel” is selected as the selection item (step 86 cancel), the processing ends.

FIG. 7 is a diagram showing a display example of a graph, an analysis method selection menu, and an analysis result output. FIG. 7 (a)
FIG. 7 is a diagram showing a state in which an object in the graph is selected. FIG. 7B is a diagram showing a state in which the analysis method is selected after the selection menu showing the analysis method is displayed. FIG. 7C is a diagram showing a state in which the analysis result is displayed.
Although the graph in this example is a bar graph, points (points of interest) corresponding to the numerical data in the table data 11 on the line graph may be used as the object. Further, each fan-shaped figure on the pie chart may be an object.

[0018]

According to the present invention, since the numerical data and the analysis method corresponding to the point of interest on the graph can be selected with one touch based on the graph, the operability of data analysis by the graph can be improved. it can.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of an apparatus according to an embodiment.

FIG. 2 is a diagram showing a data format of table data 11 according to the embodiment.

FIG. 3 is a diagram showing a data format of a selected object table 14 of the embodiment.

FIG. 4 is a diagram showing a data format of an analysis method selection menu 15 of the embodiment.

FIG. 5 is a flowchart showing a processing flow of an input determination processing unit 6 and an object selection processing unit 7 according to the embodiment.

FIG. 6 is a flowchart showing a processing flow of an analysis method selection processing unit 8 and an analysis execution processing unit 9 according to the embodiment.

FIG. 7 is a diagram showing a display example of a graph, an analysis method selection menu, and an analysis result output according to the embodiment.

[Explanation of symbols]

5 ... Graph drawing processing unit, 7 ... Object selection processing unit, 8 ... Analysis method selection processing unit, 9 ... Analysis execution processing unit, 11 ... Table data, 12 ... Display device ,
13 ... Input device, 14 ... Selection object table, 15 ... Analysis method selection menu

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Rie Matsui 12 890 Kashimada, Sachiku-ku, Kawasaki-shi, Kanagawa 12 Information Systems Division, Hitachi, Ltd. (72) Hiroyuki Shiga 6-chome, Fujimi, Kawasaki-ku, Kanagawa No. 3 Tokico Corporation

Claims (3)

[Claims] 1. A series of numerical data is graphically displayed on a display screen as a graph, and when a graphic forming a part of the graph is designated, the designated graphic is converted into corresponding numerical data and the numerical value is converted. A data analysis method using a displayed graph, which is characterized by displaying data. 2. A series of numerical data is graphically displayed as a graph on a display screen, and when a plurality of graphics forming a part of the graph are designated, the designated graphics are converted into corresponding numerical data. A data analysis method using a displayed graph, which comprises performing a specified operation on the converted numerical data and displaying the data of the operation result. 3. When two figures forming a part of the graph are designated, the designated figures are converted into corresponding numerical data, a comparison of the converted numerical data is calculated, and the calculation result is calculated. The data analysis method according to the displayed graph according to claim 1, which is displayed.