# Google Sheets PEARSON Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/pearson-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The PEARSON function calculates the Pearson correlation coefficient between two data sets, measuring their linear relationship strength. ``` PEARSON(data_y, data_x) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the PEARSON you need in plain EnglishGenerate Formula ## Parameters **`data_y`**:\ The range of cells that contains the dependent variable data points for which you want to calculate the Pearson correlation coefficient. **`data_x`**:\ The range of cells that contains the independent variable data points that you want to compare against the `data_y` values for correlation. ## What is a PEARSON? The *PEARSON* function in Google Sheets is a statistical tool used to calculate the Pearson correlation coefficient between two sets of data. This coefficient measures the strength and direction of the linear relationship between two variables, providing insights into how closely related they are. The value of the Pearson correlation coefficient ranges from -1 to 1, where -1 indicates a perfect negative correlation, 1 indicates a perfect positive correlation, and 0 indicates no correlation. In simpler terms, the PEARSON function helps you understand how two variables move in relation to each other. ## A Practical Example Imagine you are analyzing the relationship between the hours studied and exam scores for a group of students: ### Study Hours Table: | Student | Hours Studied | Exam Score | | - | - | - | | A | 2 | 75 | | B | 3 | 80 | | C | 5 | 90 | | D | 4 | 85 | | E | 1 | 70 | You want to determine if there is a correlation between the hours studied and the exam scores. ## PEARSON Formula To achieve this, you would use the PEARSON function as follows: ``` =PEARSON(B2:B6, C2:C6) ``` In this formula: - `B2:B6` is the range containing the Hours Studied. - `C2:C6` is the range containing the Exam Scores. ## Result of the Formula When you apply the PEARSON formula to the data, it will return a correlation coefficient value. For example, if the output is `0.9`, this indicates a strong positive correlation between hours studied and exam scores, suggesting that as students study more hours, their exam scores tend to increase. ## Why Use PEARSON? The PEARSON function is beneficial because it provides a quick and easy way to assess the relationship between two variables. Understanding correlations can help in making informed decisions, predicting outcomes, and identifying trends in data. Additionally, it is a straightforward function that can be used in various fields, including education, finance, and research. ## Key Takeaways: - **PEARSON**: A statistical function that calculates the Pearson correlation coefficient between two sets of data. - **Correlation Measurement**: Indicates the strength and direction of the linear relationship between two variables. - **Easy to Use**: Simple syntax allows for quick analysis of data relationships. - **Common Use Cases**: Useful in research, education, finance, and any scenario where understanding relationships between variables is necessary. The PEARSON function is an essential tool for anyone working with data analysis, providing valuable insights into the relationships between different variables. Happy analyzing! ## Example use case You have a table with sales data in Column A and customer satisfaction scores in Column B. Use the PEARSON formula to calculate the correlation between sales and satisfaction, helping to identify if higher sales are linked to better customer experiences. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Combine Two Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-combine-two-columns-in-google-sheets) - [How To Copy Formula In Google Sheets](https://betteranalyst.com/google-sheets/how-to-copy-formula-in-google-sheets) - [How To Count Unique Values In Google Sheets](https://betteranalyst.com/google-sheets/how-to-count-unique-values-in-google-sheets) - [How To Create A Pivot Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-create-a-pivot-table-in-google-sheets) - [How To Divide In Google Sheets](https://betteranalyst.com/google-sheets/how-to-divide-in-google-sheets) - [How To Enable Macros In Google Sheets](https://betteranalyst.com/google-sheets/how-to-enable-macros-in-google-sheets) - [How To Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.