The topic Killing Fergus contains some discussion on initial stat distribution. There are lots of different effective builds for a warrior, depending on your playstyle. You will need some agility, but Sharpen isn't essential if you don't want to go with an agility or strength/agility focused warrior. Some people love sharpened weapons; I would eventually tried it, but didn't have the agility to be able to use more than level 1 or 2 (I recall saving before learning Sharpen, and testing it out in steps, one of which added too much to the agility requirement for me to use the weapon afterwards).

If you want your archer to have a couple mage skills, then off the top of my head (and without playing a mage character) I would recommend Hammer and Insect Swarm. I had both my characters learn level 2 of the healing spell early in the game (you can find a book that teaches it after you get to the second level, past the arena), but didn't really feel the need to boost it after that.


Near the end of my game, my DK warrior and crossbow archer's stats were as below (with and without equipment bonuses). Shortly after this I switched my hero to a bow and made some permanent agility potions for an extra boost there, for the final couple fights in the game.

Code
                 Hero          DK
Strength       61 .. 45     61 .. 51
Agility        53 .. 34     38 .. 35
Constitution   26 .. 11     23 .. 14
Intelligence   12 ..  1      4 ..  1
Survival       21 .. 14     29 .. 18
Speed          35 .. 16     20 .. 20
unused            32           10