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 Q9 SI Study Data and is an extract (100 samples) of the data from a research study on the factors that affect Strategy Implementation (SI). The variables (Y, X1 to X3) are as follows (variable names are in italics);Y = the composite score for strategy implementation. X1= Organisation size, which is the number of employees (Log value). X2= Score for Intelligent Reward System, which is a reward offered to implementation managers as they implement the organisations strategy.X3= 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. a)Undertake Correlation analysis (you can use Excel or SPSS) for this data and comment on the correlation between the sets of bivariate correlations.(10 marks)b)Using strategy implementation as dependent variable and Organisation size, Intelligent Reward System, and Organicity Index as independent variables, undertake a regression analysis of the data. (10 marks)c)Comments on the results in terms of the F-test, the R-square and the statistical significance of the variables coefficients. (15 marks)d)Report your results in a tabular form. (5 marks)e)Report 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!