Electrical Engineering With Excel Nonlinear Curve Fitting With The LINEST Function
Nonlinear Curve Fitting With The LINEST Function Transcript and Lesson Notes
Welcome to Electrical Engineering With Excel. This video is about taking Excel’s LINEST function to the next level, returning regression data for nonlinear functions. This includes logarithmic, exponential, power, and po
Quick Summary
Welcome to Electrical Engineering With Excel. This video is about taking Excel’s LINEST function to the next level, returning regression data for nonlinear functions. This includes logarithmic, exponential, power, and po
Key Takeaways
- Review the core idea: Welcome to Electrical Engineering With Excel. This video is about taking Excel’s LINEST function to the next level, returning regression data for nonlinear functions. This includes logarithmic, exponential, power, and po
- Understand how LINEST Function fits into Nonlinear Curve Fitting With The LINEST Function.
- Understand how Nonlinear Curve Fitting With The LINEST Function fits into Nonlinear Curve Fitting With The LINEST Function.
Key Concepts
Full Transcript
Welcome to Electrical Engineering With Excel. This video is about taking Excel’s LINEST function to the next level, returning regression data for nonlinear functions. This includes logarithmic, exponential, power, and polynomial functions. 00:00 Intro 00:27 Digitizing Spec Plots Video 01:26 Old Style Regression 01:57 Linear Regression Using LINEST 03:06 Nonlinear Models 04:22 Polynomial Model 04:55 LM339B Output Sinking Voltage vs. Output Sinking Current Polynomial
Lesson FAQs
What is Nonlinear Curve Fitting With The LINEST Function about?
Welcome to Electrical Engineering With Excel. This video is about taking Excel’s LINEST function to the next level, returning regression data for nonlinear functions. This includes logarithmic, exponential, power, and po
What key concepts are covered in this lesson?
The lesson covers LINEST Function, Nonlinear Curve Fitting With The LINEST Function.
What should I learn before Nonlinear Curve Fitting With The LINEST Function?
Review the previous lessons in Electrical Engineering With Excel, then use the transcript and key concepts on this page to fill any gaps.
How can I practice after this lesson?
Practice by applying the main concepts: LINEST Function, Nonlinear Curve Fitting With The LINEST Function.
Does this lesson include a transcript?
Yes. The full transcript is visible on this page in indexable HTML sections.
Is this lesson free?
Yes. CourseHive lessons and courses are available to learn online for free.
Continue Learning
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
