Premium Essay

Regression Analysis for Determining the Price of Alcan Stock

In: Business and Management

Submitted By redronin
Words 12428
Pages 50
Regression Analysis for Determining the Price of Alcan Stock

[pic]

Jason Scott

May 1, 2006

Introduction

In this project, we have developed a model using stepwise regression to predict the price of Alcan’s stock, based on the impact of eight independent variables on the price of Alcan’s stock. The company’s stock is listed on the New York Stock Exchange (NYSE) under the ticker symbol AL. Of the eight variables we will be looking at, we are most interested in the impact that the price of aluminum has on Alcan’s stock. Alcan is the second largest producer of aluminum in the world, and may be one of the purest plays on aluminum, given that Alcan spent the mid 1990’s spinning off all operations not involved with the production of aluminum. If any company would reflect the impact of the change in aluminum prices, it would be Alcan. Additionally, we have a keen interest in this field as both of us are employees of a company recently spun-off from Alcan. The eight independent variables that we chose for our analysis, and our reasons for choosing them, are detailed below.

Definition of Variables

Dependant Variable

Alcan (ALCAN) The dependent variable for our model is the monthly stock price of Alcan. Alcan is publicly traded on the New York Stock Exchange (NYSE) under the ticker symbol AL. The stock price is collected daily and these daily numbers are averaged together to give one monthly value. We have collected the monthly averages for the 60 month period of January 2001-December 2005. The stock prices were gathered from the internet site http://finance.yahoo.com.

Independent Variables

The eight independent variables that we selected for our model are listed below. The data on each of these independent variables were collected for the same time period and the same dates as that for the dependent variable…...

Similar Documents

Premium Essay

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

Premium Essay

Impact of Dividend on Stock Price

...“IMPACT OF DIVIDEND ON STOCK PRICES” ABSTRACT The project aims to establish the impact of dividend on market price of a share. This has been done for individual companies in Steel sector. After studying the basic concepts of dividends and dividend policy I am able to get a proper perspective of the requirements of the project and also gain a better understanding of the results obtained. I have looked to find the relation between pre dividend price change and the dividend using regression analysis. Similarly, I have analyzed the relation between the post dividend price change and the dividend. It is a matter of fact that dividends are declared by a company primarily to generate capital and also at certain times to maintain the market sentiment. It is in the best interests of the company to maximize the market value of its share and companies use dividend as a tool to maintain their corporate image. However, the degree of correlation between the dividend and the market price is low which implies that several other internal and external factors affect the market value of shares. To gain a holistic picture, I also did a comparative study of two peers in a sector (steel)to better understand how the specific requirements of each sector also impact the dividend policy of a company. The conclusions derived from the analysis performed further consolidated theoretical knowledge and deviations were better understood. SYNOPSIS “Impact......

Words: 8285 - Pages: 34

Premium Essay

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

Free Essay

Regression Analysis

...Performance”, Lisbon, October 1998. *Corresponding author: IZA, P.O. Box 7240, 53072 Bonn, Germany; winkelmann@iza.org. “I know only of three ways of living in society: one must be a beggar, a thief, or a wage earner.” HONORÉ de MIRABEAU (1749-1791) 1. Introduction It is a common observation for many countries that unemployment rates and crime rates are positively associated. A more contentious issue is whether this association means that unemployment causes crime, crime causes unemployment or third factors cause both. Only the first of the three possibilities would imply that the effects of unemployment on crime deserve to be counted among the “non-pecuniary” costs of unemployment that should be taken into account in a cost-benefit analysis of potential unemployment-reducing policies. The theoretical underpinning of the causality notion was developed some thirty years ago by Becker (1968), Stigler (1970) and Ehrlich (1973), among others. In Ehrlich’s model, individuals divide their time between legal activities and risky illegal activities. If legal income opportunities become scarce relative to potential gains from crime, the model predicts that crime will become more frequent. Increased unemployment could be one such factor. Numerous subsequent empirical papers have attempted to test the predictions of the BeckerEhrlich model and to find out whether the magnitude of the unemployment effect is quantitatively important. The hallmark of this literature is its failure......

Words: 6399 - Pages: 26

Premium Essay

Stock Price Analysis

