Excel Solver Demo: Fitting Data to Logistic Growth Model -- AIDS Deaths

preview_player
Показать описание
In this video we look at using Microsoft Excel's Solver Add-In to fit data (AIDS deaths 1982-1992) to a Logistic Growth Model. We plot the data along with the Logistic Growth Model. We start by adjusting the fitting parameters (the maximum value, the half-way position, and the growth rate) by hand. Then we calculate the sum of the square deviations and use Solver to minimize it by varying the fitting parameters.
  1. Thomas Blum
  2. Excel
  3. Microsoft
  4. Solver
  5. Add-In
  6. AIDS deaths
Рекомендации по теме
Excel Solver Demo: 0:11:54

Excel Solver Demo: Fitting Data to Logistic Growth Model -- AIDS Deaths

Excel Solver Demo: 0:11:48

Excel Solver Demo: Fitting Chemistry Peak Data to a Lorentzian Form

Excel Demo: Using 0:17:25

Excel Demo: Using Solver to Fit Data for a Charging Capacitor

Excel Demo: Fitting 0:14:12

Excel Demo: Fitting Data to a Logistic Growth Model

ASTM 1074-Fitting Compressive 0:07:37

ASTM 1074-Fitting Compressive Strength Data Using Microsoft Excel Solver Function

How To Use 0:12:25

How To Use The Solver Tool In Excel To Solve Systems of Linear Equations In Algebra

Modeling with Excel 0:06:22

Modeling with Excel Solver Foundation 3.0 - Demo

Non linear curve 0:05:52

Non linear curve fitting in EXCEL for multiple datasets

Microsoft Excel SOLVER 0:07:09

Microsoft Excel SOLVER - How to use SOLVER to optimize or simulate scenarios | Evolutionary Engine

Quick demo of 0:01:06

Quick demo of polynomial curve fit with Excel (Macintosh)

How to use 0:12:56

How to use Solver in Excel

Using Excel Solver 0:12:14

Using Excel Solver to Solve a Given Mathematical Model

Enabling Solver and 0:01:02

Enabling Solver and Data Analysis Add-Ins in Excel 2007

Introduction to Designing 0:11:08

Introduction to Designing Optimization Models Using Excel Solver

EXCEL PRO TIP: 0:12:23

EXCEL PRO TIP: Advanced Optimization with Solver

Use the Excel 0:06:58

Use the Excel Solver Tool

Excel Line Of 0:14:56

Excel Line Of Best Fit, Trend Lines, Solver

IQ TEST 0:00:29

IQ TEST

Graphing data in 0:01:50

Graphing data in Excel and finding a linear fitting equation.

Microsoft Excel Solver 0:08:07

Microsoft Excel Solver for Engineering Optimization

Excel 9: Using 0:04:19

Excel 9: Using Solver

Generating Standard Curve 0:06:53

Generating Standard Curve and Determining Concentration of Unknown Sample in Excel

Excel Solver Basics 0:19:37

Excel Solver Basics Tutorial - Dr Kenneth Chelst- Wayne State University

Fitting a model 0:07:26

Fitting a model to data with Excel

Комментарии
Автор

What an incredibly nuanced, informative and specific video. Thank you so much for your time and effort. I am genuinely so relieved to having found a solution to my problem. You made my day, and I hope you continue your time on YouTube!

AtreyaKoirala
Автор

Thank you - I was wondering if this could be done in Excel. Your video is exactly what I was looking for - very clearly presented and understandable too. I first watched and added the solver to my excel, and then went back to the start of the video and followed through, to fit my own data (chick/en growth!). It worked! Much appreciated.

GlynisDance
Автор

Can you compare fits (other than visually), for significant differences?

GlynisDance
welcome to shbcf.ru