What Happens to the Standard Deviation When a Constant Is

question 42

Essay

What happens to the standard deviation when a constant is added to each score? Use the following set of data, and a constant of 2 to illustrate your answer.
1               2               3               4

---

Definitions:

Objective Cell

In optimization and spreadsheet software, the cell that contains the formula that is to be maximized or minimized.

Goal Seek

A function in spreadsheet software that finds the input value needed to achieve a specific goal or result in a formula.

What-If Analysis

A process or feature in spreadsheet and analytical software that allows users to predict the outcome of a particular action or scenario by changing variables.

Data Tab

In software, it is typically a section within a user interface that provides access to a collection of data or database management features.