skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

Microeconomics Case Study
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.
Remember that an industry is a group of companies that do the same thing. For example, Ford is a company; automobile manufacturing is an industry.
Choose a microeconomic variable for your industry.
It could be prices, sales, production, advertising, or investment.
Do some research and find three years of this microeconomic variable for your industry.
For example, you might find automobile sales data for 2017, 2018, and 2019.
Go to the Census Bureau (NAICS) website, https://www.census.gov/cgi-bin/sssd/naics/naicsrch?chart=2017  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.
Resources to Complete the Assignment
Business Source Complete
This database has an option to search the Publication Type of “Industry Profile.”
How to Use Business Source Complete.
http://cdnapisec.kaltura.com/index.php/extwidget/preview/partner_id/956951/uiconf_id/43830551/entry_id/1_xk4hs8tj/embed/dynamic
This instructional video illustrates how to use Business Source Complete.
D&B’s Business Directory
https://www.dnb.com/business-directory.html.
Using this site, you can search by industry, get a profile of the industry, and see top companies.
Fortune 500 Directory.
https://fortune.com/fortune500/2020/search/
You can find information on the top companies in most categories.
Microeconomic Case Study Instructions with Excel Example [DOCX].
Excel Essential Training – What is Excel Used For?
https://www.linkedin.com/learning/excel-essential-training-office-365/what-is-excel-used-for?u=57878161
Excel Essential Training – Using the Quick Access Formula Bar.
https://www.linkedin.com/learning/excel-essential-training-office-365/using-the-quick-access-toolbar-and-ribbon-menu?u=57878161
Excel Essential Training – Understanding Workbooks and Worksheets.
https://www.linkedin.com/learning/excel-essential-training-office-365/understanding-workbooks-and-worksheets?u=57878161
Excel Essential Training – Using Excel Help
Excel Essential Training – Using Save or Save As
https://www.linkedin.com/learning/excel-essential-training-office-365/using-save-or-save-as?u=57878161.
Excel Essential Training – Using Simple Formulas.
https://www.linkedin.com/learning/excel-essential-training-office-365/exploring-font-styles-and-effects?u=57878161
Excel Essential Training – Exploring Font Styles and Effects.
https://www.linkedin.com/learning/excel-ehttps://www.linkedin.com/learning/excel-essential-training-office-365/applying-borders-and-color-backgrounds?u=57878161
Excel Essential Training – Applying Borders and Color Backgrounds.
https://www.linkedin.com/learning/excel-essential-training-office-365/applying-borders-and-color-backgrounds?u=57878161
Excel Quick Tips – Work with the New Stock and Geography Data Types.

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don’t hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®