I have pre-post tests that I would like to enter into an excel spreadsheet.
I know how to code but do not know how to write a formula that will show me
what differences occurred in knowledge gained from the pre test to the post
test. In other words, did students do better or worse?
--
Keep on smiling!

Paired difference hypothesis test?

look at TTEST in excel Help.

--
Regards,
Tom Ogilvy


"paj" wrote:

> I have pre-post tests that I would like to enter into an excel spreadsheet.
> I know how to code but do not know how to write a formula that will show me
> what differences occurred in knowledge gained from the pre test to the post
> test. In other words, did students do better or worse?
> --
> Keep on smiling!

Lots of ways but basically you ned a cell with pre and post test scores in
for you to compare.

In these examples pre test is in B12, post test is in C12 and the maximum
mark possible is in A12:-

="Student A scored "& (B12/A12)*100&"% before the tests "&(C12/A12)*100&"%
after the tests"

or

=IF(C12>B12,C12-B12&" mark improvement",IF(B12>C12,B12-C12&" Reduction in
mark","Nochange"))

Mike

"paj" wrote:

> I have pre-post tests that I would like to enter into an excel spreadsheet.
> I know how to code but do not know how to write a formula that will show me
> what differences occurred in knowledge gained from the pre test to the post
> test. In other words, did students do better or worse?
> --
> Keep on smiling!

Thanks Mike -- in particular for taking the time to write out the formunal --
will try and see what happens.

One more question: Your example was for one question. How do you deal with
an overall improvement, lets say for 14 questions and 200 respondents. An
aggregate improvement.

--
Keep on smiling!


"Mike H" wrote:

> Lots of ways but basically you ned a cell with pre and post test scores in
> for you to compare.
>
> In these examples pre test is in B12, post test is in C12 and the maximum
> mark possible is in A12:-
>
> ="Student A scored "& (B12/A12)*100&"% before the tests "&(C12/A12)*100&"%
> after the tests"
>
> or
>
> =IF(C12>B12,C12-B12&" mark improvement",IF(B12>C12,B12-C12&" Reduction in
> mark","Nochange"))
>
> Mike
>
> "paj" wrote:
>
> > I have pre-post tests that I would like to enter into an excel spreadsheet.
> > I know how to code but do not know how to write a formula that will show me
> > what differences occurred in knowledge gained from the pre test to the post
> > test. In other words, did students do better or worse?
> > --
> > Keep on smiling!