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

1 Expert Approved Answer
Step: 1 Unlock

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 ... View full answer

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 Accounting Questions!