fsu seal Florida State University
  Center home >> help >> stat. software FAQ
 

Statistical Software FAQ:


Stata Application:

Excel Application:

  • String last name, first name, and title together
    first_name  last_name  title
    Chris       Smith      Professor
    Joy         Edwards    Miss
    Ken         Taylor     MD
    
    Can I combine them together and form a fourth column such as: Professor-Chris
    Smith? Sure, please see ==HERE==
  • Tip to Calculate Your Students' Grade:
  • Example question: I have my students taken 5 tests, and I want to sum up the best 3 of the five tests and take the average as their final grade. How to do that if I store all my stuents grade on Excel?

    e.g. you have 5 columns: A1 to E1 for these 5 tests score,you want to sum up the best 3 and put it in Column F1.

    Possible answer: you may simply enter this formula to Column 6: " = AVERAGE(LARGE (A1:E1,1),LARGE(A1:E1,2),LARGE(A1:E1,3)) "

    That is easy!

back to previous page