Case #5

Calculating the standard deviation interval around a mean Objective Calculating the mean of a series and standard deviation bands Adding recession bands Adding the last value of a series on the Y-axis Solution If you get stuck, use the worksheet to see what to do next. If you need more detailed help, have a look … Continue reading “Case #5”

Case #4

Calculating the mean of a series for several time periods Objectives Changing the frequency of the document Using Statistics to calculate the mean of the series for several time periods. Creating several observation labels displaying the same information Solution If you get stuck, use the worksheet to see what to do next. If you need … Continue reading “Case #4”

Case #3

Building a simple regression model Objective Performing a simple regression analysis Adding a pane to the chart Using dynamic properties to adjust an observation label Solution If you get stuck, use the worksheet to see what to do next. If you need more detailed help, have a look at the learning resources below. The Macrobond … Continue reading “Case #3”

Case #2

Using Slice to look at the seasonal pattern of a series & using Change Region to replicate a file for another country. Objectives Calculating the monthly performance of a series over time  Using Slice to create one series per year  Using Cross Section to calculate the average of the sliced series  Using Change Region to … Continue reading “Case #2”

Worksheet – Case #2 – Using Slice to look at the seasonal pattern of a series & using Change Region to replicate a file for another country.

Finding Data In this case, you will have to use the S&P 500 index.  Using the data tree, you can locate the data here:  Country & Region > United States > Equity Market > Equity Indices > S&P > 500 > Composite > Price return  Add:  Index (highlighted with an exclamation mark)  You can also … Continue reading “Worksheet – Case #2 – Using Slice to look at the seasonal pattern of a series & using Change Region to replicate a file for another country.”

Case #1

Using Slice to compare one series at different periods in time Objectives Using Slice to compare one series across different time periods Exporting the underlying data into Excel Solution If you get stuck, use the worksheet to see what to do next. If you need more detailed help, have a look at the learning resources … Continue reading “Case #1”

Level 2

Case #1 – Using Slice to compare one series at different periods in time Case # 2 – Using Slice to look at the seasonal pattern of a series & using Change Region to replicate a file for another country. Case #3 – Building  a simple regression model Case #4 – Calculating the mean of a series for … Continue reading “Level 2”