Reading the Kentucky Household Income Dataset

In Income_Data_Worksheet (1), the worksheet is organized as a simple two-column table about household income in Kentucky.

Worksheet structure

The worksheet is named Sheet1. At the top, cell A1 contains the title “Household Income for Kentucky.” Row 2 gives the column headings:

• Column A: Year
• Column B: Median income

This means each row below the headings records one year and the corresponding median household income for Kentucky.

Variables recorded

According to Income_Data_Worksheet (1), the dataset records two variables:

• Year — the calendar year for the observation
• Median income — the median household income in Kentucky for that year

For example, the table shows entries such as 1977 with $40,108, 1990 with $43,892, 2008 with $51,100, and 2019 with $49,777.

Time span covered

The data in Income_Data_Worksheet (1) begins with 1977 and ends with 2019. So, the worksheet covers Kentucky household income over the period 1977–2019.

How to read a row

Each row after the headings pairs a year in Column A with a median income value in Column B. For example:

• 1977 — $40,108
• 1995 — $44,898
• 2010 — $52,301
• 2019 — $49,777

Summary

To read this dataset, look at the year in Column A and then match it with the median income in Column B. In Income_Data_Worksheet (1), the worksheet has a title row, a header row, two variables, and data covering Kentucky from 1977 through 2019.