Reference no: EM13837129
You will need to complete the following tasks in SPSS and then submit the following files.
Activity 01:
Enter all data from the spreadsheet "Data for Assignment" into SPSS. You will need to set up the variable view with the following 11 variables and then enter the data in data view:
a) Student_ID,
b) Year_Enrolled,
c) HI001_Final_Exam,
d) HI001_Assignment_01,
e) HI001_Assignment_02,
f) HI002_Final_Exam,
g) HI002_Assignment_01,
h) HI002_Assignment_02,
i) HI003_Final_Exam,
j) HI003_Assignment_01,
k) HI003_Assignment_02.
Activity 02:
a) Do a frequency table, histogram, normal Q - Q and the de-trended normal Q-Q for each one of the 11 variables.
b) Do descriptive statistics (mean, standard deviation, minimum, maximum) for each one of the 11 variables.
Activity 03:
a) Do at least 10 different correlations between the any pairs of variables: For example:
o HI001_Final_Exam and HI002_Final_Exam
o HI001_Assignment_01 and HI001_Assignment_02
b) For each correlation discuss the results:
o Are they are positive/negatively correlated?
o Are they weak or strong correlations?
o What is the significance value?
o What does the significance value reveal about the data we have used?
Activity 04:
a) Do a Cronbach's alpha reliability test on the following 9 variables: HI001_Final_Exam, HI001_Assignment_01, HI001_Assignment_02, HI002_Final_Exam, HI002_Assignment_01, HI002_Assignment_02, HI003_Final_Exam, HI003_Assignment_01, HI003_Assignment_02.
b) Discuss the results.
a. What item/s can be deleted to improve reliability?
b. What items should never be deleted to maintain reliability of data?
c. How many items need to be deleted to achieve maximum reliability?
Activity 05:
a) Copy -paste the data view and the variable view from your SPSS file to a Word document.
b) Copy-paste ALL the output from all the activities requested in Activity 01 to 04 in SPSS and put the answers in the same Word document.
c) Answer all discussion questions requested in Activity 01 to 04 and put the answers in the same Word document.
d) Submit a hard copy of Assignment 02 Word document to Holmes.
e) Submit a soft copy of the SPSS files used in SPSS and the Assignment 02 Word document online under Assignment 02 final submission.
Attachment:- DATA for Assignment.xlsx
|
Prepare a preliminary business report for keith
: Your task is to prepare a preliminary business report for Keith. Keith has an in-house style which he expects for business reports, so the main body of your report must be structured using the following headings.
|
|
Calculate the residual
: Regression line drawn as Y=C+1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual.
|
|
Explain what will happen to the capital-labor ratio
: You are tasked with manufacturing 12 commercial aircraft per month. A new OSHA rule requires that welders be given paid 2 hour break for every 2 hours of work to prevent carpel tunnel syndrome. Using the isoquant-isocost graph as an aid, explain what..
|
|
What is the short run average cost of producing
: What is the short run average cost of producing 20,000 units?
|
|
Do a frequency table - histogram and descriptive statistics
: Do a frequency table, histogram, normal Q - Q and the de-trended normal and Do descriptive statistics (mean, standard deviation, minimum, maximum) for each one of the 11 variables.
|
|
Credit policy decision
: Henderson Office Supply is considering a more liberal credit policy to increase sales, but expects that 9 percent of the new accounts will be uncollectible. What is the level of accounts receivable to support this sales expansion? What would be Hende..
|
|
Cost-benefit analysis of cash management
: City Farm Insurance has collection centers across the country to speed up collections. The company also makes its disbursements from remote disbursement centers. If City Farm has $5 million per day in collections and $3 million per day in disbursemen..
|
|
Have stamp prices kept pace with the inflation rate
: The price of a first class stamp is .42 cents in 2009. The price of the same first class stamp in 1975 was .13 cents. The price index in 1975 was 75 and price index in 2009 will be 218. After adjusting for inflation, how much more expensive is the st..
|
|
Labor force participation rate
: The number of people employed in a city was 128,000. The adult population was 201, 000 and the labor force participation rate was 67%. Based on the figures listed above, what is (1) the unemployment rate, (2) labor force participation rate, (3) numbe..
|