Double Exponential Decay Data Fitting Using Microsoft Excel

Ayan Sarkar
Ayan Sarkar
14.5 هزار بار بازدید - 5 سال پیش - In this tutorial video, I
In this tutorial video, I have shown the process of an experimental data/curve fitting with a double exponential decay function using Microsoft Excel. The exponential decay function used here is:

y(t) = Aexp(-mt)+Bexp(-nt)
Here, the total sum of squares (SST), residual sum of squares (RSS), R-square, and adjusted R-square have been found. The regression analysis has been done by minimizing residual sum square using an Excel solver and for the solving process with some additional constraints.  The use of the $ command in Excel has also been depicted in this video. I Hope, this data analysis video tutorial will be useful to experimental physicists, chemists, engineers, biologists, economists, and many others. Please subscribe to this channel.

Related Books:
Experimental Electrochemistry: A Laboratory Textbook by Rudolf Holze
Link: https://amzn.to/3wTjWtq
Solid State Electronic Devices by B. Streetman and S. Banerjee
Link: https://amzn.to/3cmDtJg
Electrochemical Impedance Spectroscopy (The ECS Series of Texts and Monographs) by Mark E. Orazem  and Bernard Tribollet
Link: https://amzn.to/30pf8jn
Impedance Spectroscopy: Applications to Electrochemical and Dielectric Phenomena Hardcover –
by Vadim F. Lvovich
Link: https://amzn.to/3nmRi0I
Electrochemical Impedance Spectroscopy and its Applications Paperback by Andrzej Lasia
Link: https://amzn.to/3nm3U8g

Hey! I am now making videos using the Samsung Galaxy S6 tab. It's highly recommended to use. If you are a grad student you can have this pocket-friendly one. You can use a cool keyboard alongside, which will facilitate ease of working.
Link of this tab in amazon.in: https://amzn.to/3Fr00B5
Keyboard for Galaxy S6: https://amzn.to/3Hxmx0Y
Pocket-friendly iPad: https://amzn.to/3Ficawa


Here's the amazon link to my new Dell Inspiron 3501 laptop: https://amzn.to/3FilqjU
Facebook Page: Facebook: AyanSarkarYoutube
5 سال پیش در تاریخ 1398/10/18 منتشر شده است.
14,595 بـار بازدید شده
... بیشتر