SPSS Assignment
Answer Sheet:
Please write down your short answer under the “Answer” column in the following table. Then, attach the corresponding support materials starting page 3.
Question number & marks
Related SPSS file name
Question
Answer
1.
(10 marks)
Employee_retention.sav
This data set shows employee’s desire to stay with a company after 5 years. Some were given salary increase, while others were given larger workspace size (e.g., desk/cubicle). If you are the HR manager, would you suggest the company to increase employee’s workspace size, increase their salary (assuming they are mutually exclusive), or can’t draw a conclusion because the result is not significant? The C.I. is 95%.
2.
(10 marks)
Studentsat.sav
This data set shows student’s satisfaction level in Dr. Wong’s class as compared to another professor, Dr. Simpsons. Are the satisfaction levels significantly different from each other, at 95% C.I.? Yes/No
3.
(10 marks)
Traininig.sav
Look at the employee’s computer literacy. Is the data skewed? Yes or No?
4.
(10 marks)
Training.sav
Calculate the z-score of skewness of employee’s computer literacy
5.
(10 marks)
Wireless.sav
For variable “Smartphone knowledge” and “Percentage of training class attended”, is the homogeneity of variance maintained according to the Levene’s Test? In other words, is it true that the variance of one variable stable at all levels of the other variable? Yes/No?
6.
(10 marks)
Lunchtime.sav
This data set shows the number of minutes employees spent on having lunch. The national average is 45 minutes. So, do your employees spend significantly more (or less) time to eat lunch than the national average, at 95% C.I.? Yes/No
7.
(10 marks)
Storedesign.sav
This data set shows the number of minutes shoppers spent in a store when it had the racetrack design, as compared to those when the same store had utilized a grid store design previously. Is there a significant difference in the time between these 2 store design, at a 95% C.I.? In addition to answer a Yes/No, you also need to write out how the T-statistics should be reported.
8.
(10 marks)
Hamburger.sav
This data set shows the taste of different kinds of hamburgers. The higher the score, the better the hamburger tastes. Do the participant really believe that the organic beef burger tastes significantly better than other ones, at a 95% C.I.? Yes/No
9.
(10 marks)
Record2sav
A record (music) company is interested in predicting record sales from advertising. At 95% C.I., it means that advertising $ can account for what percentage of the variation in record sales?
10.
(2 marks)
No file is needed for this one.
If there is a variable called “CUSTCOM” which stands for the amount of customer complaint. Assuming that I want to do a data transformation using arithmetic base-10 logarithm. Also, we know all values in this variable are larger than zero. What will be the corresponding “Numeric Expression:” that you need to type (or build) in the “Compute Variable” screen in order to create the newly transformed variable?
11.
(4 marks)
Cashier.sav
With the help of a boxplot, identify the outlier. Name the corresponding “Cashier ID number” where the outlier is located.
12.
(4 marks)
SAQ.sav
This data set is a survey that includes many questions. The scale reliability is pretty good already, but if I absolutely want to further increase the scale “reliability” of this survey, which single question should be removed to give me the highest overall scale reliability, according to the Cronbach’s alpha analysis? Please identify the Question number.
[Important note: In order to get marks for this SPSS assignment, you MUST provide supporting materials to show me that you have actually done your homework to arrive at the answer, and not guessing the answer by chance! What you need to include is up to you. Examples include a screen shot of SPSS output (printscreen), or a written explanation of your calculation. Please put all of your answers/graphics onto this single MS Word file, thanks.]
Supporting Materials:
[please write or paste your SPSS output here, and label each question # properly]