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. |
