If you want to routinely apply an R analysis to a lot of separate data files, or provide a repeatable analysis method to other people, an executable R script is a user-friendly way to do so. Instead of you or your user having to call
R and execute your script inside R via
source(.) or a function call, your user may simply call the script itself as if it was a program.