Function Tables

Really usefull, thanks :)

ubezpieczenie-oc.net
składka oc kalkulator

thank you!!! XD

Is there a way to do this the other way around? i.e. Create a function from a set of data.

Umm so what are the limits of tables? How big can a table be? Do you think I could plot about 1523 to 4857 planets err.... I mean data points using desmos? What would be the best way to pull in large set of data?

Also can function tables be defined abstractly/indirectly? For example instead of the directly making a table sin(x), Making a table f(x), then define f(x) = sin(x)? This would be really useful to know for functions that have very long terms such as
f(x) = sqrt(1 - (cos(27.13/180*pi)*sin(pi*t)-sin(27.13/180*pi)sin(x-192.85/180*pi)cos(pi*t))
where -pi/2 < t < pi/2

Could you have a table of notes? or things "" for each element?

I have two functions which I've written out and graphed in Desmos: w=f(x) and s = g(x). Now, I want a cross plot such as in a table with heading f(x) and g(x), but it won't seem to let me do that. I believe this might be called a "parametric" graph so I can see the behavior of w as it relates to s for the same parameter, x.

I want to enter a table and have it give me the function rule. Can I do that?

for anyone on here looking for a way to make it "do the reverse" and give you a rule, regression is the key.

basically, you take the header of the output column you want (lets say M) and write a generic looking equation using just letters. use the tilde symbol instead of equals. for example:

M ~ mx + b

this will make desmos give you values for m and b that fit the data best, as well as give you the R^2 value which tells you how closely it fits (1 is best). does it have to be linear? nope. you can certainly find a line of best fit for a curvy set, but it'll take polynomial expressions too. desmos warns that the regression is only really effective with linear and polynomial (including parabolas, cubics, conic section, etc.) functions, but i've made it figure out some pretty freaky ones. here are some examples from desmos:
linear
https://www.desmos.com/calculator/jwquvmikhr
line of best fit (and other cool stuff)
https://www.desmos.com/calculator/paknt6oneh
polynomial
https://www.desmos.com/calculator/sanlujpfmc

this one has 4 graphs from something i was working on
https://www.desmos.com/calculator/ejoqasul6s
(note, it uses w instead of x)

"log mode" is just a different algorithm that usually gives you the same thing but might save your life if the graph is being weird.

Is is possible to generate a table with a start value (such as 0, an an increment such as 0.001?

this is just off the top of my head, but you can make a set using a linear equation and then tell desmos to fill out a table for it.

Y=m[0...x]+b

where Y is the name of the set, m is the increment, x is the number of items, and b is the start value.

then, you put Y (or whatever you name the set) in the table, and it will fill out the column for you. i did yours as an example in the picture.

actually, now that i think about it, you can just enter the expression right in the column header instead of making a set.

Cool that you can use a list in an expression. Thx.

How can I fill the abscissa (first) column?

you can't directly, but you can very easily have desmos define an equivalent set. the downside is the table will not reflect changes to the x-set unless they're done directly to the table, but you can just easily define the table again.

you start by defining your set "b" along with a function or another list

then you pair them up as you would with coordinates. if you're using a function, make sure it's taking the set as an input. 

then hit the options button and click the table symbol that appears over the pair.

desmos will then turn the pair into a table of 2 new sets that are equivalent to the originals. you can add new functions and sets to the table, including replacing the y-set with the original function or set you wanted.

Soooo it doesn't even give me the option to covert my graphed functions into a table. Please fix.

solve it for a variable. the function shown there isn't defined explicitly for either variable ("y=" or "x="), so desmos has no way of telling input from output or if a table can even be made.

for example, y=2x+1 can be converted with x as the input and y as the output. on the other hand, y^2+x^2=1 cannot because neither y nor x have unique outputs.

how can you get the derivative of a table?

that looks a lot like world population. the derivative of a line graph is just the slope between any two points, but i assume you mean the derivative of a curve that fits the line graph. in this case, regression is your friend.

first we pick a type of function that fits our data. for population, exponential is best. now we write an exponential function with y1 and x1 and a bunch of parameters (just random letters). instead of an equals sign, use a tilde ~

now desmos fills in the parameters with actual numbers. we just write the same exact thing but replace y1 with f(x) and x1 with regular old x.

then, just take the derivative.

edit: you can also use the notation f'(x) to take the derivative faster (instead of d/dx)