Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default Theory on test equating and linking

I am not a statistician but I have a question about test equating and
linking.
Currently I am using a linear equation formula that someone helped me
with(MartinW) to equate the test scores. We use a Mastery Test that
has different raw scores for each grade level; 106 for grade 3, 120
for grade 4, 140 for grade 5, 121 for grade 6, 124 for grade 7 and 148
for grade 8. For further information we use 70 percent as a passing
point, if that helps. For grade 3 a passing point would be 106 - 75
answers correct. This is how I am approaching it but, I do not have
enough experience in this area. Does anyone have any suggestions for
me? Is linear scaling a good approach? Need your expertise on this
one!

Thanks in advance PJ

This is an example of 2 different tests and is the formula approach
that I use.

Test 1: has as passing point of 70 and a max of 100
Test 2: has a passing point of 50 and a max of 70
To do a linear transformation
Call test1 y, and test2 x
Substitute into y = ax+b
At the passing score we get: 70 = a50+b
At maximum score we get: 100 = a70+b
Solve we a = 1.5 and b = -5
To convert test2 scores to a scale somewhat equivalent to test1 using
the formula : 1.5x-5
So a score of 60 on test 2 will transform to a score of 85
y=(1.5) 60 - 5 = 90- 5= 85.

Formula constructed by MartinW
=SLOPE($E$1:$F$1,$E$2:$F$2)*B1+INTERCEPT($E$1:$F$1 ,$E$2:$F$2)

With 70 in E1 and 100 in F1
With 50 in E2 and 70 in F2

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate mean of test scores from rows of test answers RiotLoadTime Excel Discussion (Misc queries) 1 July 26th 06 05:14 PM
theory of biorhythms deadman Excel Discussion (Misc queries) 2 May 27th 06 01:17 PM
How do i put themulti-attribution utility theory (MAUT) worksheet. lucky d Excel Worksheet Functions 1 February 13th 06 05:33 AM
Need a Multi-Attribute Theory (MAUT) Worksheet PBunkley Excel Discussion (Misc queries) 1 November 7th 05 04:46 AM
test..where are my messages..test HT New Users to Excel 0 January 23rd 05 06:23 PM


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"