{"id":5551,"date":"2015-08-28T11:59:32","date_gmt":"2015-08-28T10:59:32","guid":{"rendered":"https:\/\/help.instantatlas.com\/dashboard-builder-desktop\/desktop-user-guide\/the-instantatlas-bubble-plot-template\/funnel-plot\/"},"modified":"2019-09-19T12:08:07","modified_gmt":"2019-09-19T11:08:07","slug":"funnel-plot","status":"publish","type":"page","link":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/en\/welcome\/desktop-user-guide\/the-instantatlas-scatter-plot-template\/funnel-plot\/","title":{"rendered":"Funnel Plot"},"content":{"rendered":"

Funnel plots are scatter plots upon which confidence limits have been superimposed. These confidence limits are plotted for a regional or national average. The limits enable you to see which observations are significantly different from the regional\/national average. The confidence limits form a funnel shape because these decrease as sample\/population sizes shown on the X axis increase.<\/p>\n

If you publish the Funnel Plot configuration with a demonstration data file the report will look like that in the image\u00a0below.<\/p>\n

\"figure188\"<\/a><\/p>\n

The regional\/national average is shown as a horizontal green line across the chart. The yellow and red curves are the upper and lower 95% and 99% confidence limits plotted for the regional\/national average. Points that lie above\/below the upper\/lower curves are significantly different from the regional\/national average. Points that lie within the funnel are not significantly different from the regional\/national average.<\/p>\n

There is only one \u2018Data\u2019 button and this is used by the end-user to change the indicator values in the map.<\/p>\n

The Funnel Plot configuration of the HTML Scatter Plot template uses associates called \u2018xValue\u2019 and \u2018yValue\u2019 as data sources for the funnel plot axis.<\/p>\n

xValue<\/strong>\u00a0\u2013 the X axis values for the chart. Typically, these are sample\/population sizes. In public health for example, it is common to show Standardised Mortality Ratios (SMRs) on the Y axis and the expected number of deaths on the X axis.<\/p>\n

yValue<\/strong>\u00a0\u2013 the Y axis values for the chart.<\/p>\n

The required data structure is shown in the \u2018iadatasheet\u2019 worksheet of the workbook called IAworkbookBubblePlot_FunnelPlot_HTML.xls. This workbook can be found in the \u2018workbooks\u2019 folder of your InstantAtlas installation.<\/p>\n

\"FunnelHTML\"<\/a><\/p>\n

If your indicator values shown in the map are numeric and you wish to use them for the Y axis as well you need to enter ‘value’ into the\u00a0 ‘X-Axis Data’ property of the Bubble Plot component in the Designer.<\/p>\n

For every indicator, you must also supply values for six properties (below) in the data file(s) for your report. In your Excel workbook, you add these into the Metadata worksheet.<\/p>\n

The first property defines the average for the region or nation:<\/p>\n

NATIONALAVERAGE<\/strong> \u2013 the regional\/national average
\nThe remaining five properties are used to plot the confidence limits:<\/p>\n

LIMITEXPECTED<\/strong> \u2013 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.<\/p>\n

LIMITLOWER95<\/strong> \u2013 an array of the 95% lower confidence limits calculated for the regional\/national average based on the sample\/population sizes in the LIMITEXPECTED array.<\/p>\n

LIMITUPPER95<\/strong> \u2013 an array of the 95% upper confidence limits calculated for the regional\/national average based on the sample\/population sizes in the LIMITEXPECTED array.<\/p>\n

LIMITLOWER99<\/strong> \u2013 an array of the 99% lower confidence limits calculated for the regional\/national average based on the sample\/population sizes in the LIMITEXPECTED array.<\/p>\n

LIMITUPPER99<\/strong> \u2013 an array of the 99% upper confidence limits calculated for the regional\/national average based on the sample\/population sizes in the LIMITEXPECTED array.<\/p>\n

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.<\/p>\n

Refer to the \u2018Metadata\u2019 worksheet in the Excel workbook called IAworkbookBubblePlot_FunnelPlot_HTML.xls .<\/p>\n

\"image223\"<\/a><\/span><\/p>\n

An easy way of creating and entering an array is described below. In this example commas are used as delimiters.<\/p>\n

Start with a column in a new Excel workbook that contains the numbers for the array. The values 1, 2, 3\u2026 displayed in the image\u00a0below are example values only. In reality, these will be the actual values that you wish to use to plot the confidence limits.<\/p>\n

\"image224\"<\/a><\/span><\/p>\n

In cell B1 type =A1
\nIn cell B2 type =CONCATENATE(B1,”,”,A2)<\/p>\n

\"image225\"<\/a><\/span><\/p>\n

Copy the formula in cell B2 down until you reach the last value in column A. You can do this by clicking in cell B2 and double clicking the handle to the bottom right of the cell border.<\/p>\n

\"image226\"<\/a><\/span><\/p>\n

Your worksheet should now similar to that shown below.<\/p>\n

\"image227\"<\/a><\/span><\/p>\n

Copy the value in the bottommost cell in column B into your clipboard.
\nIn the Metadata worksheet of your Excel Data Manager, right click in cell that will contain the array and choose \u2018Paste Special…\u2019. The dialog shown below will appear.<\/p>\n

\"image228\"<\/a><\/span><\/p>\n

Click the \u2018Values\u2019 radio button and click \u2018OK\u2019.<\/p>\n

If you need the array delimiter to be a semi-colon rather than a comma your formula in cell B2 will be =CONCATENATE(B1,”;”,A2)<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Funnel plots are scatter plots upon which confidence limits have been superimposed. These confidence limits are plotted for a regional or national average. The limits enable you to see which observations are significantly different from the regional\/national average. The confidence limits form a funnel shape because these decrease as sample\/population sizes shown on the X … Continue reading Funnel Plot<\/span><\/a><\/p>\n","protected":false},"author":22,"featured_media":0,"parent":5481,"menu_order":3,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-5551","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/comments?post=5551"}],"version-history":[{"count":0,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5551\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5481"}],"wp:attachment":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/media?parent=5551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}