I need some help please!

K

Kat

Hello, I will be extremely grateful to anyone who can help me with this. I
need to create a graph using the information below. "Using an appropriate
technological tool of your choice, make a properly labeled graph of the
situation. Is your solution from B correct? Explain your reasoning."

Can anyone tell me how I would do this? I have the following information:

60 + 5t = 135 – 10t
-60 -60
5t = 75 – 10t
+10t + 10t
15t = 75
t = 5

This is the entire problem...

"Currently, Person A has $60 and Person B has $135. Person A decides to save
$5 of his/her paycheck each week, while Person B decides to spend all of
his/her paycheck and an additional $10 each week. How long will it be before
Person A and Person B have the same amount of money? The following represents
the situation:

Person A's Current Savings
+ 5 ×
Number of Weeks
=
Person B's Current Savings

– 10 ×
Number of Weeks
 
B

Bernard Liengme

1) In A1,B1,C1 enter these text values: t, A, B
2) In A2:A11 enter this series of numbers 1,2,3,4,5,6,7,8,9,10
3) In B2 enter the formula =60+5*A2
4) Copy this formula down to B11: click on B11; in the lower right corner
there will be a small solid square (fill handle); with the mouse EITHER drag
the fill handle down to B11 OR double click the fill handle
5) In C2 enter the formula =135-5*A2
6) Copy this down to C11
7) Click on any cell in A1:C11; and use the chart wizard to make an XY
chart; The subtype you want is the one with lines
8) You should see the two lines cross at t=5
In fact, the table alone should show you this.
Best wishes with your homework and do remember to acknowledge help from this
newsgroup when you hand it in. Otherwise you will be guilty of the sin of
plagiarism - using someone else's work and presenting it was you own.
 
D

dlw

make three colums:
A B C
week PersonA PersonB
in column A, just put numbers 1 through 10
in Column B, put =60+(a2*5) that's 60 plus 5 times whatever week it is
in Column C put =135-(a2*10)
then copy the formulas down and see what week they equal.

Of course, you may have to take a class in excel for any of this to make
sense...
 
K

Kat

Bernard,
Thank you so much! Yes I do acknowledge all of my sources!!! I am going
to college to teach. ;) I have just been having some issues with knowing how
to use EXCEL!!!! I need to take a course, but it wasn't offered this
semester. Didn't know I'd need this for my class....no indication! Thanks
so much again!!
KAT
--
Cornfused about Excel


Bernard Liengme said:
1) In A1,B1,C1 enter these text values: t, A, B
2) In A2:A11 enter this series of numbers 1,2,3,4,5,6,7,8,9,10
3) In B2 enter the formula =60+5*A2
4) Copy this formula down to B11: click on B11; in the lower right corner
there will be a small solid square (fill handle); with the mouse EITHER drag
the fill handle down to B11 OR double click the fill handle
5) In C2 enter the formula =135-5*A2
6) Copy this down to C11
7) Click on any cell in A1:C11; and use the chart wizard to make an XY
chart; The subtype you want is the one with lines
8) You should see the two lines cross at t=5
In fact, the table alone should show you this.
Best wishes with your homework and do remember to acknowledge help from this
newsgroup when you hand it in. Otherwise you will be guilty of the sin of
plagiarism - using someone else's work and presenting it was you own.
Click to expand...
 
K

Kat

Thanks so much! I know! I have tried to but it's not offered right now.
Just had no idea that I'd need it.
 
Top