Distinguished - Correctly selects, calculates, and displays results for all three statistics, and uses displayed location or formulas for all values.

Proficient - Minor inaccuracies exist in the selection, calculation, and/or display of the results for the statistics.

Basic - Two of the variable statistical results are not accurate or correctly displayed.

Below Expectations - Attempts to select, calculate, and display results for all three statistics exist; however, three or more elements contain significant inaccuracies.

Non-Performance - There is either no response to Problem Two, or it does not provide correct statistical outcomes as asked for.

Distinguished - Value is correctly identified and the Excel function is used and shown.

Proficient - Value is correctly identified but the Excel function is not shown.

Basic - Shows the correct Excel function, but has selected the incorrect data and, as a result, has an incorrect value.

Below Expectations - Has an incorrect value and the Excel function used generate the answer is not shown.

Non-Performance - There is either no response to the problem, or it does not provide the value asked for.

Distinguished - Selects the correct data and performs and displays all Excel functions to correctly provide asked for values.

Proficient - Has an error in no more than one of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.

Basic - Has an error in no more than two of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.

Below Expectations - as an error in no more than three of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.

Non-Performance - There is either no response to the problem, or it does not provide probability values as asked for.

Distinguished - Selects the correct data and performs and displays all Excel functions to correctly provide asked for values.

Proficient - Has an error in no more than one of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.

Basic - Has an error in no more than two of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.

Below Expectations - Has an error in no more than three of the following elements: selects accurate data necessary for computations, displays the required Excel functions in the answer cells, and produces accurate results.

Non-Performance - There is either no response to the problem, or it does not provide probability values as asked for.

Distinguished - Provides thorough conclusions about the relationship between the data sets and the equal pay for work question, and identifies results that appear inconsistent and addresses why.

Proficient - Provides weak conclusions about one of the following issues: male and female inequality or consistency of the findings.

Basic - Provides weak conclusions about both of the following issues: male and female inequality and consistency of the findings.

Below Expectations - One of the following conclusions is not present: male and female inequality or consistency of the findings.

Non-Performance - There is either no response to Problem Five, or it does not address the issue of equal pay for equal work statistical results to date.