![Phil Jarina](/img/default-banner.jpg)
- Видео 525
- Просмотров 137 511
Phil Jarina
Канада
Добавлен 22 апр 2007
Welcome to the channel where the humble Spreadsheet meets Mathematics.
This channel shows the use of Google Sheet and Excel functions in Advance Mathematics, Statistics, and PERT CPM Gantt Charts.
This channel shows the use of Google Sheet and Excel functions in Advance Mathematics, Statistics, and PERT CPM Gantt Charts.
sin(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION GAMMA Google Sheets or Excel
sin(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION GAMMA Google Sheets or Excel
Просмотров: 45
Видео
sin(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION FACTORIAL Google Sheets or Excel
Просмотров 3828 дней назад
sin(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION FACTORIAL Google Sheets or Excel
sin(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION FACTDOUBLE Google Sheets or Excel
Просмотров 32Месяц назад
sin(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION FACTDOUBLE Google Sheets or Excel
cos(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION FACTDOUBLE Google Sheets or Excel
Просмотров 66Месяц назад
cos(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION FACTDOUBLE Google Sheets or Excel
cos(wx)Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION FACT Google Sheets or Excel
Просмотров 29Месяц назад
cos(wx)Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION FACT Google Sheets or Excel
cos(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION GAMMA Google Sheets or Excel
Просмотров 53Месяц назад
cos(wx) Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION GAMMA Google Sheets or Excel
cos(x)Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION GAMMA Google Sheets or Excel
Просмотров 45Месяц назад
cos(x)Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION GAMMA Google Sheets or Excel
k^x Taylor Maclaurin SERIESSUM LOGEST EXPONENTIAL REGRESSION Google Sheets or Excel
Просмотров 692 месяца назад
k^x Taylor Maclaurin SERIESSUM LOGEST EXPONENTIAL REGRESSION Google Sheets or Excel
COMBIN Geometric Series Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION Google Sheets excel
Просмотров 772 месяца назад
COMBIN Geometric Series Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION Google Sheets excel
COMBINA Geometric Series Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION Google Sheets excel
Просмотров 622 месяца назад
COMBINA Geometric Series Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL REGRESSION Google Sheets excel
LINEST RSQ COVAR VARP in Google Sheets or Excel
Просмотров 342 месяца назад
LINEST RSQ COVAR VARP in Google Sheets or Excel
LINEST STEYX Degree of Freedom Residual Sum of Squares in Google Sheets or Excel
Просмотров 432 месяца назад
LINEST STEYX Degree of Freedom Residual Sum of Squares in Google Sheets or Excel
LINEST SLOPE COVAR VARP in Google Sheets or Excel
Просмотров 513 месяца назад
LINEST SLOPE COVAR VARP in Google Sheets or Excel
LINEST RSQ CORREL PEARSON SQRT in Google Sheets or Excel
Просмотров 653 месяца назад
LINEST RSQ CORREL PEARSON SQRT in Google Sheets or Excel
COMBINA GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
Просмотров 673 месяца назад
COMBINA GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or excel
COMBIN GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
Просмотров 733 месяца назад
COMBIN GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
PERMUT GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets excel
Просмотров 723 месяца назад
PERMUT GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets excel
GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
Просмотров 733 месяца назад
GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
Просмотров 713 месяца назад
GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
Просмотров 893 месяца назад
GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
FACTDOUBLE GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
Просмотров 914 месяца назад
FACTDOUBLE GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
FACTDOUBLE GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
Просмотров 964 месяца назад
FACTDOUBLE GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
FINITE GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets excel
Просмотров 924 месяца назад
FINITE GEOMETRIC SERIES TAYLOR MACLAURIN SERIESSUM LINEST POLYNOMIAL Regression Google Sheets excel
GEOMETRIC SERIES LINEST POLYNOMIAL Regression Google Sheets or Excel
Просмотров 1074 месяца назад
GEOMETRIC SERIES LINEST POLYNOMIAL Regression Google Sheets or Excel
GEOMETRIC SERIES LINEST POLYNOMIAL Regression Google Sheets or Excel
Просмотров 694 месяца назад
GEOMETRIC SERIES LINEST POLYNOMIAL Regression Google Sheets or Excel
GEOMETRIC SERIES Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
Просмотров 774 месяца назад
GEOMETRIC SERIES Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
GEOMETRIC SERIES Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
Просмотров 714 месяца назад
GEOMETRIC SERIES Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL Regression Google Sheets or Excel
GEOMETRIC SERIES LINEST POLYNOMIAL Regression Google Sheets or Excel
Просмотров 924 месяца назад
GEOMETRIC SERIES LINEST POLYNOMIAL Regression Google Sheets or Excel
GEOMETRIC BINOMIAL SERIES Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
Просмотров 1074 месяца назад
GEOMETRIC BINOMIAL SERIES Taylor Maclaurin SERIESSUM LINEST POLYNOMIAL Regression Google Sheets
GEOMETRIC BINOMIAL SERIES Taylor SERIESSUM LINEST POLYNOMIAL Regression Google Sheets Excel COMBINA
Просмотров 854 месяца назад
GEOMETRIC BINOMIAL SERIES Taylor SERIESSUM LINEST POLYNOMIAL Regression Google Sheets Excel COMBINA
Thank you
now you have a faster way to calculate parallel resistance.
Slack is the maximum allowable delay to start a task that is not part of the critical path without delaying the project.
Any value less than slack is call Float.
Shadow blocking this channel only exposes low quality channels with high fake views...huge embarrassment to the content creators.
This video cannot be shadow blocked. All other videos of BINOMDIST and NEGBINOMDIST do nothing but read the help files.
Sssigma sex
interesting, thanks, but seems the Data Y is generated based on coeficients b0 and b1 , because if you will take random numbers as Y you can't get same coeficients as chart formula gives.
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
This was extremelly helpful! The syntaxis in the Google sheets documentation wasn't clear enough for the case of a polynomial regression. Thank you very much :)
You can check wikipedia: en.wikipedia.org/wiki/Logistic_regression
The best mathematical application for seriessum function.
Thanks very few videos show the mathematical applications of spreadsheet functions.
Thank you, this was very useful.
Thanks for noticing, but this is the better version for multiple logarithmic regression: ruclips.net/video/xBZZY-kOpg4/видео.htmlsi=2KgaS2Je5EOnI1q5
Somebody tampered RUclips algorithm changing views count from 801 to 799.
Copycats will be shamed with advanced version...beware!
Members of RUclips community are removing the view counts. Copycats will be shamed with advanced versions.
Thanks
This is the better version: ruclips.net/video/1JEEBsGAlN0/видео.htmlsi=_TAV5qrkBjoJDang
Hello, how can I access a sample copy of the xlsx? Its unavailable from the link you've posted
my ETSY account stopped.
No other video that can explain multiple linear regression for logest and linest completely.
thanks.
Videos about FACTDOUBLE with Mathematical applications make more sense than those that read the help file only.
Thanks...only those who understand the applications of FACTDOUBLE can explain what is FACTDOUBLE. Otherwise, you just read the help file.
Check this out at Wikipedia: en.wikipedia.org/wiki/Incomplete_gamma_function#Regularized_gamma_functions_and_Poisson_random_variables
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.
Oh, I have been looking for something like this tutorial for YEARS. Thank you.
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.
This is one of the videos that uses FACTDOUBLE function in Mathematics. Most videos are made by geeks with no Math.
This is the formula of lower incomplete gamma function. No other RUclips video has explained it clearly.
Excellent explanation 😃
Thank you for noticing.
This is the only RUclips video that explains the IMSINH function compete with mathematics. All other videos don't explain the mathematics of IMSINH function.
There are videos about IMSINH...no mathematical explanation.
This the only RUclips video of LINEST function that completely explains the Excel LINEST function using the example found in Microsoft Office Support: support.microsoft.com/en-us/office/linest-function-84d7d0d9-6e50-4101-977a-fa7abf772b6d
Unlike other videos by engineers with no math that merely show the textbook screen shots, this video also shows the Math behind the Q function.
Thanks for noticing, Q function has many uses in engineering.
Pathetic RUclipsr Geeks without Math promote Microsoft Math Solver.
Misunderstanding FACTDOUBLE must be the reason why no RUclipsr has a video about Maclaurin series of Cosine and Sine using SERIESSUM function.
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.
All other videos about Gaussian Integral are made by Math guys without spreadsheet.
This is a complete solution for ASIN function other videos are simply parroting the help file.
Yes, you are right
This is the first video of LOGEST and LINEST functions completely explained.
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
This is the first video of gaussian Integral using spreadsheet functions.
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.
This is the only channel for Mathematicians with spreadsheet to get resources on mathematical applications using spreadsheet...no coding required.
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.
RUclips community bias is tampering the search results algorithm to show results from mathematicians without spreadsheet.
Search GAMMALN, this is the only video that shows content that fully explains GAMMALN, all others don't make sense.
You can't blame them RUclips community bias works in their favor with more views. Clowns have been dominating RUclips.
Nice explain
Thank you...it's a simple introduction.
A complete spreadsheet solution for ASIN ASINH...all others are made by monkeys.
When all other videos about SERIESSUM are made by help file monkeys, it's refreshing to see videos like this showing real mathematical application of SERIESSUM.
The content only proves all other videos of factdouble are made by monkees.
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.
This video shows the use of ERF and ERFC functions never explained in any other video.
Mathematicians without spreadsheet explained it very well.
I could have videos for higher level mathematics using google sheets and excel, only if my channel is monetized. However, it's discouraging to see videos about SERIESSUM with poor content getting more views. So, I'll just play around with the basics.
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.
These is the best explanation of SERIESSUM compared to the ones made by geeks with no math.
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).
This helps understand bonds and tbills.
Thank you for explaining the verbose additional statistics.
Glad it was helpful!
You can also use factorial (n+k)! instead of gamma(n+k+1).
Ideal spreadsheet solution for mathematics.
Thanks
Great solution...no coding required.
Thanks...FACTDOUBLE function can also be used.
The formula under the column Start week creates a circular dependency when a task is has another task as a predecessor. Could you explain how to avoid it ?
Try changing the spreadsheet settings: ruclips.net/video/bU0z_6gxI98/видео.html
The Part 4 is way better than Part 3....give it a try.
Hi Phil, is there a way I can download the sheet for my reference?
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.
This video should show how to use Google sheets to draw decaying or damped cosine vibration.
To view the private video that shows the complete solution, post your gmail address in this comment section. This offer is good until Jan-31, 2022
ruclips.net/video/wqWE6ktHFz4/видео.html