# Regression Analysis

In: Other Topics

Submitted By kbc2009
Words 365
Pages 2
Regression analysis is a statistical process for estimating the relationships among variables. It includes many techniques for modeling and analyzing several variables, when the focus is on the relationship between a dependent variable and one or more independent variables. More specifically, regression analysis helps one understand how the typical value of the dependent variable (or 'criterion variable') changes when any one of the independent variables is varied, while the other independent variables are held fixed.
Local Government Engineering Department (LGED) is a public sector organization under the ministry of Local Government, Rural Development & Cooperatives. The prime mandate of LGED is to plan, develop and maintain local level rural, urban and small scale water resources infrastructure throughout the country.
Here, I considered LGED as the organization and considering a projects eight districts “available fund” as Independent variable and “development (length of development of road in km)” as dependent variable.

The value of the variables are-
Districts Fund, X (lakh tk) Development,Y (km)
Panchagar 450 10
Thakurgaon 310 6.8
Dinajpur 1500 32
Nilphamari 1160 24.5
Rangpur 1450 31
Kurigram 450 9
Lalmonirhat 950 16
Gaibandha 1550 33

For the two variables “available fund” and “development”, the regression equation can be given as:
Y= a + bX
Where, Y = Development X = Fund b = rate of change of development a = intercept of development

Now by using excel, the summary output is-
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.990550883
R Square 0.981191053
Standard Error 1.646537702
Observations 8

Y=a+bX Coefficients Standard Error t Stat
Intercept of development -0.590295137 1.315862427 -0.448599432
Fund 0.021358358 0.001207251 17.69172457

The...

### Similar Documents

#### Regression Analysis

Words: 578 - Pages: 3

#### Regression Analysis

...Case Study: Locating New Pam and Susan‘s Stores Professor Demetra Paparounas Lisa Chan MGSC 6200- Information Analysis July 3, 2014 Introduction The purpose of this study to is to determine a new store location for Pam and Susan Stores. This discount department store chain has 250 stores that are primarily in the South. Expansion is important to their strategic success. A multiple regression model will be used to determine which location has the highest sales potential and projections. It will also be used to help see how strong of a relationship sales has to the other independent variables. Data For this model, the wealth of census data that was used to compute this model contained 250 observations, 33 variables and 7 additional dummy variables were created from the main comtype variable, taking values of zero or one depending on level of competitiveness for a particular store. This data set contained economic and demographical data, population type, sales numbers, store size and the competitive types. The amount of sales and selling square feet variables are given in thousands of dollars. Results and Discussions In analyzing the data on the 250 Pam and Susan’s stores, we first created a scatter plot of the competitive types in the horizontal axis against sales (in thousands) on the vertical axis. The competitive types were identified as follows: * Type 1- Densely populated area with relatively little direct competition. * Type 2 –High income areas with little......

Words: 1892 - Pages: 8

#### Regression Analysis

...Ben Leigh American Intercontinental University Unit 5 Individual Project BUSN311-1301B-10: Quantitative Methods and Analysis Instructor Leonidas Murembya April 23, 2013, Abstract This paper will be discussing regression analysis using AIU’s survey responses from the AIU data set in order to complete a regression analysis for benefits & intrinsic, benefits & extrinsic and benefit and overall job satisfaction. Plus giving an overview of these regressions along with what it would mean to a manager (AIU Online).   Introduction Regression analysis can help us predict how the needs of a company are changing and where the greatest need will be. That allows companies to hire employees they need before they are needed so they are not caught in a lurch. Our regression analysis looks at comparing two factors only, an independent variable and dependent variable (Murembya, 2013). Benefits and Intrinsic Job Satisfaction Regression output from Excel SUMMARY OUTPUT Regression Statistics Multiple R 0.018314784 R Square 0.000335431 The portion of the relations explained Adjusted R Square -0.009865228 by the line 0.00033% of relation is Standard Error 1.197079687 Linear. Observations 100 ANOVA df SS MS F Significance F Regression 1 0.04712176 0.047122 0.032883 0.856477174 Residual 98 140.4339782 1.433 Total 99 140.4811 Coefficients Standard Error t......

Words: 830 - Pages: 4

#### Regression Analysis

...Introduction Regression analysis was developed by Francis Galton in 1886 to determine the weight of mother/daughter sweet peas. Regression analysis is a parametric test used for the inference from a sample to a population. The goal of regression analysis is to investigate how effective one or more variables are in predicting the value of a dependent variable. In the following we conduct three simple regression analyses. Benefits and Intrinsic Job Satisfaction Regression output from Excel SUMMARY OUTPUT Regression Statistics Multiple R 0.616038 R Square 0.379503 Adjusted R Square 0.371338 Standard Error 0.773609 Observations 78 ANOVA df SS MS F Significance F Regression 1 27.81836 27.81836 46.48237 1.93E-09 Residual 76 45.48382 0.598471 Total 77 73.30218 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 2.897327 0.310671 9.326021 3.18E-14 2.278571 3.516082 2.278571 3.516082 X Variable 1 0.42507 0.062347 6.817798 1.93E-09 0.300895 0.549245 0.300895 0.549245 Graph Benefits and Extrinsic Job Satisfaction Regression output from Excel SUMMARY OUTPUT Regression Statistics Multiple R 0.516369 R Square 0.266637 Adjusted R Square 0.256987 Standard Error 0.35314 Observations 78 ANOVA ...

Words: 684 - Pages: 3

#### Regression Analysis

...A Term Paper On BUSINESS STATISTICS 1 Submitted To Dr. Md. Abul Kalam Azad Associate Professor Department of Marketing University of Dhaka Submitted By Group Name: “ORACLES” Section: B Department of Marketing (17th Batch) University of Dhaka Date of Submission: 12- 04-2012 Group profile “ORACLES” | Roll No. |NAME | |42 | Imran Hosen | | | | |74 |Zerin Momtaz Chowdhury | | | | |106 |Toufiqul Islam | | | ...

Words: 1445 - Pages: 6

#### Voting Tendencies: a Regression Analysis

