User guide

© GeoWise Ltd. 2011
Page 161
visualise | communicate | ENGAGE The InstantAtlas Bubble Plot Template
g the InstantAtlas Area Profile Template User Guide
© GeoWise Ltd. 2013
For every indicator, you must also supply values for six properties in the
XML data file(s) for your report. In your Excel workbook, you add these
into the Metadata worksheet.
The first property defines the average for the region or nation:
NATIONALAVERAGE – the regional/national average
The remaining five properties are used to plot the confidence limits:
LIMITEXPECTED – an array of the X axis values used to plot the
confidence limits. These should be the sample/population size the
confidence limits have been calculated for.
LIMITLOWER95 – an array of the 95% lower confidence limits calculated
for the regional/national average based on the sample/population sizes in
the LIMITEXPECTED array.
LIMITUPPER95 – an array of the 95% upper confidence limits calculated
for the regional/national average based on the sample/population sizes in
the LIMITEXPECTED array.
LIMITLOWER99 – an array of the 99% lower confidence limits calculated
for the regional/national average based on the sample/population sizes in
the LIMITEXPECTED array.
LIMITUPPER99 – an array of the 99% upper confidence limits calculated
for the regional/national average based on the sample/population sizes in
the LIMITEXPECTED array.
The delimiter in the arrays depends whether Excel is using points or
commas as decimal separators. If the decimal separator is a point, the
delimiter in the arrays must be a comma. If the decimal separator is a
comma (e.g. if the regional setting of your operating system is French,
Spanish or German) the delimiter in the arrays must be a semi-colon.
Refer to the ‘Metadata’ worksheet in the Excel workbook called
IAworkbookBubblePlot_FunnelPlot_Flash.xls.
Figure 189
An easy way of creating and entering an array is described below. In this
example commas are used as delimiters.
Start with a column in a new Excel workbook that contains the numbers for
the array. The values 1, 2, 3… displayed in the screenshot below are
example values only. In reality, these will be the actual values that you
wish to use to plot the confidence limits.