Question: The data for this question is in the Excel file sheet Q 9 SI Study Data and is an extract ( 1 0 0 samples
The data for this question is in the Excel file sheet Q SI Study Data and is an extract samples of the data from a research study on the factors that affect Strategy Implementation SI The variables Y X to X are as follows variable names are in italics;Y the composite score for strategy implementation. X Organisation size, which is the number of employees Log value X Score for Intelligent Reward System, which is a reward offered to implementation managers as they implement the organisations strategy.X Organicity Index, which a score on how the organisation is structured organic or mechanistic structure Higher scores represent highly organic structured organisation. NOTE: If you use Excel, please present and label all the results of the excel file; if you use SPSS please copy and paste results in the excel file. Ensure your presentation of results is very clear to your reader. aUndertake Correlation analysis you can use Excel or SPSS for this data and comment on the correlation between the sets of bivariate correlations. marksbUsing strategy implementation as dependent variable and Organisation size, Intelligent Reward System, and Organicity Index as independent variables, undertake a regression analysis of the data. markscComments on the results in terms of the Ftest, the Rsquare and the statistical significance of the variables coefficients. marksdReport your results in a tabular form. markseReport your results as an equation that can be used to forecast Strategy Implementation. Which variable should not be included in the equation and why?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
