Unweighted Average

From CSUMB Data Glossary
Jump to navigation Jump to search

An Unweighted Average is a an average calculated without multiplying each component by a factor or "weight" reflecting the size of each component.

Total and subtotals for Unweighted Averages are calculated based upon cell values displayed rather than the underlying data and may misrepresent the data.

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:
Data Custodian
Institutional Assessment and Research
Data Source
Source System:N/A
Source Table Name:N/A
Source Field Name:N/A
Census Process:N/A
Logical Transformation / Calculation
N/A
OBIEE Folder and Column
Folder Heading:N/A
Column Heading:N/A


Examples

If you were looking at unweighted averages of SAT scores for a particular college (all numbers in the scenario below are made up for illustrative purposes):

College of Education has an average SAT score of 520. You drill into this college to see the scores for majors, and find that Liberal Studies has an average SAT score of 525 and Human Development and Family Studies has an average SAT score of 475. The unweighted average displayed as a subtotal/total in this case would be 500 (525 + 475 / 2).

The weighted average is higher than the unweighted average because there are more students in Liberal Studies than Human Development and Family Studies, and the weighted average calculation takes this into account.

See Also