CN104978305A - Intelligent computation method of statistical index on the basis of complex function formula - Google Patents
Intelligent computation method of statistical index on the basis of complex function formula Download PDFInfo
- Publication number
- CN104978305A CN104978305A CN201410135874.8A CN201410135874A CN104978305A CN 104978305 A CN104978305 A CN 104978305A CN 201410135874 A CN201410135874 A CN 201410135874A CN 104978305 A CN104978305 A CN 104978305A
- Authority
- CN
- China
- Prior art keywords
- statistical
- function formula
- statistics
- computation method
- intelligent
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an intelligent computation method of a statistical index on the basis of a complex function formula, and belongs to the statistical field. The method comprises the following steps: a user can dynamically select or alter the function formula and can carry out statistics through the intelligent identification judgment of the intelligent computation method. In addition to that the intelligent computation method can carry out the statistics on numeric-type data, the intelligent computation method has a most special advantage that the intelligent computation method can carry out mapping statistics on different types of data, the numeric-type data can be subjected to the statistics only by the selection of a correct function formula and an associated statistical subject of a correct data type, inter-data-type statistics can be carried out according to the statistical requirements of the user in a humanized way, and the user can carry out statistical condition setting and result statistics by own so as to better meet the statistical requirements of the user and improve statistical efficiency. The intelligent computation method is higher in applicability and is more compatible in various fields.
Description
Art
The present invention relates to statistics field, especially relate to a kind of statistical indicator intelligent computation method based on complicated function formula.
Background technology
Statistical system is in the past all added up by fixing function formula, as: statistical account A is the summation of subject B and subject C, wherein between statistical indicator is all fixing can not resetting in systems in which with relation and subject, must be added up by this fixing pattern, once the incidence relation between statistical indicator or statistical indicator changes, so whole statistical system just cannot be added up accurately again, and man power and material must be spent again to carry out the redevelopment of system for these subjects changed or subject relation.
In existing technology, also not having at present can intelligent decision choice function formula carrying out across the data type computing method of adding up.Computing method in the past also can realize statistics, but all confine cannot really to break through in these computing method simultaneously and cause identical statistical system redundancy, and such statistical has not met is particular about high efficiency society now.
Summary of the invention
The intelligent computation method of a dynamic change statistical relationship is invention broadly provides for the problems referred to above, this invention can independently revise statistical indicator and statistical relationship by system when changing by the statistical relationship between statistical indicator or statistical indicator, even can also independently arrange for some special statistical relationship users, to meet the demand that user carries out for special statistical relationship adding up.
For achieving the above object, the present invention mainly have employed following technical scheme:
1, the statistical relationship realized between all statistical indicators can revise selection dynamically, and no longer single statistical relationship fixing between certain two or certain several statistical indicator of fixing comprises the following steps to carry out statistics:
(1) arranging statistical indicator in system all can dynamic change, and statistical indicator comprises the attributes such as data type, statistical correlation index, statistical calculation method, default value.
(2) only have selected statistical correlation index just to select statistical calculation method and judge that whether data type of statistical indicator and statistical correlation index etc. is eligible again according to the design conditions of statistical calculation method to calculate, will point out user if do not meet and statistical correlation index that pathfinder selection is correct or computing method.
2, realize showing the conventional statistic demand that all statistical relationships obtained by generic function compute mode meet user in systems in which, as: as summation, quadrature, relative number, these functional operation such as average.
3, realize arranging to meet special statistical demand to the statistical relationship across data type, the present invention provides the standard format that complicated computing method are arranged in interface, and user can independently according to demand add up by standard.
Embodiment
In order to make object of the present invention and technical scheme, advantage more clear, below in conjunction with accompanying drawing, embodiment of the present invention is further described.
Fig. 1 is the conventional function formula that in the present invention, dynamic is selected.As shown in Figure 1, when newly-increased statistical indicator, if only need be added up by simple formula, then can directly select function formulas such as totalling, weighting, averages.Wherein first inductive statistics is carried out to the function formula that those are added up by numeric type data, first in interface, the function formula of the calculating of the function formula of complexity and numeric type data is calculated differentiation, if select simple formula, can the function formula of direct logarithm value type data select, but on backstage, newly-increased statistical indicator is carried out judging whether to belong to number percent with the data type associating statistical indicator, the data of integer type or Real-valued, wherein data type will judge according to mathematical law, two or more statistical indicator just must be selected just to add up by these function formulas statistics simultaneously, therefore also need on backstage to judge that the number of association statistical indicator is more than or equal to 2, whether the data type simultaneously needing the title obtaining statistical indicator in interface then to carry out these statistical indicators of matching judgment with the data in database all belongs to numeric type, then by the ID of function formula different function formulas distinguished and give different computing method to add up.
Fig. 2 is the complicated function formula independently dynamically arranged in the present invention.As shown in Figure 2, the present invention summarizes 5 kinds of complicated statistical calculation methods across data type according to market statistics demand, these statistical calculation methods all can only select a statistical correlation index to carry out one_to_one corresponding and map statistics but these statistical calculation methods can arrange multiple condition to carry out again and map statistics and greatly save time of statistics simultaneously, improve the efficiency of statistics.The data acquisition of these complicated function formula is all judged by the difference of the formula of the data type between them or backstage typing on backstage.
Wherein the statistics of the corresponding text-type of date type as shown in Figure 2, this statistical method needs the data type judging newly-increased statistical indicator on backstage to be belong to text-type, judge that the association statistical indicator selected belongs to date type, and the data requiring user to input also meet these judges requirement.Wherein the collection of back-end data is to carry out typing according to the form in Fig. 2, condition and result are distinguished by braces, and the data in condition and result distinguish one_to_one corresponding statistics by branch, be the data of a data acquisition correspondence display text-type of a date type in brief.
Wherein the corresponding text-type of numeric type as shown in Figure 2, this statistical method needs the data type judging newly-increased statistical indicator on backstage to be belong to numeric type, judging that the association statistical indicator selected belongs to text-type, is that the data acquisition of a numeric type and the mapping of text-type data are added up.
Be wherein the corresponding text-type of text-type as shown in Figure 2, this statistical method needs the data type judging newly-increased statistical indicator on backstage to be belong to text-type, judges that the association statistical indicator selected belongs to text-type.Wherein as shown in Figure 2, if a corresponding street, home address or a garden are, the situation having a corresponding street, multiple address occurs, this is identical street is then distinguished in the data acquisition on backstage different home addresses by comma.
Be wherein the corresponding Boolean type of numeric type as shown in Figure 2, this statistical method needs the data type judging newly-increased statistical indicator on backstage to be belong to numeric type, judges that the association statistical indicator selected belongs to Boolean type.Wherein add before formula during back-end data typing "! ", be used for adding up statistical indicator and whether belong to the data acquisition of a numeric type.
Be wherein the corresponding Boolean type of date type as shown in Figure 2, this statistical method needs the data type judging newly-increased statistical indicator on backstage to be belong to date type, judges that the association statistical indicator selected belongs to Boolean type.Wherein add before formula during back-end data typing "! ", be used for adding up statistical indicator and whether belong to the data acquisition of a date type.
The form sample of algorithm user in the present invention by interface or the prompting according to system just can complete the operation of whole Intelligent statistical.
Accompanying drawing explanation
Below in conjunction with drawings and Examples, the present invention is further described
Fig. 1 basic function formula
Fig. 2 complicated function formula.
Claims (6)
1. based on the statistical indicator intelligent computation method of complicated function formula, it is characterized in that: intelligent selection judges to meet the various complicated function formula of statistical indicator statistical demand.
2. the statistical indicator intelligent computation method based on complicated function formula according to claim 1, is characterized in that: according to the method can intelligence selection or change statistical indicator between incidence relation.
3. the statistical indicator intelligent computation method based on complicated function formula according to claim 1, it is characterized in that: the method dabbles that area is wide almost covers all function formulas, in addition the method especially providing of hommization independently fill in intelligent the carrying out of function formula and add up.
4. based on the statistical indicator intelligent computation method of complicated function formula, it is characterized in that: correct statistical method needs the corresponding correct result that could realize adding up of correct statistical indicator, and the method fills in especially for various complicated function formula the error having carried out the statistics that rigorous judgement is stopped except providing the statistics of Various Complex function formula.
5. based on the statistical indicator intelligent computation method of complicated function formula, it is characterized in that: in the method, not only contain the function formula between numerical value, further comprises the incidence relation of numerical value and date, text, Boolean type data corresponding statistics mutually.
6., based on the statistical indicator intelligent computation method based on complicated function formula according to claim 5, it is characterized in that: in the method, the condition of Intelligent statistical can unconfinedly independently be arranged.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410135874.8A CN104978305A (en) | 2014-04-08 | 2014-04-08 | Intelligent computation method of statistical index on the basis of complex function formula |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410135874.8A CN104978305A (en) | 2014-04-08 | 2014-04-08 | Intelligent computation method of statistical index on the basis of complex function formula |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104978305A true CN104978305A (en) | 2015-10-14 |
Family
ID=54274823
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410135874.8A Pending CN104978305A (en) | 2014-04-08 | 2014-04-08 | Intelligent computation method of statistical index on the basis of complex function formula |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104978305A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108228135A (en) * | 2016-12-15 | 2018-06-29 | 上海寒武纪信息科技有限公司 | A kind of a variety of devices surmounted function of operation |
| CN110069547A (en) * | 2019-03-19 | 2019-07-30 | 天津字节跳动科技有限公司 | Online database list data statistical method, device, medium and electronic equipment |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1997060A (en) * | 2006-11-24 | 2007-07-11 | 华为技术有限公司 | Method and system for index acquisition |
| CN102279848A (en) * | 2010-06-09 | 2011-12-14 | 中国电信股份有限公司 | Method and device for generating report template |
-
2014
- 2014-04-08 CN CN201410135874.8A patent/CN104978305A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1997060A (en) * | 2006-11-24 | 2007-07-11 | 华为技术有限公司 | Method and system for index acquisition |
| CN102279848A (en) * | 2010-06-09 | 2011-12-14 | 中国电信股份有限公司 | Method and device for generating report template |
Non-Patent Citations (1)
| Title |
|---|
| 苏翠英.: "应用excel函数实现中职学生成绩统计智能化", 《计算机应用教学研究》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108228135A (en) * | 2016-12-15 | 2018-06-29 | 上海寒武纪信息科技有限公司 | A kind of a variety of devices surmounted function of operation |
| CN108228135B (en) * | 2016-12-15 | 2021-09-07 | 上海寒武纪信息科技有限公司 | Device for operating multiple transcendental functions |
| CN110069547A (en) * | 2019-03-19 | 2019-07-30 | 天津字节跳动科技有限公司 | Online database list data statistical method, device, medium and electronic equipment |
| CN110069547B (en) * | 2019-03-19 | 2021-10-12 | 天津字节跳动科技有限公司 | Online database table data statistics method, device, medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105242239A (en) | Indoor subarea positioning method based on crowdsourcing fingerprint clustering and matching | |
| CN105184394B (en) | Optimal control method based on CPS online data mining of power distribution network | |
| CN111294819B (en) | Network optimization method and device | |
| CN107404740B (en) | Method for switching network, device and the terminal device of safety | |
| Chu et al. | Improving multi-objective reservoir operation optimization with sensitivity-informed dimension reduction | |
| CN113011753A (en) | Intelligent park management method based on artificial intelligence and big data and cloud platform system | |
| CN104574141A (en) | Service influence degree analysis method | |
| CN109039503A (en) | A kind of frequency spectrum sensing method, device, equipment and computer readable storage medium | |
| CN109241068A (en) | The method, apparatus and terminal device that foreground and background data compares | |
| CN108932217A (en) | The method and device of energy consumption statistic | |
| Candelieri et al. | Cost-effective sensors placement and leak localization–the Neptun pilot of the ICeWater project | |
| CN105447082A (en) | Distributed clustering method for mass load curves | |
| CN105243455A (en) | Grid distribution network planning evaluation method | |
| JP6481501B2 (en) | Communication terminal apparatus and method | |
| CN104978305A (en) | Intelligent computation method of statistical index on the basis of complex function formula | |
| CN109492031A (en) | Display methods, server and the computer storage medium of list data | |
| CN104850711B (en) | A kind of electromechanical product design standard system of selection | |
| CN109684367B (en) | Integrated processing method and device for dynamically adjusting multiple data source data | |
| CN115951123B (en) | Electric energy metering method and system based on wireless communication | |
| CN104820719A (en) | Web service creditworthiness measuring method based on context data of user | |
| CN106599130A (en) | Method and device for selectively interfering with multiple indexes of relational database management system | |
| CN109377391A (en) | A kind of tracking of information method, storage medium and server | |
| CN116560882A (en) | Fault root cause positioning method, device, equipment and computer storage medium | |
| CN110166272A (en) | The method, apparatus and system of terminal device index mediation service are provided | |
| CN114970928A (en) | Electric power data energy consumption analysis and prediction method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20151014 |
|
| WD01 | Invention patent application deemed withdrawn after publication |