Prepare an Excel spreadsheet that has two columns and four rows. In cell A1, type in the industry you selected and bold the text. In the heading for cell A2, type “Year.” In cells A3, A4, and A5 descending below this heading, type the years for your data. In the automobile example, this would be 2017, 2018, and 2019.

Description

Instructions

In this exercise, you will demonstrate your ability to find microeconomic data from public sources and to make a simple spreadsheet in Excel.

Start by choosing an industry that interests you. Supplements (RED-CON ONE).

Choose a microeconomic variable for your industry.(sales)

Do some research and find three years of this microeconomic variable for your industry.2020, 2019, 2018.

Go to the Census Bureau (NAICS) website and select an industry that has a description. Some of the smaller industries are named, but not described.

The industry could be broad, such as industry 11 Agriculture, Forestry, Fishing, and Hunting, or it could be narrow, such as industry 112112 Cattle Feedlots. The more digits in the industry label, the narrower the industry

Prepare an Excel spreadsheet that has two columns and four rows. In cell A1, type in the industry you selected and bold the text. In the heading for cell A2, type “Year.” In cells A3, A4, and A5 descending below this heading, type the years for your data. In the automobile example, this would be 2017, 2018, and 2019.

In the heading for column two, cell B2, type the name of the variable you chose. For example, it could be “Sales.” In the cells below this heading, type the sales data for each of the three years.

Underneath your table, type “Source:” Then paste the URL of the source where you found your data.