
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
expand_more
expand_more
format_list_bulleted
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
![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)
\]](https://content.bartleby.com/qna-images/question/3280c582-e5cc-45be-a05b-b61a47a3d565/7884c481-2b24-4a3e-9508-212583a1f258/aijgbib_thumbnail.png)
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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps

Knowledge Booster
Similar questions
- Different hotels in a certain area are randomly selected, and their ratings and prices were obtained online. Using technology, with x representing the ratings and y representing price, we find that the regression equation has a slope of 135 and a y-intercept if -356. What is the equation of the regression line?arrow_forwardAriel was running analyses over and over in census data and came across a correlation between weight and debt (r=.78). Independent variable is weight and dependent variable is debt. b) Curious Ariel noted some statistics on these weight (M=160lb, SD=15lb) and debt (M=196k, SD=20k). If Ariel wanted to calculate a regression equation, what would her slope and intercept be?arrow_forwardHow should I draw this linear regression graph for this model? Thanks.arrow_forward
- This was not the correct quadratic model for the dataarrow_forwardYou have gathered data from a random sample of fast-food sandwiches in order to better understand how the amount of fat in these sandwiches relates to the amount of carbohydrates in the sandwiches. Your ultimate goal is to construct a regression equation to predict amount of carbohydrates based on amount of fat. If this is your goal, which variable should you put on the vertical axis (or y-axis) of a scatterplot of this data? O When conducting a regression analysis, it makes no difference which variable is on which axis. O Amount of fat, because it is the explanatory variable. O Amount of carbohydrates, because it is the explanatory variable. Amount of carbohydrates, because it is the response variable. O Amount of fat, because it is the response variable.arrow_forwardJane collects data from 40 elementary school students and finds that the relationship between age (x) and score on a certain test (y) is given by y=3.2x+45. What can she extrapolate about the score a 16-year old will get on the test?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman

MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc

Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning

Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning

Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON

The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman