MIS Systems Thread, Calculating Residuals in AM7 in Technical; Hi All,
I am planning on setting up templates to calculate residuals when the results come out in August, I'm ...
6th June 2011, 03:23 PM #1
- Rep Power
Calculating Residuals in AM7
I am planning on setting up templates to calculate residuals when the results come out in August, I'm using last year's data to have a play.
I've done RESULT - APS in one review column then another to divide by 6 to get the residual. However, when the result of the review column is negative, dividing it by 6 then puts it back to positive which is obviously a problem. Same thing occurs for Value Added.
Is there a way round this? I don't want to go back to Excel as we have done in previous years. Ideas/suggestions welcome!!
IDG Tech News
6th June 2011, 05:54 PM #2
- Rep Power
How do you get a -ve value for APS?
7th June 2011, 07:21 AM #3
That's what i was wondering.
Originally Posted by Banjo
Maybe the result is really a Value Added score or some measure of deviation from predictions...?
Is APS best 6 or 8 or am i just thinking about something else?
I just did a trial on a marks-integer aspect and dividing a negative number by a positive constant i.e. 6 doesn't make the answer positive, which is what i'd expect. The only way i'm thinking that could happen is if it's a grade aspect where the lower grades have negative scores associated with them.
By tinmanjo in forum Office Software
Last Post: 1st July 2010, 12:01 PM
By CAM in forum MIS Systems
Last Post: 28th October 2009, 12:13 AM
By wesleyw in forum Hardware
Last Post: 21st January 2009, 01:56 PM
By My220x in forum General Chat
Last Post: 28th July 2008, 12:12 PM
By sixfootsy in forum MIS Systems
Last Post: 15th January 2008, 05:47 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread