# Google Sheets STANDARDIZE Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/standardize-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 STANDARDIZE function calculates a normalized value from a dataset, using the mean and standard deviation to adjust for scale. ``` STANDARDIZE(value, mean, standard_deviation) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the STANDARDIZE you need in plain EnglishGenerate Formula ## Parameters **`value`**:\ The numeric value that you want to standardize. **`mean`**:\ The arithmetic mean (average) of the dataset from which the `value` is drawn. **`standard_deviation`**:\ The standard deviation of the dataset from which the `value` is drawn. ## What is STANDARDIZE? The *STANDARDIZE* function in Google Sheets is a statistical tool used to normalize a set of values by converting them into a standard score (z-score). This function is particularly useful in data analysis when you want to compare scores from different distributions or datasets. By standardizing your data, you can easily interpret how far a particular value is from the mean in terms of standard deviations. In simpler terms, STANDARDIZE allows you to transform your data into a common scale, making it easier to analyze and compare. ## A Practical Example Imagine you are analyzing test scores from two different classes: ### Class A Scores: | StudentID | Score | | - | - | | 1 | 85 | | 2 | 90 | | 3 | 78 | ### Class B Scores: | StudentID | Score | | - | - | | 1 | 70 | | 2 | 88 | | 3 | 95 | You want to standardize the scores from both classes to see how each student performed relative to their class. ## STANDARDIZE Formula To achieve this, you would use the STANDARDIZE function as follows: ``` =STANDARDIZE(A2, AVERAGE(ClassA!B:B), STDEV(ClassA!B:B)) ``` In this formula: - `A2` is the cell containing the Score you want to standardize. - `AVERAGE(ClassA!B:B)` calculates the mean of the scores in Class A. - `STDEV(ClassA!B:B)` calculates the standard deviation of the scores in Class A. ## Result of the Formula When you apply the STANDARDIZE formula to the Class A scores, the output would look like this: | StudentID | Score | Standardized Score | | - | - | - | | 1 | 85 | 0.58 | | 2 | 90 | 1.16 | | 3 | 78 | -0.58 | If you were to standardize the scores from Class B using a similar formula, the result would be: | StudentID | Score | Standardized Score | | - | - | - | | 1 | 70 | -1.16 | | 2 | 88 | 0.58 | | 3 | 95 | 1.16 | ## Why Use STANDARDIZE? STANDARDIZE is beneficial because it allows for a clear comparison of scores from different distributions. By converting raw scores into z-scores, you can easily identify how well a student performed relative to their peers. This is particularly useful in educational assessments, performance evaluations, and any scenario where comparing different datasets is necessary. ## Key Takeaways: - **STANDARDIZE**: A function that converts raw scores into standard scores (z-scores). - **Comparison**: Enables comparison of scores from different distributions on a common scale. - **Statistical Insight**: Provides insight into how far a score is from the mean in terms of standard deviations. - **Common Use Cases**: Ideal for educational assessments, performance evaluations, and statistical analysis. STANDARDIZE is an essential function for anyone working with data analysis, providing a powerful way to enhance the interpretation of scores and performance metrics. Happy analyzing! ## Example use case You have a dataset of test scores in Column A and their corresponding mean and standard deviation in Columns B and C. Use the STANDARDIZE formula to calculate the z-scores for each test score, allowing for easy comparison of performance across different tests. ## 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 Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-in-google-sheets) - [How To Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-in-google-sheets) - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) - [How To Make A Copy Of An Google Sheets Sheet](https://betteranalyst.com/google-sheets/how-to-make-a-copy-of-an-google-sheets-sheet) - [How To Make A Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-graph-in-google-sheets) - [How To Make A Histogram In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-histogram-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.