How Do I Use the Frequency Function?

Start the excel program with the frequency function, click "File" - "Open", click "Formula" - "Other Functions" - "Statistics" - "Frequency" to set the function. Here's how:

1. Click "Start" - "Microsoft Office" - "Microsoft Excel 2010" to start the Excel program.

2. Click File - Open.

3. Select an excel file from your computer and click "Open" to open the excel file.

4. In this work, it is necessary to count the number of employees whose wages are in the 7 intervals of 0-20002000-25002500-30003000-35003500-40004000-45004500-5000. Select the H3-H9 unit, click [Formula] [Other Functions] [Statistics] [Frequency], and the frequency function parameter setting interface will pop up.

5. The frequency function has data array and bins array parameters. The Data Array parameter indicates an array or a reference to a set of values to participate in the calculation. In this operation, select f2:f20 cell as the data array parameter.

6. The bins array parameter represents the interval value, which can be a specific value or an array. In this operation, select g3:g9 as the value of the bins array parameter.

7. After the frequency function parameters are set, click the "OK" button to calculate the number of people in each salary range.

Notes:

Most of the function outputs a press return, and this function returns a result by clicking Ctrl+Shift+Enter.

Use the frequency function to start the excel program, click "File" - "Open", click "Formula" - "Other Functions" - "Statistics" - "Frequency" to set the function, the specific method is as follows:

1. Click "Start" - "Microsoft Office" - "Microsoft Excel2010" to start the Excel program.

2. Click "File" - "Open".

3. Select an excel file from your computer and click "Open" to open the excel** file.

4. In this operation, it is necessary to count the number of employees in 7 intervals of 0-2000, 2000-2500, 2500-3000, 3000-3500, 3500-4000, 4000-4500, 4500-5000. Select cells H3-H9 and click "Formulas"-"Other Functions"-"Statistics"-"Frequency" to open the frequency function parameter setting interface.

5. The frequency function has data array and bins array parameters. The data array parameter represents an array or a reference to a set of values to participate in the calculation, in this operation, select the f2:f20 cell as the data array parameter.

6. The bins array parameter represents the interval value, which can be a specific value or an array, in this operation, select g3:g9 as the value of the bins array parameter.

6. After setting the parameters of the frequency function, click "OK" to calculate the number of people in each salary range.

Notes:

Most of the function outputs a press return, and this function returns a result by clicking Ctrl+Shift+Enter.

The differences between frequency and frequence are as follows:

1、frequency

English [ fri kw nsi] American [ fri kw nsi]n(Sound waves do pre-or electromagnetic waves.)

vibrating frequency; Frequent; incidence; occurrence rate; Repetition rate.

2、frequence

n.Frequency pure imitation clear number, frequent.

Example sentence: The dds technology was widely used in frequence synthesis field

DDS has been widely used in the field of frequency synthesis.

There is no difference between frequence and frequency.

frequence=frequency, the difference is between American and British English.

frequence ['fri:kwəns]n.frequency, frequency; Frequency.

frequence ['fri:kwəns]n.frequency, frequent troubles; Frequency.

The frequency function can be used by data type, variable assignment, laughing code control flow, function definition, and module import.

1. Data types: Python supports a variety of data types, including numbers, strings, lists, tuples, sets, and dictionaries. Touch.

2. Variable assignment: Variables in Python can be directly assigned, and there is no need to declare the variable type in advance.

3. Control flow: Commonly used control flow structures include if statements, for loops, and while loops. Blocks can be represented using indentation.

4. Function definition: You can use the def keyword to define the function. A function can take a parameter and return a value.

5. Module import: You can use the import statement to import the module in ython, so as to use the functions and variables in the module.