...Stock Price Analysis For each organization, it is very important to consider and review the stock price analysis. Here, the stock price analysis of the organizations Amazon and Ebay shall be carried out. In relation to the stock price analysis, the analysis of the stock prices shall be reviewed from January 1, 2010, 2011 and 2012 and in addition to this, the stock price analysis for the organization shall also be considered regarding the stock price of the organization since the date of its incorporation. The graph showing the changes in the stock prices of the organizations is provided below (Yahoo Finance, 2014). The chart given above shows the changes in the stock prices for Ebayfrom January 1,2010, January 1,2011 and January 1,2012. These charts show the information that, the organization has been in a position to enhance its stock prices since the date of incorportation. So although the stock price has increased since being incorporated, it hasn’t been a substantial increase amount. Based on this chart, it can be said that, the stock price of the Ebay has definitely grown since the date of its incorporation till the present date, but the growth has been small yet. Though, the increase has not been a significant change, the organization has made sure that, it carries out its activities in the most appropriate manner without any kind of problem or issue for it. In relation to the Amazon, the stock prices shall be analyzed as well.. At the time of incorporation......

Words: 419 - Pages: 2

Premium Essay

Predictability of Stock Price on Nigeria Stock Exchange

...predictability CHAPTER ONE INTRODUCTION 1.1 BACKGROUND TO THE STUDY The performance of an economy is dependent largely on the efficient performance of its financial markets, since they facilitate the financing of productive activity and hence national output and economic growth. In this research report, the key roles and function of the financial markets are highlighted with the thrust of the discussion on the core issue of how the market works; directly and indirectly. One of the most important factors for rapid economic development is the effective mobilization and allocation of scarce resources within an economy. These resources can be real or financial, but they are scarce and command a price. The establishment of effective and efficient channel for the mobilization and allocation of scarce financial resources is therefore essential. The financial market, comprising of the money and capital markets, occupies an important place in most economies of the world. The primary function of a financial market is to enable funds to be sufficiently allocated from the surplus units of the economy to the deficit units for productive investment. The greater the transmission efficiency is, the higher the rate of growth of the economy (Olowe, 1997). The money market trades only in securities or debt instruments maturing in less than twelve months, while in the capital market, longer term debts as well as equity instruments are traded. The complementarity between money......

Words: 11803 - Pages: 48

Premium Essay

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

Premium Essay

Relationship Between Stock Price and Futures

...The relationship between stock prices and exchange rates in China Mengyuan Chen Illinois Wesleyan University Dec 10, 2012 Abstract This paper uses the data of RMB exchange rates and stock market prices in China from 1994 to 2011 to estimate the relationship between stock prices and exchange rates. There are two major theories concerning the relationship. According to the portfolio balance effect, these two variables should be negatively related; in addition, according to the international trading effect theory, these two variables should be positively related. The linear regression model is adopted to observe the various relationships between stock and foreign exchange markets. The results confirmed my hypothesis, which indicates that the international trading effect is more dominant, thus the net effect is a positive causal relationship from exchange rates to stock prices. I. Introduction Within the emerging Chinese market, China now has more open policies and advanced financial market instruments to promote globalization. For example, China started to allow the RMB to float within a larger daily range in 2005 and brought derivative options into the stock market. These significant steps all suggest that China is beginning to face a new economic condition. For instance, the challenging policy making of RMB exchange rate is one. Exchange rates and stock prices are both key indicators of the economy and financial markets. So the relationship between those two becomes......

Words: 2999 - Pages: 12

Premium Essay

Regression Analysis

...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...

Words: 365 - Pages: 2

Premium Essay

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

Premium Essay

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

Premium Essay

Predicting Stock Market Using Regression Techniques-

...Research Journal of Finance and Accounting www.iiste.org ISSN 2222-1697 (Paper) ISSN 2222-2847 (Online) Vol.6, No.3, 2015 27 Predicting Stock Market using Regression Technique Prof. Mitesh A. Shah1* Dr.C.D.Bhavsar2 1.Department of Statistics, S.V. Vanijya Mahavidyalaya, Ahmedabad, Gujarat, India 2.Department of Statistics, Gujarat University, Ahmedabad, Gujarat, India Email of the corresponding Author: m_a_shah73@yahoo.com Abstract We use two and half year data set of 50 companies of Nifty along with Nifty from 1st Jan 2009 to 28th June 2011 and apply multivariate technique for data reduction, namely Factor Analysis. Using Factor analysis we reduce these 50 companies’ data (50 variables) into the most significant 4 FACTORS. These four significant factors are then used to predict the Nifty using Multiple linear regression. We observed that the model is good fitted and it explained 90 % of the total variance. Keywords: Nifty, Factor Analysis, Multiple Linear Regression, Data reduction 1. Introduction: In this paper, we applying data reduction technique of Factor analysis on the Nifty Stocksand then predict NIFTY using Multiple Linear Regression Technique. Factor analysis is a statistical technique to study interrelationship among the Variables. The idea behind factor analysis is grouping the variables by their correlation in such a way that particular group is highly correlated among themselves but relatively smaller correlation with the variables in other......

