Method for performing frequency analysis and synchronously drawing frequency curve in Excel

A frequency curve and frequency analysis technology, applied in the field of mathematics and engineering design, can solve the problem of time-consuming, uneditable frequency curve graph, etc., to achieve the effect of shortening the working time
CN108446263AInactive Publication Date: 2018-08-24蒋沛漪
2 Cites 1 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
蒋沛漪
Publication Date
2018-08-24
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention discloses a method for performing frequency analysis and synchronously drawing a frequency curve in Excel and is applicable to the technical fields of mathematics and engineering design.The method comprises the specific steps that first, a formula is derived; second, a normal probability paper coordinate system is drawn in Excel; and third, a P-III frequency curve is drawn. Throughthe method for performing frequency analysis and synchronously drawing the frequency curve in Excel, working time is greatly shortened, a program directly runs in a series of files to be subjected tofrequency analysis, and it is not needed to copy the series into text files and then open the files one by one; and after a macro command is run, any series contained in a result graph can be displayed in the graph without the need for adding the series one by one, drawing of the P-III frequency curve is realized, and a generated frequency curve graph meets the requirement of a formal publicationformat.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the technical field of mathematics and engineering design, in particular to a method for performing frequency analysis and synchronously drawing frequency curves in Excel. Background technique

[0002] The P-III curve was proposed by the British biologist Pearson. It is an asymmetric unimodal and positively skewed curve with a finite end and an infinite end. It is called the Gamma distribution in mathematics. The purpose of the frequency calculation is to determine the design value xp corresponding to a given design frequency p.

[0003] The reciprocal of the design frequency is called the return period. The return period is a design standard widely used in the planning, design, operation and management of water conservancy and hydropower projects, civil engineering, etc. It is mainly determined according to the importance of the project and the damage results of hydrological events to the project.

[0004] The shortcoming of...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More