Grand Canyon University Micro Economics Case Study
ANSWER
The Excel spreadsheet can be made in the following ways:
Excel is now open.
Set up a fresh spreadsheet.
Type “Technology Hardware” in cell A1 with the wording bolded.
In cell A2, enter “Year.”
Type the 2020, 2021, and 2022 in cells A3, A4, and A5.
In cell B2, enter “Revenue.”
Enter the revenue information for the corresponding years in cells B3, B4, and B5. Let us take the revenue figures of $10 billion for 2020, $12 billion for 2021, and $15 billion for 2022 as an illustration. In order to input these numbers, you would do so in cells B3, B4, and B5.
Type “Source:” below the table, then paste the URL of the place where you got the information because I cannot visit external websites.
QUESTION
Description
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, real estate, food or paper sales data for 2019, 2020, and 2021.
- 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
ECO100 Week 3 Assignment Excel Example [DOCX].
- Excel Essential Training – What Is Excel Used For?
- Excel Essential Training – Using the Quick Access Toolbar and Ribbon Menu.
Excel Essential Training – Understanding Workbooks and Worksheets.
- 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.