### Do a frequency table - histogram and normal q

##### Reference no: EM13742017

You will need to complete the following tasks in SPSS:

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.

Attachment:- DATA.xlsx

Verified Expert

#### Details regarding analysis of variance

Suppose you are testing the differences in attitudes toward health care reform using Democrats, Republicans, and Independents. What statistical test would be the best to use

#### Determining efficienct market hypothesis

The Efficient Markets Hypothesis holds that markets do not react to news or announcements because by the time the information is disseminated, it has already been anticipate

#### Determining cost of equity bu using capm

Booher Book Stores has a beta of 0.8. The yield on a 3-month T-bill is 4% and the yield on a 10-year T-bond is 6%. The market risk premium is 5.5%, and the return on an aver

#### Show that there must be some other state say state two

Show that there must be some other state, say state 2, and some decision, k2, such that P(k2) > 0. Show that there must be some other state, say state 3, and some decision, k3

#### Evidence ratio for the currently installed system

Based on the definition of evidence ratio in the previous paragraph, what is the evidence ratio for the currently installed system and what is the evidence ratio for the new

#### Find the numerical value of the given lim n

Find the numerical value of limn→∞ v(n). Interpret the meaning of the elements vi in the solution of (4.32). Give a direct argument why (4.32) provides the solution directly

#### Identify and define the slope and the y-intercept

Find (specify) the best model to predict the occupancy rate of the hotel complex - identify and define the slope and the y-intercept and predict the occupancy based on locatio

#### Examples of contigent liability

Unruh Co. is being sued for illness caused to local residents as a result of negligence on the company's part in permitting the local residents to be exposed to highly toxic