Multiple Regression in Excel

preview_player
Показать описание
Explains how to use multiple regression in Excel 2010. Made by faculty at the University of Colorado Boulder Department of Chemical and Biological Engineering.
Check out our Kinetics Review playlist here:
  1. LearnChemE
  2. chemical
  3. engineering
  4. screencasts
  5. computing
  6. calculations
Рекомендации по теме
Excel Multiple Regression 0:06:33

Excel Multiple Regression

Multiple Regression in 0:11:02

Multiple Regression in Excel

How to Run 0:01:20

How to Run a MULTIPLE REGRESSION Analysis in Excel (Quick Tutorial)

Regression: Multiple Linear 0:21:10

Regression: Multiple Linear Regression Basics in Excel

Conducting a Multiple 0:10:15

Conducting a Multiple Regression using Microsoft Excel Data Analysis Tools

Multiple Linear Regression 0:09:14

Multiple Linear Regression using Excel Data Analysis Toolpak

Discussion 6: Using 0:13:55

Discussion 6: Using Multiple Regression in Excel for Predictive Analysis

How to do 0:07:15

How to do Multiple Regression in Excel 2016 for Windows (Job Performance Example)

18. Aula 18 0:25:12

18. Aula 18 - Regressão com o R (parte 1 de 2)

Multiple Regression in 0:05:05

Multiple Regression in Excel - P-Value; R-Square; Beta Weight; ANOVA table (Part 1 of 3)

Multiple Regression using 0:04:30

Multiple Regression using Excel on a Mac

Multiple Regression in 0:05:34

Multiple Regression in Excel

Multiple Linear Regression 0:10:29

Multiple Linear Regression Excel | Fit Several Independent Variables

Multiple Regression Explained 0:18:49

Multiple Regression Explained with Excel

Learn Regression Analysis 0:12:34

Learn Regression Analysis in Excel in Just 12 Minutes

Multiple Regression Analysis 0:02:48

Multiple Regression Analysis

How to do 0:17:29

How to do Multiple Regression Analysis Excel

Building good multiple 0:14:00

Building good multiple regression models in Excel

Regression in Excel 0:28:10

Regression in Excel (Simple and Multiple Regression in Excel)

statsprof - multiple 0:29:14

statsprof - multiple linear regression in excel

Multiple Regression with 0:07:41

Multiple Regression with Excel's LINEST

Multivariate Linear Regression 0:04:58

Multivariate Linear Regression VS. Multiple Linear Regression - Excel Add-ins

Multiple Regression and 0:06:53

Multiple Regression and Correlation Analysis in Excel | Bio Statistics | Statistics Bio7

Multiple Regression in 0:05:28

Multiple Regression in Excel - P-Value; R-Square; Beta Weight; ANOVA table (Part 2 of 3)

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

A better way to solve this problem is by nonlinear regression on the original form of the equation; this can be set up using guessed initial coefficient values, computing the sum of squared residuals or SSR (residual = model-data values; on the spreadsheet, sum the squares of all residuals to get the SSR), then use Solver to minimize the SSR by changing the coefficient values. Those are the true best fit values for the original equation. Try both methods and graph them to convince yourself.

skdentel
Автор

The multiple regression demonstration is fine, but the conversion of a power equation to a linearized equation is a poor way to determine best fit coefficients. The regression's best fit values may be optimal for the logarithmic form of the equation, but they are NOT likely to be the best fits for the original form of the equation.

skdentel