Home work due 9/12
Hi,For the homework due this Tuesday, please spend a some time working with Excel so you can get more familiar with this powerful tool.Experiment with the paste special, the functions (e.g., =average( ) ), fill down and fill over, and graphing functions.Using one of your data sets, make a graph and explain it as though it were a figure in a results section of a manuscript you are writing (Hint you may want to describe the variables you are using for the graph what they are (THC Level) and use some descriptive statistics. I am not looking for anything in particular other than for evidence that you spent some time thinking about Excel and that you understand how to make a graph and how to discuss a graph). This should be rather straight forward (not too difficult), I just want you to get and stay familiar with Excel, so you use it when you need it.Thanks a lot - Have a good weekend.
--Dr. M
posted by maclin_uni @ 7:51 AM
2 Comments:
can you explain how to randomize data again? I've been trying but my notes are not specific enough...
thanks
Suppose you want to randomize the numbers 1 through 10.
Using the function =rand() to create a random number between 0 and 1. Type the function in cell A1. Use the fill down (or copy and paste) so the random function is the 10 cells you want A1 to A10.
Next type the nuumber 1 in cell B1 and the number 2 in cell B2. Select both B1 and B2, then use the fill down and you should now have the numbers 1 to 10.
Now select the entire range of numbers (A1:B10).
From the data menu select sort and sort on Column A. This should randomize the 10 numbers.
Notice too that Excel has re-assigned random numbers to the values in column A. This is becasue the =rand() function is dynamic and everytime something changes in Excel the you get new random numbers...
I hope this helps,
--Dr. M
Post a Comment
<< Home