MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

Related questions

Question

Can someone explain to me how this person set up the his multiple linear regression equation in excel when he ran a regression? I assume his X range would be the monthly average air temperature  (X1 - jan X2-feb X3-march) but what about his input range for y?

Firstly, I picked up three variables (\(X_1\): average temperature in January, \(X_2\): average temperature in February, and \(X_3\): average temperature in March) and set dependent variable \(Y\) as number of days after end of February. So, if the blooming day is 03/25, \(Y\) equals to 25; and if the day is 04/08, \(Y\) becomes 31+8=39.

I arranged monthly average air temperature data in 1961–2004, ran MS-Excel regression data analysis function and gets the multiple linear regression equation as follows:

\[ 
Y = 0.886X_1 - 1.910X_2 - 3.213X_3 + 63.069 \quad (R^2 = 0.81) 
\]
expand button
Transcribed Image Text:Firstly, I picked up three variables (\(X_1\): average temperature in January, \(X_2\): average temperature in February, and \(X_3\): average temperature in March) and set dependent variable \(Y\) as number of days after end of February. So, if the blooming day is 03/25, \(Y\) equals to 25; and if the day is 04/08, \(Y\) becomes 31+8=39. I arranged monthly average air temperature data in 1961–2004, ran MS-Excel regression data analysis function and gets the multiple linear regression equation as follows: \[ Y = 0.886X_1 - 1.910X_2 - 3.213X_3 + 63.069 \quad (R^2 = 0.81) \]
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman