Numerical data is the observed value measured in digital scale, and the results are specificnumerical value。Most of the data processed in reality are numerical data.[1]
For example, the income is 300 yuan, the age is 2 years old, the exam score is 100 points, and the weight is 3 kilograms. These values are numerical values.For numerical values, we can directly use arithmetic methods to summarize and analyze, while for other types of values, special methods are required.
Meaning in programming
Announce
edit
Numerical data represents quantity and can be used for numerical operationdata type。Numerical data consists of numbersdecimal point、SignIt is composed of the letter E representing the power, and the numerical precision is up to 16 bits.stayVFIn the systemValue rangeDifferent, numerical data can be divided into four different types.
(1) Numerical
Numerical（Numeric）Data is composed of numbers, decimal points, positive and negative signs and the letter E, which is represented by the letter N.The value range of numeric data is: -0.99999999999E+19+to 0.9999999999E+20, including sign, decimal point and letter E. The maximum length is 20 digits.Usually used to represent real numbers.
Floating point（FLOAT）Data is a kind of numerical data, which is represented by the letter F.It is completely equivalent to numerical data and is only used in storage formfloating-pointThe main purpose of the scheme is to obtain higher calculation accuracy.
(3) Double precision type
DOUBLE data is a data type data with higher precision, which is represented by the letter B.It is stored in fixed long charge floating point format, occupying 8 bytes
Integer data is numeric data that does not contain a decimal part, and is represented by the letter I.Integer dataIt is only used to represent an integerBinaryFormal storage, occupying 4 bytes.
Meaning of database
Announce
edit
Microsoft ExcelNumerical data in software often represents the quantity of some data types, such as date, timeArabic numerals, length, height, weight, etc.stayExcel2003Medium, numerical number is the largestPositive numberIt can reach the 307th power of 9.9 * 10, and the minimum negative number can reach the 307th power of - 9.9 * 10, but its accuracy can only be accurate to 15 digits.When Excel 2003CellWhen the number in exceeds 15 digits, the number after the 15th digit will be replaced by the number 0.This restriction even ifExcel2007China has not been broken through.Therefore, when the user needs to reserve more than 15 exact digits (for example, input 18 digitID card No.Or more than 15 digitsBank card number）, you need to set the cell data type to Text format.[2]
And inPlanning solutionIn the tool SOLVER, the final Answer Report is the calculation result report, and the type value means the cell value in the current row of the final solution (that is, theVariable value）, and the limit of the variable (upper or lower limit can be applicable).For example, if the value of the variable reaches the given limitMaximumperhapsminimum value, then the type value of this variable is 0. If the required variable is 1000 and the limit given by the condition is 2500, then the type value of this variable is 1500.
