state-education.csv

This data, stored in state-education.csv includes state-level aggregate data on six attributes. The attributes, collected for all 50 states and the District of Columbia, are:

• state: State name
• postal: State postal code
• region: Region of the country identified by the National Education Association (Far West, Great Lakes, Mid East, New England, Plains, Rocky Mountains, Southeast, Southwest)
• sat_participate: Percentage of students in the state who took the SAT.
• sat_ebrw: Average score on the Evidence-Based Reading and Writing (EBRW) scale in the state.
• sat_math: Average score on the math scale in the state.
• sat_total: Average total SAT score in the state.
• salary_2020_21: Average 2020–2021 public teacher salary in the state.

Note: All of the SAT data is based on students in the class of 2020 who took the current SAT during high school. The SAT is made up of three sections: (1) Reading, (2) Writing and Language (also just called Writing), and (3) Math. The Math section is scored on a scale of 200–800. The Reading and Writing sections are combined to give an Evidence-Based Reading and Writing (EBRW) score, also ranging from 200–800. By combining the Math and EBRW scores, we get a total SAT score ranging from 400–1600.

Preview

# Import Data
state_educ = readr::read_csv(file = "https://raw.githubusercontent.com/zief0002/rustic-penguin/main/data/state-education.csv")

# View data
state_educ

# A tibble: 51 × 8
   state               postal region sat_participate sat_ebrw sat_math sat_total
   <chr>               <chr>  <chr>            <dbl>    <dbl>    <dbl>     <dbl>
 1 Alabama             AL     South…               7      576      551      1127
 2 Alaska              AK     Far W…              37      555      543      1098
 3 Arizona             AZ     South…              29      571      568      1139
 4 Arkansas            AR     South…               4      590      567      1157
 5 California          CA     Far W…              67      527      522      1049
 6 Colorado            CO     Rocky…             100      511      501      1012
 7 Connecticut         CT     New E…             100      527      512      1039
 8 Delaware            DE     Mid E…             100      497      481       978
 9 District of Columb… DC     Mid E…             100      498      482       979
10 Florida             FL     South…             100      512      479       992
# ℹ 41 more rows
# ℹ 1 more variable: salary_2020_21 <dbl>

References

College Board. (2020). SAT suite of assessments annual report. Author.

NEA Research. (2021). Rankings of the states 2020 and estimates of school statistics 2021. National Education Association.