Complete the tasks in spss - do a frequency table

Assignment Help Basic Statistics
Reference no: EM131084478

The data set you need to do the assignment can be found on Blackboard in the folder "Assignments and due dates" and in the spreadsheet "Data for Assignment 2".

This is a group assignment and you can submit the work in groups of up to 4 students.

You will need to complete the following tasks in SPSS and then submit the following files online under "Assignment 2 final submission". You will also need to print them out and submit them as well as a hard copy:

Activity 01:
Enter all data from the spreadsheet "Data for Assignment 2"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.

Download:- DATA.xlsx

Verified Expert

The given word file contains a workout on a Statistical Correlation and Internal Consistency problem using SPSS statistical software. Here, I have explained all the steps of required statistical operations with an appropriate example.

Reference no: EM131084478

Questions Cloud

Ethical dilemma-the checkup : Post a response of at least 100 words to the ethical dilemma listed below. Make sure you support your response with evidence from the text (or another source). After your initial post, reply to the posts of at least two classmates.
Write a detailed evaluation of standard you have selected : Write a detailed evaluation of the standard you have selected. Be sure to assess the importance of this standard in the area of assessments and personal and socio-cultural influences on one's own beliefs, values, and decision making. Use the text ..
A poisson random variable with expected value : In a weekly lottery, each $1 ticket sold adds 50 cents to the jackpot that starts at $1 million before any tickets are sold. The jackpot is announced each morning to encourage people to play. On the morning of the ith day before the drawing, the c..
Example of when something is valid and not reliable : Topic: Describe what reliability means in terms of research and why it is important. How does a researcher ensure that reliability is maintained in instruments, and between raters?
Complete the tasks in spss - do a frequency table : Do a frequency table, histogram, normal Q - Q and the de-trended normal Q-Q for each one of the 11 variables and what does the significance value reveal about the data we have used?
Differences between verbal and non-verbal communication : You should also discuss the differences between verbal and non-verbal communication as governed by the attribution process.  Finally you should discuss where and how attribution errors occur within the communication model.
Iid gaussian random variables with expected value : In a race of 10 sailboats, the finishing times of all boats are iid Gaussian random variables with expected value 35 minutes and standard deviation 5 minutes.
Which means that the clock of a photon''s clock : Which means that the clock of a photon's clock
Instance of epideictic rhetoric : Watch a TV advertisement and try to understand it as an instance of epideictic rhetoric & then read & do likewise with the model commencement speeches--what are the similarities and differences between the ad and the speeches as instances of epide..

Reviews

Write a Review

Basic Statistics Questions & Answers

  Payoff table for mountain ski decision problem

Construct a payoff table for Mountain Ski's decision problem of how many pairs of skis to order. What is the best decision from an expected value basis?

  Confidence interval estimate of proportion have same opinion

Construct a 99% confidence interval estimate of the proportion of all senior executives who have that same opinion. Is it possible that exactly half of all senior executives believe that the most common job interview mistake.

  Maximum rate of return to borrow for high yield investment

You would like to take an advantage of the higher yield investment but have only $500 available. What is the maximum rate of return that you would pay to borrow the $200 need to take advantage of the high yield investment?

  Calculate expectations of students which were on bus

One of 4 bus drivers is also arbitarily selected. Let Y denote number of students on his bus. Calculate the expectations of X and Y.

  Correlation coefficient between natural disaster

Example: The correlation coefficient between natural disaster and the number of doctors in the area was .95. The Martian concluded that doctors cause spontaneous generation natural disasters.

  Probabilities for normally distributed data

A local bank reported to the federal government that its 5,246 saving accounts have a mean of $1,000 and standard deviation of $240.

  How would you measure the cotinine level in the body

When nicotine is absorbed by the body, cotinine is produced. A measurement of cotinine in the body is therefore a good indicator of how much a person smokes. How would you measure the cotinine level in the body

  Descriptive statistics and mean-level comparisons

Comparison of Fathers Mean Psychological States in the Job and Home Spheres - Descriptive Statistics and Mean-Level Comparisons

  Find correlation between number of aids and syphilis cases

Construct a scatterplot of the number of AIDS cases versus the number of syphilis cases. Compute the correlation between the number of AIDS cases and the number of syphilis cases.

  A sample of 64 is taken from a large populatio the

a sample of 64 is taken from a large populatio. the population has a mean of 200 and a standard deviation of 20a

  Distribution of the number of failures

What is the distribution of the number of failures by time t? What is the distribution of the number of ?aws that remain in the system at time t? Are the random variables in parts (a) and (b) dependent or independent?

  Proability that exactecly ten customers will ask for peppers

Suppose 18 custopmers are selected at random. What is the proability that exactecly ten customers will ask for hot peppers?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd