Видео

now you have a faster way to calculate parallel resistance.

Any value less than slack is call Float.

the graph for LINEST (line estimate) comes in many mathematical forms, i.e., Linear, Exponential, Logarithmic, Power Series, Polynomial. To get the best fit of the line estimate, make sure RSQ is almost 1.0 or closer.

​@@pjarinathanks , tried for logarythmic - and seems it works. slope/intersept gives not same coeficients as chart formula - but in my case they worked for 'prediction' 😇

@@alexandre7099 ...you can try polynomial to the 10th degree for the best fit.

@@alexandre7099 here's the LINEST logarithmic regression. ruclips.net/video/q44KhDtzALU/видео.htmlsi=HvADfMVrR7thqzfg

You can check wikipedia: en.wikipedia.org/wiki/Logistic_regression

Thanks very few videos show the mathematical applications of spreadsheet functions.

Thanks for noticing, but this is the better version for multiple logarithmic regression: ruclips.net/video/xBZZY-kOpg4/видео.htmlsi=2KgaS2Je5EOnI1q5

This is the better version: ruclips.net/video/1JEEBsGAlN0/видео.htmlsi=_TAV5qrkBjoJDang

my ETSY account stopped.

thanks.

Thanks...only those who understand the applications of FACTDOUBLE can explain what is FACTDOUBLE. Otherwise, you just read the help file.

Advance math can be in spreadsheet form.

@@Dodong-pf8dc ...of course, spreadsheet is a great tool for advance math....very few in youtube understand the use of SERIESSUM.

Thanks for noticing. There are better videos for Gaussian Integral in Google Sheets or Excel.

@@pjarina Maybe, but I was looking also for method to determine polinominal model and its values. Google sheet equations never matched whit trend line when I used them.

@@pjarina Do you have also videos about determining the equation values for other models? I'm most interested in forecasting the future values.

@@serafm4565 those are for quants only...they are not free...they use statistical functions for options trading.

@@pjarina I see, but I think about forecasting something like the revenues and cash flows of companiees, so I was wondering if this would help me in it.

Thank you for noticing.

There are videos about IMSINH...no mathematical explanation.

Thanks for noticing, Q function has many uses in engineering.

Most RUclips video content simply explains the content of the function's help file or the practical application. Very few explains the mathematics used to derive the function.

Yes, you are right

Except for Slope and Intercept, LOGEST and LINEST both yield the same statistical results. No RUclipsr understands this.

Most RUclipsrs cannot calculate coefficients slope and intercept using matrix

Spreadsheet functions can be used for Gaussian Function, Gaussian Integral and Q functions. RUclips mathematicians don't understand spreadsheet functions. But you find RUclips Geeks without math have clownish videos about these functions using help file.

It's unfortunate that spreadsheets were the first applications known to non-programmers, mathematicians included. But, no one cared to make use of the built in features of the common spreadsheets. So in RUclips, we have coders and geeks without math and mathematicians without spreadsheets.

You can't blame them RUclips community bias works in their favor with more views. Clowns have been dominating RUclips.

Thank you...it's a simple introduction.

There's still no video about orthogonal polynomials using spreadsheets. There's just too many Mathematicians without spreadsheets and too many coders without math.

@@pjarina .. coders without math in Google sheets altered Data Validation making it useless.

@@p.j.882 ...I can't blame them...coder's without math just rely on plug ins developed by AI...ignorance is a bliss.

Mathematicians without spreadsheet explained it very well.

Be careful, some people in the RUclips community and Google may get insecure. Just keep it simple. Don't show any advanced videos.

@@p.j.882 ...most RUclipsrs explain what's in the help file of SERIESSUM word for word. They are just monkeying the help file because they don't have the mathematics for SERIESSUM.

The content of this video exposes those that cannot explain SERIESSUM and LINEST using mathematics.

@@p.j.882 ...all other RUclipsrs don't understand the true purpose of SERIESSUM. The purpose of SERIESSUM is to show the values of a polynomial with sequential values of n (the power of the input value).

Glad it was helpful!

Thanks

Thanks...FACTDOUBLE function can also be used.

Try changing the spreadsheet settings: ruclips.net/video/bU0z_6gxI98/видео.html

The Part 4 is way better than Part 3....give it a try.

the file was deleted. but I will reconstruct in KDP Amazon all the Gantt Charts of this channel.

@@pjarina Okay, thanks. Do you also have a version with Holidays added into it? So that the calculations skip Holidays.

@@avishkarsurana8201 ...it will be included in the advanced version videos where google sheet gantt charts are linked with calendars. These will be uploaded after if I get monetized. For now, we have to wait.

@@pjarina ok. Is there a way i can pay you to make such an excel for me?

@@avishkarsurana ...I will let you know when done. Just keep subscribed to get my notification.

ruclips.net/video/wqWE6ktHFz4/видео.html