Order from us for quality, customized work in due time of your choice.
I also emailed the instructions because there are links that need to be used.
In
I also emailed the instructions because there are links that need to be used.
Instructions
In this exercise, you will demonstrate your ability to
find macroeconomic data from public sources and display it in an Excel
spreadsheet.
Start
by choosing one of these three macroeconomic variables: Real GDP, the
unemployment rate, or the inflation rate.
Follow
these instructions to find numbers for your macroeconomic variable for
three consecutive years:
Real GDPLinks to an external site.. Click on
“SECTION 1 – DOMESTIC PRODUCT AND INCOME.” Then click on “Table 1.1.6
Real Gross Domestic Product, Chained Dollars (A) (Q)” Next, click on the
curved arrow for “Modify.” Choose 2015 as the first year, select the
radio button for Series as “Annual” and then click on “Refresh Table.”
Line 1 for “Gross domestic product” has the data.
Labor
Force Statistics From the Current Population SurveyLinks to an external
site.. These unemployment numbers are monthly, not annual. Use the
January number for each year.
CPI for All Urban Consumers (CPI-U)Links to an external
site.. These inflation numbers are monthly, not annual. Use the
January number for each year.
Prepare
an Excel spreadsheet that has two columns and four rows. In cells A3, A4,
and A5 descending below this heading, type the three years that you have
chosen.
In
the heading for cell B2, type the name of the variable you chose (Real
GDP, Unemployment Rate, or Inflation Rate). In the cells below this
heading, type the values for each of the three years.
Underneath
your table, type “Source:” and then paste the URL of the source
where you found your data.
Resources
to Complete This Assignment
·
Week 7 Macroeconomic Case Study with Excel Example [DOCX] Download Week 7 Macroeconomic Case Study with Excel Example [DOCX].
·
Excel Essential Training – What Is
Excel Used For?Links to an external site.
·
Excel Essential Training – Using the
Quick Access Toolbar and Ribbon MenuLinks to an external site..
·
Excel Essential Training –
Understanding Workbooks and WorksheetsLinks to an external site..
·
Excel Essential Training – Using Excel
HelpLinks to an external site..
·
Excel Essential Training – Using Save
or Save AsLinks to an external site..
·
Excel Essential Training – Using
Simple FormulasLinks to an external site..
·
Excel Essential Training – Exploring
Font Styles and EffectsLinks to an external site..
·
Excel Essential Training – Applying
Borders and Color BackgroundsLinks to an external site..
·
Excel Quick Tips – Work with the New
Stock and Geography Data TypesLinks to an external site..
Order from us for quality, customized work in due time of your choice.