...Introduction Every four years, the United States presidential election becomes one of the country’s biggest news stories for a large chunk of that year. During this time there are a great many words both spoken and written about how people are going to vote and what factors supposedly lead them to vote a certain way. It seems that much of the time the analysis of these issues is of a qualitative nature, and with that in mind this paper will attempt to approach the problem from a statistical point of view. That is not to say there is a lack of quantitative research on how specific demographics tend to vote; indeed, some of the good data and information out there will be used to inform this paper’s hypotheses and econometric model. This study will focus on the 2012 U.S. presidential election Barack Obama and Mitt Romney (there were several other candidates on the ballot, but none received a significant portion of the votes). Pundits threw around seemingly countless factors in an attempt to analyze and predict how people would vote in this election; this paper will focus on a select group of those factors, in hopes of drawing some firm and well-grounded conclusions as to whether they actually played a statistically significant role. Countywide data will be utilized. The recent widespread availability of election results on a county-by-county level, combined with countywide information from the U.S. Census Bureau, allows for a very large number of observations (at least......

Words: 3259 - Pages: 14

Free Essay

#### Unit 5 - Regression Analysis

...Abstract This paper describes the application of regression analysis for the workplace. Three sets of variables are investigated - benefits and intrinsic job satisfaction, benefits and extrinsic job satisfaction, and finally benefits and overall job satisfaction. The regression analysis is performed using Excel and the results are shown in this paper, along with a graph for each set. The results are analyzed for recommendation to the company.   Introduction Regression analysis is performed on three sets of variables – benefits and intrinsic job satisfaction, benefits and extrinsic job satisfaction, and finally benefits and overall job satisfaction. The results of the regression analysis are used to determine whether any relationship exists for the three sets of variables and the strength of the relationship. Benefits and Intrinsic Job Satisfaction Regression output from Excel Regression Statistics Multiple R 0.069642247 R Square 0.004850043 Adjusted R Square -0.004718707 Standard Error 0.893876875 Observations 106 ANOVA df SS MS F Significance F Regression 1 0.404991362 0.404991 0.506863 0.478094147 Residual 104 83.09765015 0.799016 Total 105 83.50264151 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 5.506191723 0.363736853 15.13784 4.79E-28 4.784887914 6.227496 4.784888 6.227496 Benefits -0.057165607 0.080295211 -0.71194 0.478094 -0.216394019 0.102063 -0.21639 0.102063 Graph ......

Words: 770 - Pages: 4

#### Pam & Sue Regression Analysis

...Multiple Regression Project: Forecasting Sales for Proposed New Sites of Pam and Susan’s Stores I. Introduction Pam and Susan’s is a discount department store that currently has 250 stores, most of which are located throughout the southern United States. As the company has grown, it has become increasingly more important to identify profitable locations. Using census and existing store data, a multiple regression equation will be used to forecast potential sales, and therefore which proposed new site location will be more profitable. II. Data The data set has 37 independent variables. This includes 7 categorical variables for competitive type and 30 numerical categories. There are 250 stores, meaning the sample size is 250. As the sales are given in \$1,000’s of dollars it is best to remember that a unit change in x will correspond to that coefficient of x multiplied by 1,000. III. Results and Discussion Building a multiple regression model requires a step-by-step approach. Failure to follow such methodology could ultimately lead to incorrect and inaccurate forecasting for the dependent variable of interest. Below I will outline the process and findings used to obtain a multiple regression equation to forecast potential sales at newly proposed site of Pam and Susan’s discount department stores. The initial step in building a multiple regression model is to look for outliers and non-linear relationships between your dependent (predicated sales) and......

Words: 1847 - Pages: 8

#### Mid City Regression Analysis

Words: 449 - Pages: 2

#### Regression Analysis

...Acts 430 Regression Analysis In this project, we are required to forecast number of houses sold in the United States by creating a regression analysis using the SAS program. We initially find out the dependent variable which known as HSN1F. 30-yr conventional Mortgage rate, real import of good and money stock, these three different kinds of data we considered as independent variables, which can be seen as the factors will impact the market of house sold in USA. Intuitively, we thought 30-yr conventional mortgage rate is a significant factor that will influences our behavior in house sold market, which has a negative relation with number of house sold. When mortgage rate increases, which means people are paying relatively more to buy a house, which will leads to a decrease tendency in house sold market. By contrast, a lower interest rate would impulse the market. We believe that real import good and service is another factor that will causes up and down in house sold market. When a large amount of goods and services imported by a country, that means we give out a lot of money to other country. In other words, people have less money, the sales of houses decreased. Otherwise, less import of goods and services indicates an increase tendency in house sold market. We can see it also has a negative relationship with the number of house sold. Lastly, we have money stock as our third impact factor of house sold. We considered it has a positive relationship with the number of...

Words: 723 - Pages: 3

#### Multiple Regression Analysis of Rb in Bangladesh

... A Report on “Multiple Regression Analysis of Determinants of Dividend Payout Ratio of Reckitt Benckiser” Acknowledgement It is a great honor for us to submit this report to our respected teacher. At first we want to convey our thanks and gratitude to her for assigning us to prepare report entitled, “Reckitt Benckiser”. It would not have been possible for us to complete the report, but for his help. All of the efforts ended at a desired point for the cooperation and hard work, Sincerity and seriousness of our group members. So, all of them as well as our group members are worth of pure compliment. Letter of Transmittal February 14, 2015 Dear Sir, Subject: Submitting the report on “Determinants of dividend payout ratio of Reckitt Benckiser”. We are submitting a well-structured and comprehensive report on Reckitt Benckiser”. Despite many constraints like scope and access to information, we have tried to create something satisfactory. We have tried to follow your guideline in every aspects of preparing this report. We have concentrated on the most relevant and logical areas to make our report coherent as well as practical. We hope this report will entice your kind appreciation. Sincerely, ________________ Executive Summery Reckitt Benckiser is a global leader in household, health and personal care sectors and one of the fast growing multinationals. In our report we mainly deal with Multiple regression analysis of determinants of......

Words: 3639 - Pages: 15

#### Regression Analysis

...ANALYSIS OF REGRESSION Jessica Cain American InterContinental University Abstract The world today uses statistics in many different ways to understand numbers and possible outcomes. One way that this is by using regression analysis. The regression analysis which is based on a correlation between two variables can help us to better understand the relationship between the two variables. The process which is a valuable one has helped researchers, and businesses to grow based on information obtained from a regression analysis that contains a linear regression. Introduction The purpose of a regression analysis is to help show a linear regression of certain variables. This helps to understand the correlation of the variables being tested. Correlation does give reason to suspect that the relationship between two variables is not die to chance or other hidden variables (Editorial Board, [EB], 2012). This is done by utilizing excel to show how the variables match up, and if one is causing the other or if there are outliers that are affecting the outcome. This is important as it will allow for a company to see and eliminate these unnecessary variables and continue their growth. Benefits and Intrinsic Job Satisfaction Regression output from Excel |SUMMARY OUTPUT | | | | | |Intrinsic |-0.08484 |4.844477 ......

Words: 589 - Pages: 3

#### Significance and Advantages of Regression Analysis

...Significance of Regression Analysis In statistics, regression analysis includes many techniques for modeling and analyzing several variables, when the focus is on the relationship between a dependent variable and one or more independent variables. More specifically, regression analysis helps one understand how the typical value of the dependent variable changes when any one of the independent variables is varied, while the other independent variables are held fixed. Most commonly, regression analysis estimates the conditional expectation of the dependent variable given the independent variables — that is, the average value of the dependent variable when the independent variables are held fixed. Less commonly, the focus is on a quantile, or other location parameter of the conditional distribution of the dependent variable given the independent variables. In all cases, the estimation target is a function of the independent variables called the regression function. In regression analysis, it is also of interest to characterize the variation of the dependent variable around the regression function, which can be described by a probability distribution. Regression analysis is widely used for prediction and forecasting, where its use has substantial overlap with the field of machine learning. Regression analysis is also used to understand which among the independent variables are related to the dependent variable, and to explore the forms of these relationships. In restricted......

Words: 784 - Pages: 4

#### Unit 5 Regression Analysis

...Unit 5 Regression Analysis American Intercontinental University Regression Analysis Independent Variable: Benefits Dependent Variable: Intrinsic Regression Statistics |   | Multiple R | 0.252916544 | R Square | 0.063966778 | Adjusted R Square | 0.045966139 | Standard Error | 0.390066747 | Observations | 54 | ANOVA |   |   |   |   |   |   | df | SS | MS | F | Significance F | Regression | 1 | 0.540685116 | 0.540685116 | 3.553583771 | 0.065010363 | Residual | 52 | 7.911907477 | 0.152152067 |   |   | Total | 53 | 8.452592593 |   |   |   |   | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | Intercept | 4.88865703 | 0.188506099 | 25.93368096 | 2.04938E-31 | 4.510391881 | 5.266922187 | 4.510391881 | 5.266922187 | 1.4 | 0.06958624 | 0.036913916 | 1.885095162 | 0.065010363 | -0.004486945 | 0.143659433 | -0.004486945 | 0.143659433 | Independent Variable: Benefits Dependent Variable: Extrinsic Regression Statistics |   | Multiple R | 0.332749251 | R Square | 0.110722064 | Adjusted R Square | 0.093620565 | Standard Error | 0.405766266 | Observations | 54 | ANOVA |   |   |   |   |   |   | df | SS | MS | F | Significance F | Regression | 1 | 1.065986925 | 1.065987 | 6.474407048 | 0.013952455 | Residual | 52 | 8.561605668 | 0.164646 |   |   | Total | 53 | 9.627592593 |   |   |   |   | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower......

Words: 463 - Pages: 2