-
T his cousrework is done through spss
i have a sample attached how to do it
the stock price i have taken is
1 – seagate technology
2-skywork solution
it should be playgirism freeand plagiarism level should be low
please take care of that
this cousre work you have to get the data through spss software
stock price i have taken is 1- seagate technology and 2 -skywork solution
please take the stock price from 21/06/2016 to 21/06/2018you can get the data from yahoo finance
Subject | Business | Pages | 13 | Style | APA |
---|
Answer
Quantitative Research Methods
This framework emphasizes objective measurement and statistical analysis of data o9r manipulation of preexisting datasets in order to understand the nature of the variables or ascertain certain inferences. Increasingly, this quantitative research methods have become important for managerial strategizing in the midst of turbulent times for business. Regression analysis framework is one statistical technique that has enhanced business dynamics by enabling prediction of the future by understanding the present. ‘Weak form efficiency’ is a random walk theory degree of the efficient market hypothesis claiming that past price movements, volumes and earnings data do not affect stock prices and should not be used in prediction of future stock prices, basing on the fact that stock prices are highly unpredictable. This paper heavily delves on these two analysis frameworks, dividing the paper into two parts, while testing hypotheses and formulating models that aid in understanding the case studies presented.
Part 1: Regression Analysis
In this section, estimation of Ordinary Least Squares (OLS) regression model is done based on the dataset CEO.xlsx which contains information on chief executive officers for UK corporations in 2016. The Statistical Package for the Social Sciences (SPSS) is used to estimate the model and determine the hypothesis of variable relationship. The dependent variable is ‘Log Salary’ while the independent variables include ‘Return on Assets’, ‘firm Size’, ‘CEO Tenure’, ‘Gender of the CEO’, and ‘Origin of the CEO’. The model to be estimated is the have the form below:
𝑌𝑖=𝛼+𝛽1𝑅𝑂𝐴𝑖+𝛽2𝑆𝑖𝑧𝑒𝑖+𝛽3𝜎𝑖+𝛽4𝑐𝑒𝑜𝑡𝑒𝑛𝑖+𝛽5𝐹𝑒𝑚𝑎𝑙𝑒𝑖+𝛽6𝐹𝑜𝑟𝑒𝑖𝑔𝑛𝑖+𝜀𝑖
where: 𝑌𝑖 is the log salary for CEO i;
𝑅𝑂𝐴𝑖 is the return on assets % for firm i;
𝑆𝑖𝑧𝑒𝑖 is measured by the log of firm i’s total assets;
𝜎𝑖 is the volatility measured by the daily return standard deviation (%);
𝑐𝑒𝑜𝑡𝑒𝑛𝑖 is the years as CEO with company i;
𝐹𝑒𝑚𝑎𝑙𝑒𝑖 is a dummy variable, = 1 if CEO is female, = 0 otherwise.
𝐹𝑜𝑟𝑒𝑖𝑔𝑛𝑖 is a dummy variable, = 1 if CEO is foreign, 0 otherwise
The descriptive statistics of the variables in the model are as in the table below:
Table 1: Descriptive Statistics table.
The dataset is of a sample size of 65, meaning 65 corporations were sampled and their CEOs formed the participants in the study. The variable for CEO’s annual compensation was slightly positively skewed, with the mean being higher than the median, this means that a large number of the CEOs making up the sample earned less than the mean of £4.96 Million per annum. Moreover, the range between the least paid and highest paid CEOs indicate possibility of outliers in the dataset. Other variables that are significantly skewed are ROA, ‘Female COE’ and ‘CEO Tenure’, which were all positively skewed. It is, therefore, notable that most of the CEOs were Male, and also that the return on assets for most companies was below 4.57%, and that most corporations in the sample had their CEOs tenures being less than 5.3 years.
Moreover, to determine the nature of the relationship between the dependent and the independent variables by use of OLS estimation, it is important to affirm linearity as a precondition. The scatter plots of each predictor variable against the dependent variable indicates linear relationship, as shown in the table of correlations below. The hypothesis tested is:
H0: There is no linear correlation between the dependent and each independent variable (ρ=0)
H1: There is linear correlation between the dependent and each independent variable (ρ≠0)
Variable |
Correlation Coefficient |
P-Value |
ROA |
-.027 |
.829 |
Volatility |
-.378 |
.002 |
Foreign CEO |
.351 |
.004 |
Female CEO |
-.214 |
.087 |
CEO Tenure |
.018 |
.887 |
Firm Size |
.581 |
.000 |
Table 2: Table of Correlations with ‘CEO Pay’ variable.
From the coefficients, there was significant linear relationship between the CEO Pay variable and the independent variables of the model to be estimated. Three variables, ROA, Female CEO and CEO Tenure depicted a p-value>0.05, dictating failure to reject the null hypothesis of no linear relationship. While Volatility, Foreign CE), and Firm Size are significant linear correlates of CEO Pay, with correlations of -0.378, 0.351 and 0.581 respectively. Therefore, it is also expected that the three variables will form significant predictor variables in the model for estimating CEO Pay as per the dataset with a 95% confidence level.
|
||||
Model |
R |
R Square |
Adjusted R Square |
Std. Error of the Estimate |
1 |
.731a |
.534 |
.486 |
2543.0457 |
Table 3: Model summary table here shows certain important characteristics of the model. Collectively, the predictor variables show a strong or high degree correlation with the dependent variable. The R2 value of 0.534 indicates that up to 53.4% of the variation in the estimated dependent variable (CEO Pay) is explained in the model.
|
||||||
Model |
Sum of Squares |
df |
Mean Square |
F |
Sig. |
|
1 |
Regression |
429759199.696 |
6 |
71626533.283 |
11.076 |
.000b |
Residual |
375090718.858 |
58 |
6467081.360 |
|
|
|
Total |
804849918.554 |
64 |
|
|
|
Table 4: ANOVA Table. This table indicates that the regression model predicts the dependent variable significantly well. The p-value<0.05 indicates that, overall, the regression model statistically significantly predicts the outcome variable (i.e., it is a good fit for the data). Therefore, in testing the hypothesis of collective influence of the independent variables on the dependent, the null hypothesis of no influence is rejected based on the F=11.076>Fstat, p-value<0.05. Thus, it is conclusive that the predictor variables are significant collective influencers of the dependent variable (CEO Pay).
|
||||||
Model |
Unstandardized Coefficients |
Standardized Coefficients |
t |
Sig. |
||
B |
Std. Error |
Beta |
||||
|
(Constant) |
-3675.833 |
2908.131 |
|
-1.264 |
.211 |
ROA |
-9.600 |
56.362 |
-.018 |
-.170 |
.865 |
|
Firm Size |
1311.723 |
275.885 |
.510 |
4.755 |
.000 |
|
Volatility |
-118.228 |
28.566 |
-.417 |
-4.139 |
.000 |
|
Foreign CEO |
720.019 |
729.039 |
.102 |
.988 |
.327 |
|
Female CEO |
-2893.184 |
1345.742 |
-.198 |
-2.150 |
.036 |
|
CEO Tenure |
53.345 |
64.326 |
.079 |
.829 |
.410 |
|
|
Table 5: Regression Table
The main regression model is:
CEO Pay = -3675.833 – 9.600 ROA + 1311.723 Firm Size – 118.228 Volatility + 720.019 Foreign CEO – 2893.184 Female CEO + 53.345 CEO Tenure + 2543.0457
While the independent variables are significant collective influencers of the predicted variable in the model, not all are significant. The t statistics and respective p-values indicate that ROA, Foreign CEO and CEO tenure are not significant predictors of CEO Pay in the inclusive model while Firm Size, Volatility and Female CEO are significant predictors. Moreover, Firm Size is the most important independent variable in the model, followed by Volatility, Female CEO, Foreign CEO, CEO Tenure, and ROA in respective order.
Discussion
Since it is inarguable that CEO compensation integrally influences firm performance, it is important to determine factors that should influence a company’s compensation plan for the man at the top (Sigler, 2011). Chalmers, Koh and Stapledon (2006) surmised that CEO compensation is topical and controversial and rightly receiving considerable attention from stake holders, with variance being especially on determinants of the compensation framework. This has set an argument that the compensations plans should be ad hoc rather than universal, with various companies determining their respective models of CEO compensation. In his study, Nulla (2013) concluded that CEO compensation has no relationship with the company’s ROA, a fact that is also evident in the current study. Previous research expeditions have also concluded, similar to the current finding in the study, that gender is a determinant in CEO compensation levels (Adams, et al., 2007). Various reasons have been suggested, including but not limited to traditional perceptions of the female gender. However, the current surge of feminism could be biased in explaining the real cause of the gender variable in CEO compensation determination. Past studies have also conformed the expected hypothesis that large firms pay executives more, this is largely influenced by the level of turnover, market presence, and competitive advantage among other possible factors (Frydman, & Saks, 2010).
Therefore, the current model for predicting CEO Pay is consistent with past studies and is verily replicable, as the determining variables are empirically outlined.
Weak Form Efficiency for Seagate Technology and Skywork Solution
Weak form efficiency, also known as the “random walk theory”, states that future securities’ prices are random and not influenced by past event. It is anchored on the advocacy that all current information is reflected in stock prices and past information has no relationship with current market prices. In stock market estimation, weak form efficiency is used to assert that an investor cannot use past returns to make estimations of future returns. The stock market prices of the two companies for the period beginning June 21, 2016 to June 21, 2018 is the benchmark dataset.
Seagate Technology |
Skywork Solution |
|
N |
505 |
505 |
Mean |
0.2371 |
0.1045 |
Standard Error |
0.1140 |
0.0873 |
Median |
0.2666 |
0.1993 |
Standard Deviation |
2.5618 |
1.9609 |
Sample Variance |
6.5630 |
3.8451 |
Kurtosis |
19.5802 |
6.6139 |
Skewness |
0.3587 |
0.2264 |
Range |
38.6631 |
21.6283 |
Minimum |
-16.8284 |
-8.6153 |
Maximum |
21.8348 |
13.0130 |
Table 6: Descriptive Statistics for stock markets returns for Technology and Skywork Solution.
The data for both corporations is highly skewed with significant positive skewness in both cases (mean significantly higher than the median). This case raises questions of biasness in the dataset which subjects analyses to questions of the returns for each of the companies.
The scatter plots for the two corporations is shown below.
Fig 1: Scatter Plot for Seagate Technology’s stock market returns.
Fig 2: Scatter Plot for Skywork Solution stock market returns.
The time series of the stock market returns for the two companies compares favorably as follows:
Fig 3: Time Series of the Stock Market returns.
Fig 4: Histogram for Seagate Technology’s stock market returns
Fig 5: Histogram for Skywork Solution’s stock market returns.
Further, the autoregressive model is to be conducted on the data for each company to test the hypothesis of autocorrelation between the stock market returns and the lag variables.
H0: There is no autocorrelation between stock return and lag-return
H1: There is autocorrelation between return and lag-return
Seagate Technology |
Skywork Solution |
|
Multiple R |
0.0017 |
0.0546 |
R Square |
0.0000 |
0.0030 |
Adjusted R Square |
-0.0020 |
0.0010 |
Standard Error |
2.5659 |
1.9615 |
Constant |
0.2335 |
0.1120 |
Lag |
0.0017 |
-0.0546 |
F |
0.0015 |
1.5025 |
P Value |
0.9693 |
0.2209 |
Table 7: Autoregression model output.
From the autoregression model analysis, the autocorrelation coefficients of 0.0017 and 0.0546 between stock returns and lag stock returns for Seagate Technology and Skywork Solution are too weak, pointing to a no-autocorrelation scenario. Consequently, the models fit are not significant (F value < F-Statistic, p-value > alpha – 0.05) for both corporations. Therefore, the null hypothesis of no autocorrelation is rejected at 95% confidence level. Moreover, the autoregressive models are not significant in each case.
The model for Seagate is:
𝑅𝑡 = 0.2335 + 0.0017𝑅𝑡−1 + 2.5659
While the intercept coefficient is significant, the variable coefficient is not (p-value = 0.9693 > 0.05).
Skywork’s model is 𝑅𝑡 = 0.1120 – 0.0546𝑅𝑡−1 + 1.9615.
Both of the coefficients for this model are not significant, with the p-value > 0.05 for both.
Further, the fact that the R2 values being insignificantly small in both cases (none of the models explains even 1% of the variation in the estimated stock market returns variable for a certain time), the prediction models are certainly weak.
Day of the Week Effect
The regressed moving average model for determining the day of the week effect is as follows:
Rt = β1D1 + β2D2 + β3D3 + β4D4 + β5D5
Where Di are the dummy variables for the respective days of the week (1 in case of respective day of the week, 0 otherwise). D1 is for Monday and D5 for Friday.
H0: β1 = β2 = β3 = β4 = β5
H0: At least one coefficient is different.
Seagate Technology |
Skywork Solution |
|
Multiple R |
0.1101 |
0.0678 |
R Square |
0.0121 |
0.0046 |
Adjusted R Square |
0.0022 |
-0.0054 |
Standard Error |
2.5674 |
1.9670 |
β1 (Monday) |
0.4441 |
0.1233 |
β2 (Tuesday) |
0.3075 |
0.2248 |
β3 (Wednesday) |
0.1516 |
0.0603 |
β4 (Thursday) |
-0.0087 |
0.1351 |
β5 (Friday) |
0.3170 |
-0.0204 |
F |
1.2274 |
0.4624 |
P-value |
0.2949 |
0.8043 |
Table 7: Regression table for the dummy variables.
Based on the F statistics and the p-value>0.05, we fail to reject the null hypothesis. Therefore, there is no significant different in the respective coefficients of the days of the week. It is thus conclusive at 95% confidence level that there is no significant presence of day of the week effect in determining the stock returns for these two companies, based on the two-year dataset.
Discussion
The current study of each of the two companies deviates with past researches on stock market returns that have concluded that have reinforced that there is volatility in patterns across days of the week (Berument, & Kiymaz, 2001). This study concludes that there was no statistical difference in the effects of stock returns in the various days of the week. In spite of the insignificance of the effects of days of the week, the patterns indicate that stock returns were higher during the early days of the week, compared to the ending days. This fact is consistent with past researches that have asserted the insinuation from some past stock market studies. Steeley (2001) explained that the surface systematic day-of-the-week effects only visible when returns are partitioned by the direction of the market, a paradigm that resonates verily with the current study.
References
Adams, S. M., Gupta, A., Haughton, D. M., & Leeth, J. D. (2007). Gender differences in CEO compensation: Evidence from the USA. Women in Management Review, 22(3), 208-224. Berument, H., & Kiymaz, H. (2001). The day of the week effect on stock market volatility. Journal of economics and finance, 25(2), 181-193. Chalmers, K., Koh, P. S., & Stapledon, G. (2006). The determinants of CEO compensation: Rent extraction or labour demand?. The british accounting review, 38(3), 259-275. Frydman, C., & Saks, R. E. (2010). Executive compensation: A new view from a long-term perspective, 1936–2005. The Review of Financial Studies, 23(5), 2099-2138. Nulla, Y. (2013). The effect of return on assets (ROA) on CEO compensation system in TSX/S&P and NYSE Indexes Companies. Sigler, K. J. (2011). CEO compensation and company performance. Business and Economics Journal. Steeley, J. M. (2001). A note on information seasonality and the disappearance of the weekend effect in the UK stock market. Journal of Banking & Finance, 25(10), 1941-1956. |
Related Samples
The Role of Essay Writing Services in Online Education: A Comprehensive Analysis
Introduction The...
Write Like a Pro: Effective Strategies for Top-Notch Explication Essays
Introduction "A poem...
How to Conquer Your Exams: Effective Study Strategies for All Learners
Introduction Imagine...
Overcoming Writer’s Block: Strategies to Get Your Essays Flowing
Introduction The...
Optimizing Your Online Learning Experience: Tips and Tricks for Success
The world of education...