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”
Finding Data To find the time series used in this example we will access the tree by Country & Region as most global commodity spot prices can be found under the region World. Go to: Country & Region > World > Commodities & Energy > Spot Prices > Energy > Crude Oil. Locate and add: … Continue reading “Worksheet – Case #4 – Calculating the mean of a series for several time periods”
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”
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”
Finding Data In this case, we will reuse the document from Step 1 Case #9 which can be downloaded here. As such, all data needed for the exercise will already be in the document. Analysis Regression In the case #10 from Level 1, we established that the ISM PMI is a leading indicator of the Industrial Production in the … Continue reading “Worksheet – Case #3 – Building a simple regression model”
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”
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.”
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”
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 #1 – Using Slice to compare one series at different periods in time”
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”