hi all,
let's say i want to take the average of 5 scores for class tests for each student in a class. the data looks like the below EXCEPT averagescore. That is the column I want to generate!
student test1 test2 test3 test4 test5 averagescore
1 7 8 NA 7 9 7.75
2 5 5 NA NA 9 NA
3 9 9 9 9 9 9
how do i dictate NA in aveagescore if 2 OR MORE scores are missing? thank you!
let's say i want to take the average of 5 scores for class tests for each student in a class. the data looks like the below EXCEPT averagescore. That is the column I want to generate!
student test1 test2 test3 test4 test5 averagescore
1 7 8 NA 7 9 7.75
2 5 5 NA NA 9 NA
3 9 9 9 9 9 9
how do i dictate NA in aveagescore if 2 OR MORE scores are missing? thank you!