Page 127 - Excle-En-V3

Formula Auditing Commands:

• Trace Precedents: Clicking the Trace Precedents command for cell I6 displays an
arrow that highlights the cells affected by this formula, namely C6, D6, E6, F6, G6,
and H6.

• Trace Dependents: Clicking the Trace Dependents command for cell D9 displays
arrows indicating the formulas that depend on this cell, namely I9, D16, and D17.

• Correlation coefficient & Data Analysis (TO VIEW ONLY)
• Correlation coefficient (TO VIEW ONLY)

Pearson correlation coefficient (r) is the most common way of measuring a linear
correlation between variables. It is a number between –1 and 1 that measures the
strength and direction of the relationship between two variables. (+1) indicates a
strong positive correlation whereas (-1) indicates a strong negative correlation. For
example, to know the relationship between the population number and meat
consumption and as shown in the following table:

Meat consumption (ton) Population number

300 10000000

250 2500000

290 3000000

Note: the numbers are not real

To calculate the Pearson correlation coefficient, the following steps are followed:

Select an empty cell, click the (insert functions) FX button on the ribbon, and
type “correlation” into the ‘Search for a function’ box as shown in the following
figure. Click “Go.” CORREL will be highlighted

119 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024