i feel dumb i need help

**Chocaholic** · April 29th, 2008, 06:04 PM

Have you tried doing the scatterplot in MS Excel? Put all the pretest figures in Column A and the final in Column B. Then create the graph through the Insert dropdown list.

Hope that helps.

**~shazz~** · April 29th, 2008, 07:00 PM

i have tried but i have never used it before i have no idea what i am doing i hate this rot and have no idea what it has to do with nursing arrrrrgh

**nickel** · April 29th, 2008, 07:21 PM

OK nurses are my heroes along with teachers - so let me help you if I can.

On the x axis (left to right), plot the "exam marks", ie. the numbers 0 to 100 in groups of 10, ie. 0,10,20,30,40 and so on.
Maybe have 1cm = 10 exam marks
Label this "Pretest "

Same on y axis (up and down) but label "Final marks"
a pretest= 90 final= 98, b pretest= 49 final = 62, c pretest= 66 final = 81,d pretest= 82 final =78, e pretest= 71 final = 75

Person a, got 90/100 for the pretest and 98/100 for the final.
so - go along the x axis (right to left) till you get to the number 90.
then go up the y axis until you get to the number 98. At that spot, put a dot and mark it "a".

Next, person b. Go along the x axis till you get to 49. Then go up till you get to 62.
I'm gonna do a rough drawing and put a link to it for you as it's a lot easier to explain like that.

Anyway, don't get caught up for the moment in the pretest/final thing.
Just think, x and y.
Once you have marked all the points, a-e, you will see that they roughly create a line, which increases from left to right. Ie. If you score a low pretest, then you will probably score a low final mark. which is what they are trying to get you to say.

Anyway - plotting it now for you, and going to scan it and send you a link. Hang in there.

Lots of love and positive vibes towards you for being a nurse!

plot "pretest",
on the y axis plot "final"

**nickel** · April 29th, 2008, 08:03 PM

Here you are - here is the link to the picture.
Hope this helps you understand what they are asking.

SHAZZ

**Lulu** · April 29th, 2008, 08:03 PM

well I feel dumb just reading that...!

**nickel** · April 29th, 2008, 08:19 PM

oh no. That's why I gave up and just did the graph for her!!

**~shazz~** · April 29th, 2008, 08:33 PM

nickel all i can say is thank you thank you thank you from the bottom of my heart your a life saver it was sending me batty and the ironic thing is that is how i had originally done it and my darling husband planted a seed of doubt so thank you again