View source for Talk:1da-workshops-2011

This is the discussion page for the First Year data analysis classes 2011.  Please discuss any problems which you may have here, and please do feel free to post possible answers/resolutions which you may have also.

=Introduction=

A few guidelines are needed to make sure of efficient use of this resource:

# Before posting a problem, do check to see if it has been answered before.
# If you see a problem which someone has posted, and you can answer it, please do post an answer.
# Try to keep on-topic!

==Anonymity==
You do not need to leave a name (for either a question or an answer), but if you wish, that is fine.  Bear in mind this page is publicly accessible, so it may be advisable to not include contact details.

==Structure of questions==

Try to structure your questions in '''bulleted bold text''', and answers in ''italic text'' immediately below the question.  This makes it easy to spot them!  To do this in WikiEdit, enter the following code:

 <nowiki>*'''Bulleted Bold text for Questions'''</nowiki>
*'''Bulleted Bold text for Questions'''
 <nowiki>''Italic text for answers''</nowiki>
''Italic text for answers''

===Example question and answer===

*'''How can I lock a cell in Excel?'''
''If you use the $ (dollar) operator, this will fix any value that comes immediately after it.  It is only needed when you intend to copy or extend a formula to other cells, as Excel will copy a formula rather than a value if a formula is present.  If you copy '''=A5+6''' from cell '''A12''' to '''A14''', then the formula will dynamically adjust to '''=A7+6'''.  If you change the formula in cell '''A12''' to '''=A$5+6''' then when you paste it, the row number in the cell is 'locked' and will remain at '''row 5''' when you paste it elsewhere.  Note that the column letter, '''A''' would be free to change.''

=General Excel problems=

=Exercise 1: Standard Errors=

=Exercise 2: Linear functions=

=Exercise 3: Non-linear functions=

=Exercise 4: Biexponential decays (Solver)=