cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
LarsBirger
Level II

How to do a funnel plot?

I wonder how to do a funnel plot. I would like to be able to do a funnel plot answering the following problem which I describe here.

 

In Sweden there are different counties. In all the counties they operate cholecystectomies for which there are two main indications cholecystitis or colic.  We believe that the frequency of cholecystectomies with cholecystitis, which is more difficult to operate and has more complications, differ significantly between the different counties or regions. I would like to, in a funnel plot, plot the proportion of cholecystitis indication for each different county but I do not know exactly how to do it.

I found on the web a funnel plot add In but I do not exactly understand how to use it:

 

See enclosed photoFunnel plot add in.jpg

 

Here below is an example of file:

Region               Indication                                      Cholecystitis=1

A                          Cholecystitis                                 1

B                          Colic                                                 0

D                          Colic                                                 0

A                          Cholecystitis                                 1

B                          Cholecystitis                                 1

C                          Colic                                                 0

Etc.

 

I would appreciate if you could tell me if it is possible to do in JMP and if so how I should do it.

 

 

Sincerely yours

 

Lars

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to do a funnel plot?

Sorry. I am not the author of this add-in. I don't use funnel plots or this add-in.

 

It is a simple scatter plot. Your data set must be arranged with the sample size in one column and the corresponding occurrences (count) in another column. It does not provide any way to account for groups. I think that such levels are represented by the rows. That is, the rows represent the groupings that are meaningful to you. So you could use the Tables > Summary command to create the data table for the add-in if your raw data are single observations. You can group by Region and sub-group by Indication. You will automatically get N counts. You can then add a column with a formula to sum N for both indications. The funnel plot will then use the sum for the total and the N for the indication of interest for occurrences.

View solution in original post

3 REPLIES 3

Re: How to do a funnel plot?

A search in the JMP Community returned this contributed add-in for funnel plots.

LarsBirger
Level II

Re: How to do a funnel plot?

Thank you for the advice for the automatic search for the Funnel Plot add-in. However, I  already found that add-in the problem is that when I use it the way I supposed that I should use it I do not get the reply I expected - in fact I did only get a skeleton of a graph but without any dots so obvioulsy I get it wrong. The original file as an example is shown below:

Here below is an example of file:

Region               Indication                                      Cholecystitis=1

A                          Cholecystitis                                 1

B                          Colic                                             0

D                          Colic                                             0

A                          Cholecystitis                                 1

B                          Cholecystitis                                 1

C                          Colic                                             0

Etc.

 

The question is could I get the proportions of cholecystitis plotted against the different regions from this table using the Funnel Plot AddIn or should I reorganize a new table in a somwhat different fashion in order to use the Funnel Plot AddIn? 

 

 

Sincerely yours

 

Lars Enochsson

Professor of Surgery

 

 

Re: How to do a funnel plot?

Sorry. I am not the author of this add-in. I don't use funnel plots or this add-in.

 

It is a simple scatter plot. Your data set must be arranged with the sample size in one column and the corresponding occurrences (count) in another column. It does not provide any way to account for groups. I think that such levels are represented by the rows. That is, the rows represent the groupings that are meaningful to you. So you could use the Tables > Summary command to create the data table for the add-in if your raw data are single observations. You can group by Region and sub-group by Indication. You will automatically get N counts. You can then add a column with a formula to sum N for both indications. The funnel plot will then use the sum for the total and the N for the indication of interest for occurrences.