Spreadsheet help
Posted: Tue Dec 28, 2004 11:47 am
Hello.
I've never used spreadsheets before, but I'm in a position where I have to. I got a calculus assignment, and it goes soemthing like this: I'm given a set of x and y values, and I need to choose a function (out of 25 given ones) which will serve as a curve of best fit. Seeing as I don't want to do all this manually, my instructor suggested that I use a spreadsheet, and said that once I figure out how to use one, it shouldn't be too much work. So, I created a spreadsheet, put in my x and y values, and now I need the function (f(x)) values in the third column. I also need a graph that will depict both, the data set, and the function on one grid. I will keep changing the function in the third column until I get the right one. Here's what my excel window looks like now:

How would I enter a function like y=3x * (1.4)^x into excel? Keep in mind that x is the first column, and y is what I need in the third column. I also need a graph.
Thanks!
I've never used spreadsheets before, but I'm in a position where I have to. I got a calculus assignment, and it goes soemthing like this: I'm given a set of x and y values, and I need to choose a function (out of 25 given ones) which will serve as a curve of best fit. Seeing as I don't want to do all this manually, my instructor suggested that I use a spreadsheet, and said that once I figure out how to use one, it shouldn't be too much work. So, I created a spreadsheet, put in my x and y values, and now I need the function (f(x)) values in the third column. I also need a graph that will depict both, the data set, and the function on one grid. I will keep changing the function in the third column until I get the right one. Here's what my excel window looks like now:

How would I enter a function like y=3x * (1.4)^x into excel? Keep in mind that x is the first column, and y is what I need in the third column. I also need a graph.
Thanks!