Posted: 12/11/2012 11:34:59 PM EDT
|
Hey all, Need to create an equation that will take a beginning value (in my case -6.85) and add .042 to it but, need it to do that 250 times!! I am trying to create a graph that represents my regression that is: Y = a + bx where a= -6.85 and b= .042 and X= 250 I hope I am explaining this correctly. Any help would be great, I know its late....TIA |
|
Quoted: Hey all, Need to create an equation that will take a beginning value (in my case -6.85) and add .042 to it but, need it to do that 250 times!! I am trying to create a graph that represents my regression that is: Y = a + bx where a= -6.85 and b= .042 and X= 250 I hope I am explaining this correctly. Any help would be great, I know its late....TIA =(-6.85+(0.042*250)) ? Or do you need 250 separate values? |
|
Quoted: Quoted: Hey all, Need to create an equation that will take a beginning value (in my case -6.85) and add .042 to it but, need it to do that 250 times!! I am trying to create a graph that represents my regression that is: Y = a + bx where a= -6.85 and b= .042 and X= 250 I hope I am explaining this correctly. Any help would be great, I know its late....TIA =(-6.85+(0.042*250)) ? Or do you need 250 separate values? I need it to add .042 to -6.85 250 times i.e: -6.85 + .042= -6.808 + .042= -6.766 + .042 = -6.724 + .042 = -6.682 |
|
Quoted: Put -6.85 in block A1 Put .042 in block C1 Put =A1+$C$1 in block A2 grab the bottom right corner of block A2 and drag to A250 highlight data, click on insert tab => line chart A251, actually. He needs the starting point of -6.85 and then 250 changes as well. I used a slightly clunkier method that didn't include the static cell reference symbols. So long as his line chart(graph) references the 251 cell range as its data source, he should be fine. |
Win a FREE Membership!
Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!
You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.