Quantitative Exercise Assignment

MGT 386     

Quantitative Exercise Assignment This exercise is designed to help you become more familiar with the basics of analyzing and interpreting the results of a survey. I have provided you with a small dataset in an Excel document that consists of 9 variables. Your job is to:

1. Review the variables that are available in the dataset – shown on the “Variables Description” worksheet 2. Select at least three variables from the survey 3. Write at least three hypotheses regarding how these variables are related (e.g., positively correlated, not

related, or negative correlated) as well as describing your reason for predicting these hypotheses. Here is an example of how to write a hypothesis:

o Hypothesis 1: Job satisfaction will be positively correlated to pay satisfaction

4. Calculate the descriptive statistics for each scale you have included in your hypotheses in the space provided below the responses on the “Data” worksheet (starting on row 306). Here is the syntax for each statistic:

o =MIN( ) o =MAX( ) o =AVERAGE( ) o =STDEV( )

5. Calculate whether each variable you have included in your hypotheses is correlated in the space

provided below the descriptives on the “Data’ Worksheet (starting on row 313). Again, here is the syntax:

o =CORREL( )

6. Check to see if the correlation is statistically significant using the chart I provide on the “Table of Critical Values” worksheet. Please look up significance at a .05 level and note that the column on the left refers to the number of responses you have in the survey.

7. Write up a summary (between 600 to 800 words long) of what you have done, including: o Written hypothesis that clearly states which two variables you are predicting in each hypothesis

and the type of relationship you expect (e.g., positively correlated, not related, or negative correlated)

o A written argument for why you predicted each hypothesis. o A written summary of

 Descriptive statistics  Correlations (including whether the findings are statistically significant  Note whether each of your hypotheses were supported or not  In each case, you are taking the numbers you calculated and writing them out for others

to understanding. Provide enough detail that a person not familiar with these concepts will understand.

8. Submit both the write-up and the Excel sheet showing your work via Canvas. Please note that you are not being graded on whether you find significant correlations or if your hypotheses are supported. Instead, I will look at whether you provide a good argument to support the hypotheses you predicted as well as making sure you have conducted and written up the analysis described above.