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
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)
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?
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.
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.
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.