Statistical Analysis Assignment

Statistics Project, Statistics

Statistical Analysis Assignment

Project description

The task contains five (5) . Each question contains 10 marks

need to:

• Explain step by step how the analysis is done

• Provide all the graphical SPSS output

• The output needs to be put in a CD and to be submitted to the school.

Assignment 1

Question One

Instructions:

Use the given data set, define the variables and enter data into SPSS Data Editor

1. Define the variables and enter data into SPSS Data Editor

2. Save the data file as “GMxxx SPSS Data Set2.sav”

Make sure to enter the data correctly otherwise results of your analyses will be different from the actual. Once you have entered the data, please proceed with the following computations

3. Compute the difference between X8 and X9. Assign the new variable as d.

4. Compute average summated attitude scores using the syntax:

COMPUTE Attitude=MEAN (A1 to A7)

5. Compute average summated Quality of Work Life scores using the syntax:

COMPUTE QL=MEAN (Q1 to Q9).

6. Categorize Attitude and QWL into the following categories.

Assign the new variables as Attitude_Cat and QWL_Cat, respectively

Low 1 – 2.339

Moderate 2.34 – 3.669

High 3.67 – 5

Please work on the following analyses and submit the SPSS results together with Table 1

and Table 2.

Make sure to clearly label the SPSS outputs for easy identification to the respective

questions:

1. Get listing of the following variables: ID, d, Attitude, QWL, Attitude_Cat, and

QWL_Cat

2. Run reliability tests on instruments for: (Present your results in Table 1)

– Attitude

– Quality of Work Life (QWL)

3. Run Frequency procedure and complete information in Table 2.

4. Get list of Quality of Work Life (QWL) scores by gender.

In addition, request for number of cases (n), mean and standard deviation.

5. Get mean, sum, variance, standard deviation and range for QWL and Attitude

6. Get the frequency breakdown of QWL for female respondents

7. Get frequency breakdown of QWL for female respondents with age more than

25 years

8. Get a bar chart for QWL_Cat

Table 1: Reliability of Study Instruments

Instruments # items Cronbach Alpha

Attitude

Quality of Work Life

Table 2: Distribution of Attitude and Quality of Work Life

Variable Freq Percent Mean SD

Attitude

Low (1 – 2.33)

Moderate (2.34 – 3.66)

High (3.67 – 5)

Quality of Work Life

Low (1 – 2.33)

Moderate (2.34 – 3.66)

High (3.67 – 5)

Question Two

1. Use the given data set, solve for the questions below:

a. What is the scale of measurement of the Stress Scores?

b. Based on the frequency results, find measures of central tendencies – mode,

median and mean

c. Based on the frequency results, find measures of dispersion – range, variance and

standard deviation

d. Does the distribution of the stress scores meet the assumption of normality?

Use the appropriate statistic to test on the assumption.

2. In a one-sample pre-test and post-test experimental design, Dr. Noor Azman is interested

to test the effect of attending SPSS workshop to improve students’ knowledge on data

analysis. Choose two APPROPRIATE variables from GMxxx SPSS Data Set2 data file and run

paired sample t-test. Test different at .05 level of significance.

Based on the results, answer the questions below.

a. What would be the appropriate null and alternative hypotheses?

b. What is the value of the test statistic?

c. What would be your decision? Justify your answer.

d. What can you conclude based on the hypothesis test?

Question Three

1. Choose two APPROPRIATE variables from GMxxx SPSS Data Set2 data file and run Oneway

Analysis of Variance test. Test different at .01 level of significance.

Based on the results, answer the questions below.

a. List the two variables and their scales of measurement.

b. Does this analysis meet the assumption on equality of variances?

Justify your answer.

c. State the appropriate null and research hypotheses?

d. What is the value of the test statistic?

e. What would be your decision? Justify your answer.

f. What can you conclude based on the hypothesis test?

g. What can you conclude based on the “Multiple Comparison” table?

2. Choose two APPROPRIATE variables from GMxxx SPSS Data Set2 data file and run

chi-square test of independence. Test the hypothesis on the relationship at

.01 level of significance.

Based on the results, answer the questions below.

a. What would be the appropriate null and alternative hypotheses?

b. What is the value of the test statistic?

c. What would be your decision and conclusion? Justify your answer.

d. Use AN appropriate symmetric measure and describe the nature of relationship between the two variables.

Question Four

1. Choose two APPROPRIATE variables from GMxxx SPSS Data Set2 data file and run

Spearman Rho correlation analysis.

Based on the results, answer the questions below.

a. What are the two variables selected?

b. What is the value of rs?

c. What can you describe based on the coefficient?

d. Test the hypothesis on the relationship between the two variables at .01 level of

significance.

– State the appropriate null and alternative hypotheses

– What would be your decision and conclusion? Justify your answer.

2. Choose two APPROPRIATE variables from GMxxx SPSS Data Set2 data file and run Pearson

correlation analysis.

Based on the results, answer the questions below.

a. What are the two variables selected?

b. What is the value of the correlation coefficient?

c. What can you describe based on the coefficient?

d. Test the hypothesis on the relationship between the two variables at .01 level of

significance.

– State the appropriate null and alternative hypotheses

– What would be your decision and conclusion? Justify your answer.

Question Five

1. Dr. Noor Azman is interested to test how good tenure (X) can be used to predict

commitment (Y). Data collected from a survey is used in this analysis.

Choose two APPROPRIATE variables from GMxxx SPSS Data Set2 data file and run Simple

Linear Regression analysis.

Based on the results, answer the questions below.

a. What are the two variables selected?

b. What is the prediction equation?

c. What is the nature of relationship between the two variables?

d. Test the appropriate hypothesis based on the “ANOVA” table at .05 level of

significance.

– State the appropriate null and alternative hypotheses

– What is the value of the test statistic?

– What would be your decision and conclusion? Justify your answer.

e. Test the appropriate hypothesis based on the “Coefficients” table at .05 level of

significance.

– State the appropriate null and alternative hypotheses

– What is the value of the test statistic?

– What would be your decision and conclusion? Justify your answer.