Category: E-learning Step by Step
Video – Case #5 – Calculating a 12-month rolling sum
Video – Case #3 – Calculating and presenting year-on-year % change
Worksheet – Case 6 – Create a category chart using Scalar
Finding Data To find sectoral returns of the S&P 500, you can use the Country & Region database. Navigate to Country & Region > United States > Equity Market > Equity Indices > S&P > 500 > Industry Classification category. Adjust the slider to show only level 1 of, that way you only have to … Continue reading “Worksheet – Case 6 – Create a category chart using Scalar”
Case #6
Create a category chart using Scalar Objectives Using the Scalar analysis to create a category series Creating a category chart, and sorting the results Making visual adjustments to a category chart Solution If you get stuck trying to replicate the example, use the video or worksheet to see what to do next. Video (Note that … Continue reading “Case #6”
Case #5
Calculating a 12-month rolling sum Objectives Calculating a rolling sum using the Aggregate analysis Editing the chart title & removing the legend Saving the document and creating folders Setting the chart dimensions & exporting to PowerPoint Solution If you get stuck trying to replicate the example, use the video or worksheet to see what to … Continue reading “Case #5”
Worksheet – Case 5 – Calculating a 12-month rolling sum
Finding Data To find the German Current Account Balance, you can use the Country & Region database. Navigate to Country & Region > Germany > Balance of Payments > Current Account > Total Add the headline series for Balance – marked with an exclamation mark – to the document. Analysis Aggregate To calculate a rolling sum, … Continue reading “Worksheet – Case 5 – Calculating a 12-month rolling sum”
Worksheet – Case 3 – Calculating and presenting year-on-year % change
Finding Data US Industrial Production To find US Industrial Production, the best approach is to start looking in Country & Region. Navigate to: Country & Region > Production > Industrial Summary > Output > Market Groups Click on Total Industrial Production Index – this is the headline series, indicated by the red exclamation mark. US … Continue reading “Worksheet – Case 3 – Calculating and presenting year-on-year % change”
Case #3
Calculating and presenting year-on-year % change Objectives Apply a Rate of Change analysis Display one series on an alternate axis Combine line and area graphs in one chart Synchronize the scale of the vertical axes Solution If you need more detailed help, have a look at the learning resources below, and download the Macrobond document … Continue reading “Case #3”
Worksheet – Case 1 – Comparing GDP across countries using Rebase
Finding Data Since we’re looking at comparing an indicator across countries, we should start by exploring the Concept & Category database. For this exercise, we’ll use GDP from National Sources. GDP series can be found under National Accounts. We will use constant prices. Now we just need to select the countries we are interested in: … Continue reading “Worksheet – Case 1 – Comparing GDP across countries using Rebase”