How to Analyze the Regression Analysis Output from Excel

In a simple regression model, we are trying to determine if a variable Y is linearly dependent on variable X. That is, whenever X changes, Y also changes linearly. A linear relationship is a straight line relationship. In the form of an equation, this relationship can be expressed as

Y = α + βX + e

In this equation, Y is the dependent variable, and X is the independent variable. α is the intercept of the regression line, and β is the slope of the regression line. e is the random disturbance term.

The way to interpret the above equation is as follows:

Y = α + βX (ignoring the disturbance term “e”)

gives the average relationship between the values of Y and X.

For example, let Y be the cost of goods sold and X be the sales. If α = 2 and β = 0.75, and if the sales are 100, i.e., X = 100, the cost of goods sold would be, on average, 2 + 0.75(100) = 77. However, in any particular year when sales X = 100, the actual cost of goods sold can deviate randomly around 77. This deviation from the average is called the “disturbance” or the “error” and is represented by “e”.

Also, in the equation

Y = 2 + 0.75X + e

i.e.,

Cost of goods sold = 2 + 0.75 (sales) + e

the interpretation is that the cost of goods sold increase by 0.75 times the increase in sales. For example, if the sales increase by 20, the cost of goods sold increase, on average, by 0.75 (20) = 15. In general, we are much more interested in the value of the slope of the regression line, β, than in the value of the intercept, α.

Now, suppose we are trying to determine if there is a relationship between two variables which have apparently no relationship, say the sales of a firm, and the average height of employees of the firm. We would set up an equation like the following:

Y = α + βX + e

where

Y = sales of firm, X = average height of employees, α = intercept of the regression line, β = slope of the...

...
Unit 5 – RegressionAnalysis
Mikeja R. Cherry
American InterContinental University
Abstract
In this brief, I will demonstrate selected perceptions of the company Nordstrom, Inc., a retailer that specializes in fashion apparel with over 12 million dollars in sales last year. I will research, review, and analyze perceptions of the company, create graphs to show qualitative and quantitative analysis, and provide a summary of...

...you
cannot consult the regression R2 because
(a) ln(Y) may be negative for 0 < Y < 1.
(b) the TSS are not measured in the same units between the two models.
(c) the slope no longer indicates the effect of a unit change of X on Y in the log-linear
model.
(d) the regression R2 can be greater than one in the second model.
1
(v) The exponential function
(a) is the inverse of the natural logarithm function.
(b) does not play an important role in modeling nonlinear...

...Introduction
This presentation on RegressionAnalysis will relate to a simple regression model. Initially, the regression model and the regression equation will be explored. As well, there will be a brief look into estimated regression equation. This case study that will be used involves a large Chinese Food restaurant chain.
Business Case
In this instance, the restaurant chain's management wants to...

...RegressionAnalysis Exercises
1- A farmer wanted to find the relationship between the amount of fertilizer used and the yield of corn. He selected seven acres of his land on which he used different amounts of fertilizer to grow corn. The following table gives the amount (in pounds) of fertilizer used and the yield (in bushels) of corn for each of the seven acres.
|Fertilizer Used |Yield of Corn...

...flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks:
|Week |1 |2 |3 |4 |5 |6 |
|Demand |17 |19 |15 |21 |20 |23 |
Problem 7 [6]
A careful analysis of the cost of operating an automobile was conducted by a firm. The following model was developed:
Y = 4,000 + 0.20X
where Y is the annual cost and X is the miles driven.
a) If the car is...

...Park University
Multiple RegressionAnalysis
Pamela Lima
EC315 Quantitative Research Methods
Dr. Bell
11/22/2013
Multiple RegressionAnalysis
Miami Heat Average Attendance per season
Miami Heat History
The Miami Heat is a professional basketball team, based in Miami, Florida. The team is a member of the Southwest Division in the Eastern Conference of the National Basketball Association (NBA). The Miami...

...
Mortality Rates
RegressionAnalysis of Multiple Variables
Neil Bhatt
993569302
Sta 108 P. Burman
11 total pages
The question being posed in this experiment is to understand whether or not pollution has an impact on the mortality rate. Taking data from 60 cities (n=60) where the responsive variable Y = mortality rate per population of 100,000, whose variables include Education, Percent of the...

...REGRESSIONANALYSIS
Correlation only indicates the degree and direction of relationship between two variables. It does not, necessarily connote a cause-effect relationship. Even when there are grounds to believe the causal relationship exits, correlation does not tell us which variable is the cause and which, the effect. For example, the demand for a commodity and its price will generally be found to be correlated, but the question whether demand depends on...

1438 Words |
6 Pages

Share this Document

{"hostname":"studymode.com","essaysImgCdnUrl":"\/\/images-study.netdna-ssl.com\/pi\/","useDefaultThumbs":true,"defaultThumbImgs":["\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_1.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_2.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_3.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_5.png"],"thumb_default_size":"160x220","thumb_ac_size":"80x110","isPayOrJoin":false,"essayUpload":false,"site_id":1,"autoComplete":false,"isPremiumCountry":false,"userCountryCode":"US","logPixelPath":"\/\/www.smhpix.com\/pixel.gif","tracking_url":"\/\/www.smhpix.com\/pixel.gif","cookies":{"unlimitedBanner":"off"},"essay":{"essayId":33204316,"categoryName":null,"categoryParentId":null,"currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":4,"pageRange":"1-4","totalPages":4}},"access":"premium","title":"How to Analyze the Regression Analysis Output from Excel","additionalIds":[],"additional":[],"loadedPages":{"html":[],"text":[1,2,3,4]}},"user":null,"canonicalUrl":"http:\/\/www.studymode.com\/essays\/How-To-Analyze-The-Regression-Analysis-150162.html","pagesPerLoad":50,"userType":"member_guest","ct":10,"ndocs":"1,500,000","pdocs":"6,000","cc":"10_PERCENT_1MO_AND_6MO","signUpUrl":"https:\/\/www.studymode.com\/signup\/","joinUrl":"https:\/\/www.studymode.com\/join","payPlanUrl":"\/checkout\/pay","upgradeUrl":"\/checkout\/upgrade","freeTrialUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fcheckout%2Fpay%2Ffree-trial\u0026bypassPaymentPage=1","showModal":"get-access","showModalUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fjoin","joinFreeUrl":"\/essays\/?newuser=1","siteId":1,"facebook":{"clientId":"306058689489023","version":"v2.8","language":"en_US"},"analytics":{"googleId":"UA-32718321-1"}}