TW200949757A - Method and system for generating normalized graph for data sets - Google Patents

Method and system for generating normalized graph for data sets Download PDF

Info

Publication number
TW200949757A
TW200949757A TW97119669A TW97119669A TW200949757A TW 200949757 A TW200949757 A TW 200949757A TW 97119669 A TW97119669 A TW 97119669A TW 97119669 A TW97119669 A TW 97119669A TW 200949757 A TW200949757 A TW 200949757A
Authority
TW
Taiwan
Prior art keywords
data
normalized
data set
vertical axis
graph
Prior art date
Application number
TW97119669A
Other languages
Chinese (zh)
Other versions
TWI485645B (en
Inventor
Chang-Shan Zhuang
Hao-Yuan Zhuang
Original Assignee
Chii Ying Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Chii Ying Co Ltd filed Critical Chii Ying Co Ltd
Priority to TW97119669A priority Critical patent/TW200949757A/en
Priority to US12/220,639 priority patent/US20090027395A1/en
Publication of TW200949757A publication Critical patent/TW200949757A/en
Application granted granted Critical
Publication of TWI485645B publication Critical patent/TWI485645B/zh

Links

Abstract

A method and system for generating normalized graph for data sets is disclosed, to be installed to an electronic device. The electronic device includes: a user interface for allowing user input of an input instruction associated with the data sets; a reader for reading the data sets in accordance with the input instruction; a normalization module; a boundary-setting module; and a graph-presenting module. The normalization module, for each of the data sets, divides the data points of the data set by a scalar, the scalar being a maximum absolute value among the data points of the data set. The boundary-setting module sets +1 as the first boundary of a first coordinate axis and the normalized minimum value as the second boundary, or sets -1 as the second boundary of the first coordinate axis and the normalized maximum value as the first boundary, or sets +1 and -1 as the first and second boundaries of the first coordinate axis, respectively. This invention adopts a novel normalization process to convert data and the graph processed by this invention can maintain the positive and negative characteristics of the data while clearly displaying trends and changes.

Description

200949757 九、發明說明: 【發明所屬之技術領域】 本發明疋有關於一種由多組數據組自動產生圖形之方 法,特別是指一種去除數據組之間尺度(scale)及單位影 響的數據組的正規化圖形產生方法。 【先前技術】 當人們想對各數據進行比較或分析,使用現有製圖工 具,如EXCEL,一般來說是將該等數據組以單一縱軸、單 一顯示比例繪製在同一圖形上時,則可得到例如圖丨所示 的圖形。圖1是一 1984年至20〇4年間通膨率(Inflati〇n rate )、經濟成長率(Economic growth rate )、平均失業率( Average unempi〇yment rate )、平均金價(Average G〇ld price)及調整後油價(infiati〇11 Adjusted Oil price)五個數 據的曲線圖。該五組數據組單位不盡相同,且數值範圍、 尺度不一,尤其通膨率、經濟成長率、平均失業率等數值 範圍小的數據組,幾乎看不出曲線的起伏,閱圖者由圖i 難以看出任何訊息。 為了能對各數據進行比較或分析’目前處理方式是由 數據分析人員自行編寫結構化查詢語言(structured query ianguage,SQL)來比較數據,或使用例如線上200949757 IX. Description of the Invention: [Technical Field] The present invention relates to a method for automatically generating graphics from a plurality of sets of data sets, and more particularly to a data set for removing scale and unit influence between data sets. Normalized graphics generation method. [Prior Art] When people want to compare or analyze each data, using existing drawing tools, such as EXCEL, generally, when the data sets are drawn on the same graph with a single vertical axis and a single display scale, For example, the graphic shown in Figure 。. Figure 1 shows the inflation rate (Inflati〇n rate), economic growth rate, average unempi〇yment rate, and Average G〇ld price from 1984 to 2012. And a graph of five data for infiati〇11 Adjusted Oil price. The data sets of the five groups of data are not the same, and the range of values and scale are different. Especially the data sets with small numerical ranges such as inflation rate, economic growth rate, and average unemployment rate, almost no curve fluctuations are seen. Figure i is difficult to see any message. In order to be able to compare or analyze each data, the current processing method is to use a structured query language (SQL) to compare data, or use, for example, online

刀析處理(online analytical processing,OLAP )之分析工具進行數據分類、比對相關數據。然而,不論 利用何種數據分析方式,在圖形表示方面,現有製圖工具 並無法提供直接且有用的功能選項以讓繪圖人員有統一的 5 200949757 準則可依循,因此繪圖人員難以繪出顯示比例最大且合理 、客觀的圖形。因此’若要利用既有製圖工具產生合理、 客觀而可信的圖形,得仰賴製圖人員事先自行做正確的資 料轉換,因此可説,現有製圖工具功能十分有限。 【發明内容】 因此,本發明之目的,即在提供一種使多組數據組之 曲線去除尺度及举位因素而呈現在同一張圖上的正規化圖 形產生方法及系統’可不影響數據本身正負性質,且確保 經正規化處理的數據介於+ 1與_1之間。 於是,本發明正規化圖形產生系統是安裝於一電子裝 置,並包含一使用者介面、一讀取模組、一正規化模組、 一上下限決定模組,及一示圖模組。其中,使用者介面供 繪圖者利用自行輸入或自一資料庫選取的方式,產生一輸 入多組數據組的輸入指令。讀取模組則依據該輸入指令讀 取數據组。 正規化模組用以將每一數據組中的每個數據除以一正 規化因子,該正規化因子是各該數據組中每個數據取絕對 值後的最大值。 上下限決定模組以+1作為縱軸的上限且該等數據組經 正規化模組處理後的最小值為縱軸的下限,或者,以·!作 為縱軸的下限且該等數據組經正規化模組處理後的最大值 為縱軸的上限’或者,以+1與]作為縱軸的上限與下限。 _ 丁圖模組最後使該等經正規化模組處理後的數據組標 丁在圖形上,该圖形的縱軸的上限與下限由該上下限決 6 200949757 定模組所決定。 本發明數據組的正規化圖形產生方法則是包 驟: 1.讀取多組數據組。 2·將每一數據組中的每個數據除以一正規化因子,該 正規化因?是該數據組中每個數據的絕對值當中的 最大值。 3. 以Ή #為縱軸的上限且該等數據組經正規化處理後 的最小值為縱軸的下限’或者,以-1作為縱軸的下 限且該等數據組經正規化處理後的最大值為縱轴的 上限,或者,以+1與_1作為縱軸的上限與下限。 4. 使該等經正規化處理後的數據組標示在一圖形上, 該圖形的上限與下限已由前一步驟決定。 本發明的功效在於:藉由新的正規化方法,使每一數 據組中的數據除以該數據組中每個數據取絕對值後的最大 值,達到不影響數據本身正負性質且確保經正規化處理的 數據;I於+1與-1之間的目的,所得到的圖形可清楚呈現趨 勢及變動。 【實施方式】 有關本發明之前述及其他技術内容、特點與功效,在 以下配合參考圖式之一個較佳實施例的詳細說明中,將可 清楚的呈現。 如圖2所示,本發明數據組的正規化圖形產生系統1〇〇 的較佳實施例安裝於一電腦,但不以此為限,也可以是安 200949757 裝於一個人數位助理(PDA)、智慧型手機(smart ph〇ne) 等電子裝置。本實施例正規化圖形產生系統100包含—供 使用者操作而產生輸入指令的使用者介面12、一與使用者 介面12連接以接收輸入指令並用以讀取數據組的讀取模組 13、一與讀取模組13連接且用以對該等數據組進行正規化 運算處理的正規化模組14、一與正規化模組14連接的上下 限決定模組15,及一最後繪出圖形的示圖模組16。在本實 施例’示圖模組16是以繪出曲線圖舉例說明,但並不以此 為限,本發明之示圖模組16也可以預先設定繪出長條圖, 或曲線與長條混合的圖形’且該示圖模組16可連接電腦的 顯示器或印表機以進行圖形輸出。 本實施例是以使用者介面12與一如圖2所示的數據組 資料庫11連結舉例說明,該數據組資料庫丨丨’中儲存有多數 組以EXCEL或其他任何電腦可讀取之格式儲存的數據組。 配合參閱圖3,繪圖者可透過使用者介面12選取該數據組 貝料庫11内的其中多組數據組,並輸入有關限定期間或數 據格式等的限制條件,使用者介面12據此產生一輸入指令 。當然’使用者介φ 12㈣式以及操作模式不以本實施例 為限,也可以是由繪圖者自行輸入多組數據。 ”月同時參考圖2及圖4,本發明數據組之正規化圖形產 生系統100的讀取模組13在接獲來自使用者介面12的輸 入私令之後,與正規化模組14、上下限決定模組〗5及示圖 模組16接著進行如圖4所示的正規化圖形產生方法的步驟 200949757 ’ 步驟si㉟取模組13依輸人指令在該數據組資料庫 ’ 11讀取«取的輯組。在此㈣件【表-】所示數據组 舉例說明。 ’ 步驟S2-正規化模組14將每—數據組中的每個數據( 乃…凡)除以一正規化因子,求得如附件【表二】所示之數 據。該正規化因子是指各數據組中每個數據取絕對值後的 最大值。因此,在本實施例中,對於本步驟的實際執行方 式是包含以下細步驟(每一數據組個別處理): ® i.將所有數據乃…凡取絕對值,得到|丨I | 0 。也就是說,[/=Μ4Χ(]〇λ|)。 當然,本步驟也可以在將所有數據取絕對值之前先 作排序,得到的序列,直接找出最大值〜及最小值 «”,則正規化因子。 當每一數據組中的所有數據皆除以其正規化因子,所 Φ 得到的正規化數據組1乃1爪、…k|/t/,相當於去除單位,且 保留數據原本的正負性質,範圍將界於+1與_丨之間。 值得一提的是,本發明雖採用「正規化」一詞,但在 此所謂正規化,有別於資料庫的正規化(剔除相同的數據 荨步驟),也與目别數學及統計領域所採用的數值正規化方 式不同,一般數值正規化是指〇至+ 1的正規化,並不適用 於有負值的數據,其他數值正規化的方法,還包括有最大 最丨、正規化方法(每一數據減最小值,再除以最大值與最 J值的差)、標準差正規化方法(每一數據減數據組的平均 9 200949757 數,再除以標準差)Α .巷+ ;甚至還有向量正規化方法(每一向量 除以該向量的純量)簟,*政 里^…寺,本發明正規化圖形產生系統1〇〇 的正規化模組14所執行的方法,是有別於前述各種習知正 規化方法的新的正規化方法。 ❹An analytical tool for online analytical processing (OLAP) performs data classification and comparison of related data. However, regardless of the data analysis method used, the existing mapping tools do not provide direct and useful functional options to allow the drafters to have a uniform 5 200949757 guidelines, so it is difficult for the drafter to draw the largest display ratio. Reasonable and objective graphics. Therefore, if you want to use existing mapping tools to produce reasonable, objective and credible graphics, you have to rely on the cartographers to do the correct data conversion in advance. Therefore, the existing mapping tools have very limited functions. SUMMARY OF THE INVENTION Accordingly, it is an object of the present invention to provide a method and system for normalizing graphics that are presented on a same graph by removing the scales and lifting factors of a plurality of sets of data sets, without affecting the positive and negative nature of the data itself. And ensure that the normalized data is between + 1 and _1. Therefore, the normalized graphics generating system of the present invention is mounted on an electronic device and includes a user interface, a reading module, a normalizing module, an upper and lower limit determining module, and a graphics module. The user interface is used by the mapper to generate an input command for inputting multiple sets of data sets by means of self-input or selection from a database. The read module reads the data set according to the input instruction. The normalization module is configured to divide each data in each data group by a normalization factor, which is the maximum value after each data in each data group takes an absolute value. The upper and lower limits determine that the module has +1 as the upper limit of the vertical axis and the minimum value of the data sets processed by the normalization module is the lower limit of the vertical axis, or, by As the lower limit of the vertical axis, the maximum value of the data sets processed by the normalization module is the upper limit of the vertical axis or the upper and lower limits of the vertical axis are taken as +1 and ]. _ The Ding diagram module finally marks the data set processed by the normalized modules on the graph, and the upper and lower limits of the vertical axis of the graph are determined by the upper and lower limits. The normalized graph generation method of the data set of the present invention is a package: 1. Read a plurality of sets of data sets. 2. Divide each data in each data set by a normalization factor. What is the normalization factor? Is the maximum of the absolute values of each data in the data set. 3. Ή # is the upper limit of the vertical axis and the minimum value of the normalization of the data sets is the lower limit of the vertical axis' or -1 is the lower limit of the vertical axis and the data sets are normalized. The maximum value is the upper limit of the vertical axis, or +1 and _1 are the upper and lower limits of the vertical axis. 4. Mark the normalized data sets on a graph whose upper and lower limits have been determined by the previous step. The effect of the present invention is that, by the new normalization method, the data in each data group is divided by the maximum value of each data in the data group, and the positive and negative properties of the data itself are ensured and the formality is ensured. The processed data; I is between +1 and -1, and the resulting graph clearly shows trends and changes. The above and other technical contents, features, and advantages of the present invention will be apparent from the following detailed description of the preferred embodiments. As shown in FIG. 2, the preferred embodiment of the normalized graphics generating system 1 of the data set of the present invention is installed in a computer, but not limited thereto, and may be installed in a number of assistants (PDAs). Electronic devices such as smart phones (smart ph〇ne). The normalized graphics generating system 100 of the present embodiment includes a user interface 12 for inputting an instruction by a user, a reading module 13 connected to the user interface 12 for receiving an input command, and for reading a data group. a normalization module 14 connected to the reading module 13 for performing normalization processing on the data groups, an upper and lower limit determination module 15 connected to the normalization module 14, and a final graphic drawing Diagram module 16. In the present embodiment, the diagram module 16 is illustrated by a graph, but is not limited thereto. The diagram module 16 of the present invention can also pre-set to draw a bar graph, or a curve and a strip. The mixed graphics 'and the graphics module 16 can be connected to a computer display or printer for graphics output. In this embodiment, the user interface 12 is connected with a data group database 11 as shown in FIG. 2, and the data group database 丨丨' stores multiple arrays in EXCEL or any other computer readable format. The stored data set. Referring to FIG. 3, the mapper can select a plurality of data sets in the data set bezel 11 through the user interface 12, and input restrictions on the limited period or data format, etc., and the user interface 12 generates a data accordingly. Enter the command. Of course, the user φ 12 (four) formula and the operation mode are not limited to the embodiment, and the plurality of sets of data may be input by the mapper. Referring to FIG. 2 and FIG. 4 simultaneously, the reading module 13 of the normalized graphic generation system 100 of the data set of the present invention, after receiving the input private order from the user interface 12, and the normalization module 14, upper and lower limits The decision module 〖5 and the diagram module 16 then perform the step of normalizing the pattern generation method shown in FIG. 4 200949757 'step si35 takes the module 13 according to the input command in the data group database '11 read «take The data set shown in (4) [Table -] is illustrated. 'Step S2 - Normalization module 14 divides each data in the data set (ie...) by a normalization factor, The data shown in the attached table [Table 2] is obtained. The normalization factor is the maximum value after each data in each data group takes an absolute value. Therefore, in this embodiment, the actual execution mode for this step is The following detailed steps are included (each data set is processed individually): ® i. Take all the data as... take the absolute value and get |丨I | 0. That is, [/=Μ4Χ(]〇λ|). Of course, This step can also be sorted before all data is taken as absolute values. Sequence, directly find the maximum value ~ and the minimum value «", then the normalization factor. When all the data in each data group is divided by its normalization factor, the normalized data set 1 obtained by Φ is 1 claw, ... k|/t/, which is equivalent to the removal unit, and retains the original positive and negative properties of the data. The range will be between +1 and _丨. It is worth mentioning that although the invention adopts the term “normalization”, the so-called formalization here is different from the formalization of the database (excluding the same data and steps), and also in the field of mathematics and statistics. The numerical normalization method is different. The general numerical normalization refers to the normalization of 〇 to + 1, and is not applicable to data with negative values. The other methods of normalization of values also include the largest and most normalized method. Each data minus the minimum value, divided by the difference between the maximum value and the maximum J value), the standard deviation normalization method (the average of each data minus the data set 9 200949757, divided by the standard deviation) Α. Lane + ; even There is also a vector normalization method (each vector is divided by the scalar quantity of the vector) 簟, * 政里^... Temple, the normalized graphics generation system of the present invention is executed by the normalization module 14 Different from the new formalization methods of the various conventional normalization methods mentioned above. ❹

步驟S3-在本實施例,上下限決定模組15與使用者介 面12連接’由繪圖者透過操作使用者介面η決定圖形的 上 '下限類型—直接以+1與·1作為縱軸的上限與下限(命 名為正規圖),或是使圖形展開到最大(命名為正規放大圖 )也就疋只定+ 1為上限或·i為下限未定的一邊則以正規 化數據組的最小值為下限或最大值為上限。當然,上、下 限的決定不以本實施例為限,也可以不透過使用者介面12 而疋由上下限決定模組1 5直接設定。 當緣圖者欲使數據組的正負散佈情況清楚展示,可透 過使用者介面12 ϋ擇以+1與_!作為縱軸的上限與下限,則 將在下-步驟中獲得如目5所示的圖形。當_者欲使數 據組的曲線佈滿圖形,也就是說使圖形展開到最大,則透 過使用者介面12選擇,則上下限決定模組15依據該等正 規化之數據組中的數據,找出最大值為+1定為上限,且找 出最小值為代表經濟成長率之正規化數據組的最小值_〇171 為下限,而在下一步驟中獲得如圖6所示的圖形。 步驟S4—示圖模組16依據上下限決定模組15所決定 的上限與下限,並使該等經正規化模組處理後的數據組標 示在一圖形上,獲得如圖5或如圖6所示的圖形。 值得一提的是,當示圖模組16所繪製的圖形是設定為 10 200949757 長條圖時,為避免當中最小之數據在圖中無法呈現,本發 明下限決定模組15所訂定之上、下限,也可以各增加 =,例如各外推-或半個轴距,或…倍的軸距。 轴距纽縱軸的上 '下限距離除以該縱轴的格數。 此外,本實施例是以單縱軸圖形舉例說明,作不以單 抽為限’例如也可以應时雙縱_形-讀取模組13讀取 兩組(或多組)數據組’示圖模組16將其中一(或多组) ❹ 數據組正規化後以左轴為參考軸進行標示,其餘數據組正 規化後以右轴為參考軸進行標示,且該圖形之左、右軸的 上限與下限是由上下限蚊難15依正規化讀據組分布 的特性(例如,多組數據組當中,有些數據組正規化之後 最小值未達],則這些數據組可—起參考左軸,左軸上、下 限分別為+1與最小值;有些數據組正規化之後最大值未達 +卜則這些數據組可-起參考右軸,右軸上、下限分別為 最大值與-1)個別地決定,不須一致。 為清楚說明本發明正規化圖形產生系統及方法應用於 不同類型的數據組皆能產生有用的功效,以下再舉另一例 子演算說明。 3月參閱圖7,是一代表總收入(revenue )、銷售成本( cost of g00ds s〇ld)、毛利(gr〇ss pr〇fit)、費用(expense) ,及淨利(net income)的曲線圖,數據詳列於附件【表三 圖7為利用EXCEL自動作圖得到,但無法清楚看出各 曲線的起伏;為清楚呈現以上數據組在不同年度月份的變 11 200949757 化趨勢,可利用本發明數據組的正規化圖形產生系統ι〇〇, 執行前述正規化以及決定上下限等步驟,得到如圖8所示 之圖形,且對應的正規化數據詳列於附件【表四】。 由於該五數據組經正規化處理後,當中的最大值是+ι ,最小值是-1,因此無論繪圖者透過使用者介面12選擇何 種圖形的上、下限類型,或是由上下限決定模組15直接設 定,以該五數據組來說,只會獲得上限為+1且下限為_丨的 圖形。 在此需說明的是,雖本發明以及實施例採「縱軸」一 詞,但實質上的意義指的是一標示「數據組」值的座標軸 ,常見之圖形是如圖5等圖所示:數據組的值對應「縱軸」 (或稱「y轴」)標示,但不以此為限,若使圖形旋轉9〇。 ’也就是使數據組的值對應「橫軸」標示,只是簡單的變 化,也應在本發明所主張範圍内。 歸納上述,採用本發明的創新的正規化演算方式,可 避免習知利用標準差作為正規化因子可能有標準差本身接 近〇的問題,也可避免正規化因子出現負號而導致數據正 規化處理後變號的問題’利用本發明繪出的圖形可供閱圖 者清楚看出數據的趨勢及變動情形,確實可達到本發明之 目的。 惟以上所述者,僅為本發明之較佳實施例而已,當不 能以此限定本發明實施之範圍’即大凡依本發明申請專利 範圍及發明說明内容所作之簡單的等效變化與修飾,皆仍 屬本發明專利涵蓋之範圍内。 12 200949757 【圖式簡單說明】 圖1是一利用EXCEL自動繪出的通膨率、經濟成長率 、平均失業率、平均金價及調整後油價的曲線圖; 圖2是一系統方塊圖,說明本發明數據組的正規化圖 形產生系統的較佳實施例; 圖3是一表示該數據組的正規化圖形產生系統的使用 者介面的示意圖; 圖4是一流程圖’說明本發明數據組的正規化圖形產 生方法的較佳實施例; 圖5是一利用該本發明數據組的正規化圖形產生系統 所繪製的通膨率、經濟成長率、平均失業率、平均金價及 調整後油價的曲線圖; 圖6是另一利用該本發明數據組的正規化圖形產生系 統所繪製的通膨率、經濟成長率、平均失業率、平均金價 及調整後油價的曲線圖; 圖7是一利用EXCEL自動繪出的總收入、銷售成本、 毛利、費用,及淨利的曲線圖;及 圖8是一利用該本發明數據組的正規化圖形產生系統 所緣製的總收人、銷售成本、毛利、費用,及淨利的曲線 圖。 、、 13 200949757 【主要元件符號說明】 100… •…數據組的正規化 14. ........正規化模組 圖形產生系統 15. ........上下限決定模組 11…… …·數據組資料庫 16· ........示圖模組 12…… 13…… …·使用者介面 …·讀取模組 SL· 。S 4…步驟Step S3 - In this embodiment, the upper and lower limit determining module 15 is connected to the user interface 12. The upper limit of the lower limit type of the graphic is determined by the mapper through the user interface η. The upper limit of the vertical axis is directly set by +1 and ·1. And the lower limit (named as a regular map), or to expand the graph to the maximum (named as a normal enlargement map), then only set +1 as the upper limit or ·i is the lower limit, the minimum value of the normalized data set is The lower limit or maximum value is the upper limit. Of course, the upper and lower limits are not limited to the present embodiment, and may be directly set by the upper and lower limit determination modules 15 without passing through the user interface 12. When the edge imager wants to clearly display the positive and negative dispersion of the data set, the upper and lower limits of the vertical axis can be selected through the user interface 12 by +1 and _!, and the next step is obtained as shown in FIG. Graphics. When the _ person wants to make the curve of the data group full of graphics, that is, to expand the graphic to the maximum, and then select through the user interface 12, the upper and lower limit determining module 15 searches according to the data in the normalized data group. The maximum value is set to +1 as the upper limit, and the minimum value is found as the minimum value of the normalized data group representing the economic growth rate, 〇 171 is the lower limit, and the graph shown in FIG. 6 is obtained in the next step. Step S4—the diagram module 16 determines the upper and lower limits determined by the module 15 according to the upper and lower limits, and marks the data group processed by the normalized module on a graphic, as shown in FIG. 5 or FIG. 6 . The graphics shown. It is worth mentioning that when the graph drawn by the diagram module 16 is set to 10 200949757 bar graph, in order to prevent the smallest data from being rendered in the graph, the lower limit determining module 15 of the present invention is set above The lower limit can also be increased by, for example, each extrapolation - or half of the wheelbase, or ... times the wheelbase. The upper 'lower limit distance of the vertical axis of the wheelbase is divided by the number of grids of the vertical axis. In addition, this embodiment is exemplified by a single vertical axis graph, and is not limited to a single pumping. For example, the double vertical _-shaped reading module 13 may read two sets (or groups of data groups). The graph module 16 normalizes one (or more) ❹ data sets and marks them with the left axis as a reference axis. The remaining data sets are normalized and then labeled with the right axis as the reference axis, and the left and right axes of the graph are displayed. The upper and lower limits are characterized by the distribution of the upper and lower limit mosquitoes according to the normalized reading group (for example, among the multiple data sets, some of the data sets are not normalized after normalization), then these data sets can be referenced to the left. The upper and lower limits of the axis and the left axis are +1 and the minimum respectively; after some data sets are normalized, the maximum value is not up to + b. These data sets can be referenced to the right axis, and the upper and lower limits of the right axis are respectively the maximum value and -1 ) Individually decided, no need to be consistent. In order to clarify that the normalized graphics generation system and method of the present invention can be applied to different types of data sets, useful efficiencies can be produced, and another example of calculus is given below. See Figure 7 for March, which is a graph representing total revenue, cost of g00ds s〇ld, gross profit (gr〇ss pr〇fit), expense (expense), and net income (net income). The data is listed in the annex [Table 3, Figure 7 is obtained by using EXCEL automatic mapping, but the fluctuation of each curve cannot be clearly seen; in order to clearly show the trend of the above data group in different years of the year, the invention can be utilized. The normalized graph generation system of the data set generates the system ι〇〇, performs the aforementioned normalization and determines the upper and lower limits, and obtains the graph as shown in FIG. 8, and the corresponding normalized data is listed in the attached table [Table 4]. Since the five data sets are normalized, the maximum value is +ι and the minimum value is -1, so the plotter selects the upper and lower limit types of the graphic through the user interface 12, or the upper and lower limits. The module 15 is directly set, and in the case of the five data sets, only a graph with an upper limit of +1 and a lower limit of _丨 is obtained. It should be noted that although the present invention and the embodiment adopt the term "vertical axis", the substantial meaning refers to a coordinate axis indicating the value of the "data set". The common figure is as shown in FIG. 5 and the like. : The value of the data group corresponds to the "vertical axis" (or "y-axis"), but not limited to this, if the graphic is rotated by 9〇. That is, the value of the data set is indicated by the "horizontal axis", which is a simple change and should be within the scope of the present invention. In summary, the innovative normalization algorithm of the present invention can avoid the problem that the standard deviation can be used as a normalization factor, and the standard deviation itself is close to 〇, and the normalization factor can be avoided to cause the data to be normalized. The problem of the post-variation 'The graphs drawn by the present invention are available to the viewer to clearly see the trend and changes of the data, and indeed achieve the object of the present invention. However, the above is only a preferred embodiment of the present invention, and is not intended to limit the scope of the present invention, that is, the simple equivalent changes and modifications made by the scope of the invention and the description of the invention, All remain within the scope of the invention patent. 12 200949757 [Simple diagram of the diagram] Figure 1 is a graph of inflation rate, economic growth rate, average unemployment rate, average gold price and adjusted oil price automatically drawn by EXCEL; Figure 2 is a system block diagram illustrating this A preferred embodiment of a normalized graphics generation system for inventing a data set; FIG. 3 is a schematic diagram showing a user interface of a normalized graphics generation system for the data set; FIG. 4 is a flow chart illustrating the regularization of the data set of the present invention A preferred embodiment of the method for generating graphics; FIG. 5 is a graph of inflation rate, economic growth rate, average unemployment rate, average gold price, and adjusted oil price plotted by a normalized graph generation system using the data set of the present invention; Figure 6 is a graph showing the inflation rate, economic growth rate, average unemployment rate, average gold price, and adjusted oil price plotted by the normalized graph generation system using the data set of the present invention; Figure 7 is an automatic use of EXCEL a graph of total revenue, cost of sales, gross profit, cost, and net profit; and FIG. 8 is a normalized graph generation system using the data set of the present invention A graph of the total income, cost of sales, gross profit, expenses, and net profit of the system. , 13 200949757 [Description of main component symbols] 100... •...normalization of data sets 14. ........ normalized module graphics generation system 15. ........ upper and lower limits determine mode Group 11 ... .... Data Group Database 16 · ........ Diagram Module 12 ... 13 ... ... User Interface... Read Module SL·. S 4...step

