Question: You are required to analyse the tutorial exercise below (quantitative analysis) using SPSS software package. You need to pay attention to how to interpret SPSS
You are required to analyse the tutorial exercise below (quantitative analysis) using SPSS software package. You need to pay attention to how to interpret SPSS results correctly (such as correlation and regression outputs). It will be worthwhile completing the exercise as it will enable you to complete assessment two correctly. Please try your best to do the exercise yourself.
Task
As an MBA student, you are preparing your dissertation to investigate local authorities (LAs) performances in England and Wales. You designed and distributed survey questionnaires by utilizing continuous rating scales, scale 1 (the best) to 10 (the worst). Ten local authorities (A, B to J) in England and Wales were selected as respondents by using cluster random sampling. It is intended by employing the cluster random sampling that the study can be generalised for every LA in England and Wales. The following table below shows how ten LAs (as respondents) were ranked according to their institutional performance (as indicated in their BVPI - Best Value Performance Indicators) and according to the LAs expenditures on training for succession management.
| LAs ranked according to their institutional performance | ||||||||||
| Local Authorities | A | B | C | D | E | F | G | H | I | J |
| Ranking Based on BVPI | 2 | 5 | 6 | 1 | 4 | 10 | 7 | 9 | 3 | 8 |
| Ranking Based on Training Expenditures | 1 | 6 | 4 | 2 | 3 | 7 | 8 | 10 | 5 | 9 |
- You want to investigate whether there is a relationship between the LAs performances and their spending budgets on staff training (for the institutional succession management). Accordingly, you will need to undertake a regression analysis based on the above data by using SPSS software.
- You will need to interpret the SPSS outputs in laymans terms that can be used to explain the situation to LAs' Boards.
- You will need to suggest the strategic implications of your findings to the LA Boards involved.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
