#Graph plotting something (bench calculator)

147 messages · Page 1 of 1 (latest)

lone crater
#

Is there a way to find the formula of a graph just by plotting in some values? Even if we don't know what type of graph it is?

image.png
brazen patrolBOT
#
  1. Wait patiently for a helper to come along.
  2. Once someone helps you, say thank you and close the thread with:
+close
  1. Feel free to nominate the person for helper of the week in #helper-nominations
  2. Do not ping the mods, unless someone is breaking the rules.
  3. If you're happy with the help you got here, and the server overall, you can contribute financially as well:
lone crater
#

i would like to know if there exists a formula that can be retrived by plotting all these numbers on a graph, btw these numbers may be rounded up/down

teal pulsar
#

the more data you have, the more accurate your approximation can be

lone crater
#

ok and how do i do it? i have here 20 points so theoretically it should be enough

lyric sedge
#

it is ofcourse enough

plush cobalt
#

Use excel, super easy

lone crater
#

i have 2007 excel

plush cobalt
#

But I think it could work

lone crater
#

my pc i brand new idk why it is 2007

#

i even have licensed non pirated windows

plush cobalt
#

Okay

lone crater
#

thx for not giving a fuck

#

i actually dont remember how to plot graphs in excel

solemn vessel
lone crater
#

can u rq teach me how to plot grapsh

solemn vessel
#

Put numbers in two columns, then insert a scatter plot.

lone crater
#

which scatter

#

like oonly points

#

or the one with lines

solemn vessel
#

Only points.

lone crater
#

or does it even atter

#

ok

solemn vessel
#

So, what does it look like?

lone crater
#

like this

solemn vessel
#

No, you didn't do it correctly.

plush cobalt
lone crater
#

oh

#

aight

solemn vessel
#

The first column should contain numbers from 1 to 20, while the second should contain your values from 1 to 1.616.

lone crater
#

i mean

#

it still works

#

as intended

#

look

#

x are nums 1-20

#

y r the values

#

wont it work anyway?

solemn vessel
#

Well, even so, usually you present the data in colums, npt rows.

#

Anyway, what graph did you get for all 20 points?

lone crater
solemn vessel
#

No, columns.

lone crater
#

ill plot em later

#

the other one

solemn vessel
#

Try with more points.

lone crater
#

ones

solemn vessel
#

The more points, the better.

lone crater
#

ye but

#

i would like to try with those 5

#

then add more later

#

even if i know it wont be that accurate now

#

i just want to try as it is

plush cobalt
#

The X values can be divided into 20 portions ranging from 1.0-2.0

solemn vessel
#

Well, alright. Hm...
So far it looks pretty linear. Try a linear trendline.

lone crater
#

it is not linear

#

i changed it up a bit

#

but ye its not linear

solemn vessel
#

Hm... A power law, perhaps?
Try subtracting 1 from everything, then fitting a power law trendline.

lone crater
#

i have no idea what you mean by that

#

subtracting 1 from what

#

can i call you?

#

so i can share my screen

#

and we do it faster

solemn vessel
solemn vessel
lone crater
lone crater
solemn vessel
lone crater
#

so every index -1 and every value -1

#

pl

#

ok

#

the bottom one is the last one

#

it doesnt even look like it makes sense

#

it starts like a power

#

and then its linear

solemn vessel
#

Hm...

lone crater
#

but it also looks like it curves twice

solemn vessel
#

Oh, new idea.

#

Try a polynomial trendline for now.

lone crater
#

theres no option

#

i dont even have the exp one for this one

solemn vessel
#

No, double click on the trendline.

#

Then there will be more options.

lone crater
#

oh lmao

#

aight

#

and now

#

which order

#

2nd?

#

thats the one taht makes more sense

#

the other ones have weird forecasts

plush cobalt
#

It's linear

lone crater
#

its not

plush cobalt
lone crater
#

ye thats why i also get but its not linear

solemn vessel
lone crater
#

even tho it says 0.000x^2

solemn vessel
#

Though, again, where did these numbers come from?

lone crater
#

its a site

solemn vessel
#

Maybe we can figure something out from context.

lone crater
#

that calculates your bench 1 rep max

solemn vessel
#

What?

lone crater
#

by inputing your maximum amount of reps

#

with lower weight

#

i wanted to know the formula they use

#

but then while inspecting the element i found out theres no formula

solemn vessel
#

Oh, I see. I not familiar with a lot of sports terms.

lone crater
#

they just use random numbers with 3 decimal places

solemn vessel
lone crater
#

ye i guess its just data they got from experiments?

#

like from practical tests

#

with people

#

i mean it actually makes sense now that i think about it

plush cobalt
lone crater
#

try inputing some numbers

#

like 100 kgs and 2 reps

#

it means you can lift 100kg 2 times

#

back to bacj

#

on bench press

#

this exercise

#

no wait i clicked a random gif

#

here you go a bench press where the guy doesnt almost die

#

so ye if u lift 100x2

solemn vessel
#

Ah, I see. I've seen people do that.

lone crater
#

you can theoretically do 105x1

#

based on that site

#

and its actually pretty accurate

#

they dont let u put reps above 20 cuz then the practical result will be inaccurate due to various factors

#

but i still wanted to find the formula and do it myself just for fun

#

but i found out the horrendous truth

#

they just brute force everything

#

i mean not brute force but give each number their value

#

its like that odd or even numbers algorithm meme

#

Aight guys anyway tysm for ur help

solemn vessel
#

You're welcome!

lone crater
#

+close