I am forwarding this to the list in the hope that someone can answer the
query.
-----Original Message-----
From: Adam Parnaby <[log in to unmask]>
To: [log in to unmask] <[log in to unmask]>
Date: 09 June 1999 13:39
Subject: Excel mailbase
>Dear Dr Hunt,
>
>I have been trying to find a discussion list for excel users. I
>understand you are the list owner for ASSUME which is specifically
>related to statistical issues and the use of excel. I dont think my
>problem is of relevance to your list but i hoped you might be able to
>help me either in locating an appropriate list or with the problem
>itself.
>
>I am a health economist at Brunel University and have been using excel
>to perform a decision analysis on the cost-effectiveness of neonatal
>screening strategies for a particular health condition. The main
>parameters of my model or 'tree' are probabilities (estimates of which
>are uncertain) and costs. The tree gives me expected costs and effects
>(benefits) for each strategy. Excel allows me to vary one or two
>parameters at a time using input tables and see the effect on the
>expected costs and effects. The only way i can see to deal with
>uncertainty on more than two parameters at a time is using the scenario
>analysis. However, this does not allow you to see the variation in the
>tree outcome as the parameters move through a given range. Do you know
>how to vary three or more parameters through a range and plot the
>changing value of a dependent cell? If this query is of no relevance or
>interest to your list members could you iinform me of a list that may
>be able to help.
>
>Many thanks in advance for your help.
>
>Adam Parnaby
>Health Economics Research Group
>Brunel University
>Tel 01895 274 000 ext 3467
>Fax 01895 203 330
>[log in to unmask]
>www.brunel.ac.uk/depts/herg/
>
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|