|Assignment ID Number||AFFGEHU83939HD|
|Type of Document||Essay|
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 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.
This instructional video illustrates how to use Business Source Complete.
D&Bs Business Directory.
Using this site, you can search by industry, get a profile of the industry, and see top companies.
Fortune 500 Directory.
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?
Excel Essential Training – Using the Quick Access Formula Bar.
Excel Essential Training – Understanding Workbooks and Worksheets.
Excel Essential Training – Using Excel Help.
Excel Essential Training – Using Save or Save As.
Excel Essential Training – Using Simple Formulas.
Excel Essential Training – Exploring Font Styles and Effects.
Excel Essential Training – Applying Borders and Color Backgrounds.
Excel Quick Tips – Work with the New Stock and Geography Data Types.
0 – 1 Points
2 – 3 Point
4 – 5 Points
Unprofessional communication; many errors; no APA
Minor grammar, spelling, and APA errors
Postings are professional and in standard written English with APA
Complete addressing of assessment criteria
Criteria not fully addressed
Minimal response to criteria; minor aspects missing
All criteria are fully addressed
Evidence of critical thinking or extending information
Critical thinking or extending information not evident
Obvious responses to questions; little thought evident
Posts demonstrate critical thinking with evidence base from research or experience
No connections provided
Minimal connections provided to readings/activities
Clear connections to readings/activities
Submitted an overview / summary of the case selected for analysis. Also identified those procedural steps to be analyzed.
Did not provide an adequate overview or summary of the selected case or failed to identify those steps to be analyzed.
Provides an adequate overview or summary of the selected case and steps to be analyzed though may not be clear or complete.
Case overview is clearly presented including all appropriate investigative steps to be analyzed.
Tired of getting an average grade in all your school assignments, projects, essays, and homework? Try us today for all your academic schoolwork needs. We are among the most trusted and recognized professional writing services in the market.
We provide unique, original and plagiarism-free high quality academic, homework, assignments and essay submissions for all our clients. At our company, we capitalize on producing A+ Grades for all our clients and also ensure that you have smooth academic progress in all your school term and semesters.
High-quality academic submissions, A 100% plagiarism-free submission, Meet even the most urgent deadlines, Provide our services to you at the most competitive rates in the market, Give you free revisions until you meet your desired grades and Provide you with 24/7 customer support service via calls or live chats.