Excel uses the Correl function to return the correlation coefficient to determine the attribute relation

① start the Excel2013, open the table, and enter the formula in the cell following the correlation coefficient: =correl ($B $: $B $13,c2:c13)

② carriage return, get results 0.75114738. The significance of the result I'll explain it to you later.

③ fills the cell to the right and completes the data calculation.

Formula description

Correl (array 1, array 2): Returns the correlation coefficient between two sets of arrays, using the correlation coefficient to determine the relationship between the two attributes.

The correlation coefficient between the average temperature and the air conditioner is returned, and the relationship between the temperature and the air conditioner is analyzed by this correlation coefficient.

Description

The closer the correlation coefficient to 0, the more irrelevant the two. For example, the correlation coefficient of television and temperature is the closest to 0, which shows that the television is generally unaffected by temperature. The result of the air conditioner is closer to 1, indicating the positive correlation between air conditioner and temperature, the higher the temperature, the more the air-conditioner will be sold and vice versa. And the electric blanket, is the inverse correlation, the higher the temperature, the less sales, the lower the temperature, the more sales.

Classification:

• Excel Tutorials