Words: 3557 - Pages: 15

Premium Essay

Impact of Dividend Policy on Stock Price

...July 2006 Under the Guidance of Supervisor: Dr Kanwal Anil Co-Supervisor: Dr Naseem Abidi Jaypee Institute of Information Technology, Noida A-10, SECTOR 62, NOIDA, INDIA (12) December, 2009 Sujata Kapoor, JBS, JIIT,Dec’ 2009 TABLE OF CONTENTS S. no. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. Contents Introduction Review of the literature Research objectives Research Methodology Lintner Model: Analysis and findings Factor Analysis and Regression results on Extracted Factors Quadratic Polynomial Regression Analysis & Findings Event study: Analysis & Findings Conclusion Chapter plan Selected References Annexure Page no. 4-9 9-14 14-15 15-23 23-24 24-28 28-30 30-32 32-35 35-36 36-38 (III-XX) 2 Sujata Kapoor, JBS, JIIT,Dec’ 2009 KEY TERMS DIVIDEND PAYOUT RATIO: The percentage of earnings paid to shareholders in dividends. Calculated as: DIVIDEND POLICY: The policy a company uses to decide how much it will pay out to shareholders in dividends. SHAREHOLDERS’ VALUE: The value delivered to shareholders because of management's ability to grow earnings, dividends and share price. In other words, shareholder value is the sum of all strategic decisions that affect the firm's ability to efficiently increase the amount of free cash flow over time. LINTNER MODEL: A model stating that dividend policy has two parameters: (1) the target payout ratio and (2) the speed at which current dividends adjust to the target. AGENCY COST: A type of internal cost that arises from, or......

Words: 16016 - Pages: 65

Premium Essay

Regression Analysis

... | LETTER OF TRANSMITTAL April 12, 2012 Dr. Abul Kalam Azad Associate Professor Department of Marketing University Of Dhaka Subject: Submission of a Report on regression analysis Dear Sir, Here is our term paper on regression analysis that you have assigned us to submit as a partial requirement for the course –“Business Statistics 1” Code no-212.While preparing this term paper; we have taken help from internet, books, class lectures and relevant sources. Though we have tried best yet it may contain some unintentional errors. We hope, this term paper will come up with your expectation. We shall be glad to answer any kind of question related to this term paper and we shall be glad to provide further clarification if needed. Yours faithfully Group: ''Oracles'' Section: B 17thBatch, Department Of Marketing University of Dhaka. ACKNOWLEDGEMENT For the completion of this task, we can’t deserve all praise. There were a lot of people who helped us by providing valuable information, advice and guidance. Course report is an important part of BBA program as one can gather practical knowledge within the short period of time by observing and doing this type of task. In this regard our report has been prepared on ‘regression analyses. At first we would like to thank Almighty .Then to our course teacher for giving us the assignment helping the course as well as for his valuable guidelines. Last but not the least the......

Words: 1445 - Pages: 6

Free Essay

Regression Analysis

...Unit 5 – Regression Analysis Jessica Laux/Bakos American InterContinental University Abstract Data regression and charting are important parts of interpreting data. If one uses scatter plots, and data analysis, one can determine if a correlation exists between two data sets, or if there is actually very little. This can help when it comes to seeing for example, if job satisfaction overall is related to benefits, and if so how to change that in the favor of the business. Introduction In the following information, we will show regression outputs for data sets from the AIU data set. We will determine correlation and what it means, as well as show scatter graphs that can help determine if there is any correlation to be shown. One has to be careful to input the proper data if they want the analysis to come out correctly. Benefits and Intrinsic Job Satisfaction Regression output from Excel |SUMMARY OUTPUT |  |  |  |  | |Intrinsic |0.326704508 |3.438142011 |Y=0.0034x+4.5491 |0.0012 | |Extrinsic |-0.134516538 |6.034361553 |Y=1.6912x+13.859 |0.2275 | |Overall |0.101037811 |4.712869316 |Y=1.0105x+0.5195 |0.1021 | Similarities and......

Words: 322 - Pages: 2