Question
You are required to analyze the tutorial exercise below (quantitative analysis) using the SPSS software package. You need to pay attention to how to interpret
You are required to analyze the tutorial exercise below (quantitative analysis) using the 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. Although suggested answers will be provided by next week, 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, scales 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 cluster random sampling that the study can be generalized 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 |
1. 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.
2. You will need to interpret the SPSS outputs in layman’s terms that can be used to explain the situation to LAs' Boards.
3. You will need to suggest the strategic implications of your findings to the LA Boards involved.
Step by Step Solution
3.49 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
Linear regression is the next step up after correlation It is used when we want to predict the value of a variable based on the value of another variable The variable we want to predict is called the ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started