Microsoft Excel and Google Sheets vastly simplify data analysis and statistical calculations by offering a comprehensive set of functions. In this article, we will discuss how to use the FISHERINV function, available in both Excel and Google Sheets, and explore its potential applications. This function is particularly useful for computing the inverse of the Fisher transformation.

Syntax and Example Usage of the Function

The primary purpose of the FISHERINV function is to calculate the original Pearson correlation coefficient from a value provided by the Fisher transformation. The general syntax of the function in Excel and Google Sheets is as follows:

 FISHERINV(y) 

• y: This is the value of the Fisher transformation from which the original Pearson correlation coefficient is calculated.

Below is a simple example of using this function:

 =FISHERINV(0.972955) 

In this example, the function calculates the corresponding Pearson correlation coefficient for the Fisher transformation value of 0.972955.

Practical Applications

The FISHERINV function is commonly used in statistical analyses and scientific research. Let”s examine two significant scenarios:

Correlation Analysis on Scientific Data

Consider a researcher analyzing the correlation between expression levels in different biological samples. Initially, the researcher calculates the Pearson correlation coefficient, then applies the Fisher transformation to stabilize it. At the end of the analysis, the Fisher transformation values can be converted back to the original correlation coefficients using the FISHERINV function.

 Example Calculation: 1. Pearson correlation coefficient = 0.8 2. Fisher transformation = FISHER(0.8) 3. Fisher transformation value = 1.098612 (example value) 4. Original correlation coefficient = FISHERINV(1.098612) 

Use in Psychological Research

Similarly, in a psychological study analyzing correlations between survey data, a researcher might apply the Fisher transformation for stabilization and use FISHERINV for back transformation. This method is particularly useful in studies with small sample sizes to make correlation estimates more normally distributed.

 Example Calculation: 1. Calculated Pearson correlation coefficient from survey results = 0.5 2. Applied Fisher transformation = FISHER(0.5) 3. Fisher transformation value = 0.549306 (example value) 4. Restored original coefficient = FISHERINV(0.549306) 

These examples illustrate how the FISHERINV function can be a valuable tool in scientific and psychological research, enhancing accuracy and stability in analyses and adaptable to different data sets.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/fisherters-işlevi-62504b39-415a-4284-a285-19c8e82f86bb