View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default A bit of a complicated Array that I can't figure out! HELP!

Dan,

It isn't an array formula but I can't see anything wrong with it and it
works in the way I understand you to be describing.

What it will do is give an overview of any 'shift' in satisfaction levels.
i.e people generally are/aren't more satisfied upon discharge. I'm not
qualified to coment on whether that is of statistical significance or not.

Mike


"Dan the Man" wrote:

Not exactly sure how to come up with the proper formula, but I do know the
requirements that I'm looking for. If anyone could help I'd appreciate it.

I have two columns of data, and 5000 rows. The Columns are (M) and (AC)..
Each cell in Columns (M) and (AC) have numerical values of 5, 10 & 15 in
them. Upon admission we ask individuals to rate their response to a
statement, and upon discharge we re-rate them in order to see if their was a
shift in their responses based upon what they learned.

Thus I'd be comparing the admission response in Column (M), to the discharge
response in Column (AC), by subtracting the "discharge response (AC), from
the Admission response (M).

The other two variables include that individuals are in different programs,
and I want to also compare the responses obtained across programs. I have
come up with part of a formula, but I know I don't have the entire thing
accurate. Any help would be appreciated. Here's is the the array formula that
have so far (which doesn't really work correctly however).

=SUMPRODUCT(--('Raw Data'!W4:W5000=DATE(2008,1,1)),--('Raw
Data'!W4:W5000<=DATE(2008,12,31)),--('Raw Data'!D4:D5000="CIC"),--('Raw
Data'!AC4:AC5000-M4:M5000))

Thus, the Columns in the formula are taking into consideration: Date
parameters (Column W), the program assignment (Column D), and the response to
the question (Column AC is the discharge response, and Column M the admission
response).