How to Use Excel's STANDARDIZE Function

Save

Microsoft Excel is a widely used business and computational spreadsheet software package. One computational function contained within the software package is the standardize function. The standardize function uses a numerical value, mean and standard deviation to return a standardized z score.

  • Open the Microsoft Excel spreadsheet. Select the "Start" button from the main operating system menu. Next, choose "Programs" on the start menu. Then, click on "Microsoft Office" on the programs menu. Lastly, choose "Microsoft Excel" from the Microsoft Office menu to open Microsoft Excel.

  • Select the existing Excel file or open a new file in which to use the standardize function. To open an existing file, choose "Open" from the file menu of Microsoft Excel. To open a new file, select "New" from the file menu in Microsoft Excel.

  • Enter or identify the necessary input to use the standardize function. The inputs needed are a numerical value, mean and standard deviation for a set of values. If the input is already available on the spreadsheet, then locate the previously mentioned input necessary to execute the standardize function.

  • Choose the "Insert function" button located on the formula bar of Microsoft Excel. Locate the standardize function from the list of functions available. Double click on the listing or select and choose "OK". A dialogue box should appear after the user chooses the function.

  • Input the relevant data in the dialogue box or choose the necessary cells that contain the necessary information. To input the data simply type the numbers in the dialogue box. To choose a cell, click on the button to the right of the text box. The dialogue box will collapse so that the user can see the entire spreadsheet.

  • Click "OK" after the user enters the values for X, mean and the standard deviation. The result of the input will be the standardized function value.

Promoted By Zergnet

Comments

You May Also Like

  • How to Use Excel's STEYX Function

    Excel's STEYX function calculates the standard error for the predicted y value for all x values in the regression. Here, the standard...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!