{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]
  1. 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 free

    and 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/2018

    you 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 Review22(3), 208-224.

Berument, H., & Kiymaz, H. (2001). The day of the week effect on stock market volatility. Journal of economics and finance25(2), 181-193.

Chalmers, K., Koh, P. S., & Stapledon, G. (2006). The determinants of CEO compensation: Rent extraction or labour demand?. The british accounting review38(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 Studies23(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 & Finance25(10), 1941-1956.

Related Samples

WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?