1414

Claims (1)

200949757 十、申請專利範圍: • 種數據組的正規化圖形產生方法,透過電子裝置實現 ,並包含以下步驟: 讀取多組數據組; 將每一數據組中的每個數據除以一正規化因子,該 正規化因子是該數據組中每個數據的絕對值當中的最大 值; 以+1作為縱轴的上限且該等數據組經正規化處理後 ® 的最小值為縱轴的下限,或者,以·ι作為縱軸的下限且 該等數據組經正規化處理後的最大值為縱軸的上限或 者’以+1與-1作為縱軸的上限與下限;及 使該等經正規化處理後的數據組標示在一圖形上, 該圖形的上限與下限已由前一步驟決定。 2. 依據申4專利範圍第丨項所述之數據組的正規化圖形產 生方法,其中,該正規化因子的決定方式,是先將所有 數據(乃…凡)取絕對值,得到hi…Id,接著取當中的 最大值作為正規化因子U 。 3. 依據申請專利範圍第丨項所述之數據組的正規化圖形產 生方法’其中’該正規化因子的決定方式,是先作排序 ’知到fll α"的序列,得出最大值%及最小值,接著 取正規化因子。 4. 依據申請專利範圍第1項所述之數據組的正規化圖形產 生方法’其中,該等經正規化處理後的數據組標示在一 單縱軸圖形上。 15 200949757 5. 依據申請專利範圍第1項所述之數據組的正規化圖形產 生方法,其中,經正規化處理後的數據組標示在一雙縱 軸圖形上’該圖形之雙縱軸的上限與下限是個別獨立地 被決定。 6. 依據申請專利範圍第項中任一項所述之數據組的正 規化圖形產生方法,其中,該等經正規化處理後的數據 組其中至少一是標示呈曲線。 7. 依據申請專利範圍第1〜5項中任一項所述之數據組的正 ❹ 規化圖形產生方法,其中,該等經正規化處理後的數據 組其中至少一是標不呈長條。 8. 依據申晴專利範圍第7項所述之數據組的正規化圖形產 生方法,其中’更包含一增加邊寬的步驟。 9. 依據申請專利範圍第丨〜5項中任一項所述之數據組的正 規化圖形產生方法’其中,該等數據組經正規化處理後 ’當中的最大值被決定為上限,該等數據組經正規化處 理後,當中的最小值被決定為下限。 10. —種數據組的正規化圖形產生系統,安裝於一電子裝置 ,包含: 一使用者介面’供產生一内容包含多組數據組的輸 入指令; 一讀取模組’用以依據該輸入指令讀取數據組; 一正規化模組’用以將每一數據組中的每個數據除 以一正規化因子’該正規化因子是各該數據組中每個數 據取絕對值後的最大值; 16 200949757 一上下限決定模組,以+1作為縱軸的上限且該等數 據組經正規化模組處理後的最小值為縱軸的下限,或者 ,以-1作為縱轴的下限且該等數據組經正規化模組處理 後的最大值為縱軸的上限,或者,以+1心作為縱轴的 上限與下限;及 不圖模組,使該等經正規化模組處理後的數據組 心示在圖形上,該圖形的縱軸的上限與下限由該上下 限決定模組所決定。 ©比依據申請專利範圍帛10項所述之數據組的正規化圖形產 生系統,其_,該使用者介面與一數據組資料庫連結, 該數據組資料庫儲存有多數組數據組,該使用者介面供 選取該數據組資料庫内的其中多組數據組,並據此產生 該輸入指令。 12.依據申味專利範圍第丨〇項所述之數據組的正規化圖形產 生系統,其中,該使用者介面供自行輸入多組數據組, 並據此產生該輸入指令。 ❹13·依射請專利範圍帛1()項所述之數據組的正規化圖形產 生系統,其中,該上下限決定模組與該使用者介面連接 ,該使用者介面供選擇決定圖形的上、下限類型。 14.依據申請專利範圍第1〇項所述之數據組的正規化圖形產 生系統’其中’該示圖模組將該等經正規化處理後的數 據組標示在一單縱軸圖形上。 15·依據申請專利範圍第1〇項所述之數據組的正規化圖形產 生系統’其中’該示圖模組將經正規化處理的數據組標 17 200949757 不在—雙縱轴圖形上,該圖形之雙縱轴的上限與下限是 由該上下限決定模組個別地被決定。 16.依據申請專利範圍第10〜15項中任一項所述之數據組的 正規化圖形產生系統,其中,該示圖模組使該等經正規 化處理之數據組其中至少一標示呈曲線。 依據申請專利範圍第1〇〜15項中任一項所述之數據組的 正規化圖形產生系統,其中’該示圖模組使該等經正規 化處理之數據組其中至少一標示呈長條。 €> 18.依據巾請專利範圍第17項所述之數據組的正規化圖形產 生系統,其中,該上下限決定模組所訂定的上、下限還 各增加一邊寬。 19.依據申請專利範圍第1〇〜15項中任一項所述之數據組的 正規化圖形產生系統,其中,該上下限決定模組依據該 等正規化之數據組中的數據,找出當中的最大值定為上 限,且找出當中的最小值定為下限。200949757 X. Patent application scope: • The method of normalizing graphics generation of data sets is implemented by electronic devices and includes the following steps: reading multiple sets of data sets; dividing each data in each data set by a normalization Factor, the normalization factor is the maximum of the absolute values of each data in the data set; +1 is the upper limit of the vertical axis and the minimum value of the data sets after normalization is the lower limit of the vertical axis, Alternatively, ι is the lower limit of the vertical axis and the maximum value of the data sets after normalization is the upper limit of the vertical axis or '+1 and -1 are the upper and lower limits of the vertical axis; The processed data set is marked on a graph whose upper and lower limits have been determined by the previous step. 2. The normalized graph generation method according to the data group described in the fourth paragraph of the patent scope of claim 4, wherein the normalization factor is determined by taking all data (ie, ...) as absolute values to obtain hi...Id Then, take the maximum value as the normalization factor U. 3. According to the normalized graph generation method of the data set described in the scope of the patent application scope, the method for determining the normalization factor is to first sort the sequence of 'fll α" to obtain the maximum value % and The minimum value, followed by the normalization factor. 4. The normalized pattern generation method of the data set according to item 1 of the patent application scope wherein the normalized data group is indicated on a single vertical axis graph. 15 200949757 5. A method for generating a normalized graph of a data set according to claim 1, wherein the normalized data set is marked on a double vertical axis graph; the upper limit of the double vertical axis of the graphic The lower limit is determined individually and independently. 6. The method of generating a normalized graph of a data set according to any one of the preceding claims, wherein at least one of the normalized data sets is labeled as a curve. 7. The method for generating a normalized pattern of a data set according to any one of claims 1 to 5, wherein at least one of the normalized data sets is a long strip. . 8. A method for generating a normalized pattern of data sets according to item 7 of the Shenqing patent scope, wherein the step further comprises a step of increasing the side width. 9. The method for generating a normalized pattern of a data set according to any one of the above-mentioned claims, wherein the maximum value of the data sets after being normalized is determined as an upper limit, After the data set is normalized, the minimum value is determined as the lower limit. 10. A normalized graphics generation system for a data set, installed in an electronic device, comprising: a user interface 'for generating an input command containing a plurality of data sets; a read module' for using the input The instruction reads the data set; a normalization module 'is used to divide each data in each data group by a normalization factor'. The normalization factor is the maximum after each data in each data group takes an absolute value. Value; 16 200949757 An upper and lower limit decision module, with +1 as the upper limit of the vertical axis and the minimum value of the data sets processed by the normalization module as the lower limit of the vertical axis, or -1 as the lower limit of the vertical axis And the maximum value of the data sets processed by the normalization module is the upper limit of the vertical axis, or the upper limit and the lower limit of the vertical axis are used as the vertical axis; and the non-image module is used to process the normalized modules. The subsequent data set is shown on the graph, and the upper and lower limits of the vertical axis of the graph are determined by the upper and lower limit determining modules. © a normalized graphics generation system according to the data set described in claim 10, wherein the user interface is linked to a data set database, the data set database storing a plurality of array data sets, the use The interface is configured to select a plurality of sets of data sets in the data set database, and generate the input instruction accordingly. 12. The normalized graphics generation system of the data set according to the scope of the patent application scope, wherein the user interface is configured to input a plurality of data sets by itself and generate the input instruction accordingly. ❹13· 依 请 请 请 专利 专利 专利 专利 专利 专利 专利 专利 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规 正规The lower limit type. 14. The normalized graphics generation system of the data set described in the first paragraph of the patent application scope' wherein the graphics module labels the normalized data packets on a single vertical axis graph. 15. The normalized graphics generation system according to the data set of claim 1 wherein the graphics module normalizes the data set 17 200949757 not on the double vertical axis graph, the graphic The upper and lower limits of the double vertical axes are individually determined by the upper and lower limit determining modules. 16. The normalized graphics generation system of the data set of any one of clauses 10 to 15, wherein the diagram module causes at least one of the normalized data sets to be labeled as a curve. . A normalized graphics generating system for a data set according to any one of claims 1 to 15, wherein the graphics module causes at least one of the normalized data sets to be marked as a strip . 18. The normalized pattern generation system of the data set according to item 17 of the patent application scope, wherein the upper and lower limits set by the upper and lower limit determination modules are each increased by one side. The normalized graphics generating system of the data set according to any one of the preceding claims, wherein the upper and lower limit determining module finds according to the data in the normalized data set. The maximum value is set as the upper limit, and the minimum value found is the lower limit. 1818
TW97119669A 2007-07-26 2008-05-28 Method and system for generating normalized graph for data sets TW200949757A (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
TW97119669A TW200949757A (en) 2008-05-28 2008-05-28 Method and system for generating normalized graph for data sets
US12/220,639 US20090027395A1 (en) 2007-07-26 2008-07-24 Machine-implemented method and electronic device for presenting a normalized graph for a plurality of data sets

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW97119669A TW200949757A (en) 2008-05-28 2008-05-28 Method and system for generating normalized graph for data sets

Publications (2)

Publication Number Publication Date
TW200949757A true TW200949757A (en) 2009-12-01
TWI485645B TWI485645B (en) 2015-05-21

Family

ID=44871095

Family Applications (1)

Application Number Title Priority Date Filing Date
TW97119669A TW200949757A (en) 2007-07-26 2008-05-28 Method and system for generating normalized graph for data sets

Country Status (1)

Country Link
TW (1) TW200949757A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8884965B2 (en) 2010-09-14 2014-11-11 Chii Ying Co., Ltd. Machine-implemented method and an electronic device for graphically illustrating a statistical display based on a set of numerical data, and a computer program product

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP3217449B2 (en) * 1992-05-08 2001-10-09 キヤノン株式会社 Information processing apparatus and information processing method
US20030165924A1 (en) * 2000-04-05 2003-09-04 Dov Shiffman Genes expressed in foam cell differentiation
US7084394B2 (en) * 2002-09-25 2006-08-01 Ionalytics Corporation FAIMS apparatus and method for separating ions
KR100512965B1 (en) * 2003-03-14 2005-09-07 삼성전자주식회사 A apparatus and method for detecting frequency error based on histogram information of input signal
US8689137B2 (en) * 2005-09-07 2014-04-01 Microsoft Corporation Command user interface for displaying selectable functionality controls in a database application
WO2007087040A2 (en) * 2006-01-13 2007-08-02 Luna Innovations Incorporated Demodulation method and apparatus for fiber optic sensors

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8884965B2 (en) 2010-09-14 2014-11-11 Chii Ying Co., Ltd. Machine-implemented method and an electronic device for graphically illustrating a statistical display based on a set of numerical data, and a computer program product
TWI557670B (en) * 2010-09-14 2016-11-11 Illustrated systems and computer program products related to financial products

Also Published As

Publication number Publication date
TWI485645B (en) 2015-05-21

Similar Documents

Publication Publication Date Title
US8749553B1 (en) Systems and methods for accurately plotting mathematical functions
WO2019127821A1 (en) Method and apparatus for making visualization report, terminal device, and storage medium
CN111932534B (en) Medical image picture analysis method and device, electronic equipment and readable storage medium
CN111433762A (en) Graphically organizing content in a user interface of a software application
CN112883042A (en) Data updating and displaying method and device, electronic equipment and storage medium
WO2021189827A1 (en) Method and apparatus for recognizing blurred image, and device and computer-readable storage medium
CN113326314B (en) Data visualization method, device, electronic equipment and readable storage medium
CN112949443A (en) Table structure identification method and device, electronic equipment and storage medium
CN113032403A (en) Data insight method, device, electronic equipment and storage medium
CN111753173A (en) Information query method and device
CN116644729A (en) Table file processing method, apparatus, computer device and storage medium
US20210286782A1 (en) Data complementing system and data complementing method
CN111401023B (en) Report generation method, report generation device, server and storage medium
TW200949757A (en) Method and system for generating normalized graph for data sets
CN112948705A (en) Intelligent matching method, device and medium based on policy big data
US11836445B2 (en) Spreadsheet table transformation
CN116311300A (en) Table generation method, apparatus, electronic device and storage medium
CN112561500B (en) Salary data generation method, device, equipment and medium based on user data
CN114004209A (en) PDF format data export method and device, electronic equipment and readable storage medium
CN112506976B (en) Data flow display method and device, electronic equipment and storage medium
CN102819564A (en) Method for generating report forms by limited table element combination
CN112434103A (en) Data display method and server
US11600028B1 (en) Semantic resizing of line charts
CN115758013B (en) Intelligent visual office method and device
CN112270350B (en) Method, apparatus, device and storage medium for portraying organization

Legal Events

Date Code Title Description
MM4A Annulment or lapse of patent due to non-payment of fees