this exercise, you will demonstrate your ability to find microeconomic data from public sources and to make a spreadsheet in Excel.
Microeconomic data are numbers about a single industry. Automobile sales numbers are microeconomic data. Unemployment numbers for the entire
country are not microeconomic data.
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.
Using the library’s Statista resource, 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 Statista.
Log in using your Strayer credentials.
Type your industry name in the “Statista Search” space and click Statista Search.
Choose one of the options that has three years of annual data.
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:” and then paste the URL of the source where you found your data.
See the Excel example below.
Resources to Complete the Assignment This is an example; ECO100 Week 3 Assignment Excel Example
Header row: Furniture.
Column titles: Year and Sales.
Row 3: 2017, $59.6 billion.
Row 4: 2018, $63.7 billion.
Row 5: 2019, $63.6 billion
Source: https://www-statista-com.libdatab.strayer.edu/statistics/197584/annual-furniture-store-sales-in-the-us-since-1992/

Essay Mill

Share
Published by
Essay Mill

Recent Posts

Childbirth

For this short paper activity, you will learn about the three delays model, which explains…

4 weeks ago

Literature

 This is a short essay that compares a common theme or motif in two works…

4 weeks ago

Hospital Adult Medical Surgical Collaboration Area

Topic : Hospital adult medical surgical collaboration area a. Current Menu Analysis (5 points/5%) Analyze…

4 weeks ago

Predictive and Qualitative Analysis Report

As a sales manager, you will use statistical methods to support actionable business decisions for Pastas R Us,…

4 weeks ago

Business Intelligence

Read the business intelligence articles: Getting to Know the World of Business Intelligence Business intelligence…

4 weeks ago

Alcohol Abuse

The behaviors of a population can put it at risk for specific health conditions. Studies…

4 weeks ago