+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1

    Join Date
    Jan 2011
    Posts
    28
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Blog Entries
    1
    Rep Power
    0

    Calculating Residuals in AM7

    Hi All,

    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!!

    Charlotte

  2. #2

    Join Date
    Mar 2010
    Location
    UK
    Posts
    162
    Thank Post
    0
    Thanked 16 Times in 15 Posts
    Rep Power
    16
    How do you get a -ve value for APS?

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,836
    Thank Post
    671
    Thanked 1,380 Times in 1,142 Posts
    Rep Power
    348
    Quote Originally Posted by Banjo View Post
    How do you get a -ve value for APS?
    That's what i was wondering.

    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.

SHARE:
+ Post New Thread

Similar Threads

  1. calculating cells without draging selection
    By tinmanjo in forum Office Software
    Replies: 3
    Last Post: 1st July 2010, 11:01 AM
  2. [SIMS] Good AM7 Data Structure
    By CAM in forum MIS Systems
    Replies: 9
    Last Post: 27th October 2009, 11:13 PM
  3. Calculating Server Energy Usage
    By wesleyw in forum Hardware
    Replies: 4
    Last Post: 21st January 2009, 12:56 PM
  4. Calculating days to next birthday?
    By My220x in forum General Chat
    Replies: 3
    Last Post: 28th July 2008, 11:12 AM
  5. Calculating a variety of % in SIMS
    By sixfootsy in forum MIS Systems
    Replies: 6
    Last Post: 15th January 2008, 04:47 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •