### 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

#### Determining pert and cpm

Assume you are going to manage a large construction project involving many subcontractors. Why use PERT or CPM to plan the project rather than just logically scheduling the

#### Break-even point and equilibrium point

A company, sells and repairs old bicycles and parts for replacement. Sell reconstructed pictures at a unit price of \$ 50. The fixed cost of equipment for re construction of

#### Show that the probability that is even

Let N(t) be the number of arrivals in the interval (0, t] for a Poisson process of rate λ. Show that the probability that N(t) is even is [1 + exp(-2λt)]/2.

#### Detailed explanation of break even

Jason processes and bottles jams. His fixed costs are 250 per month and the variable cost per jar is 1.20. He sells the jam to local grocery stores for 3.20 each. How man ja

#### Use of statistics in business research

Why use statistics in business research, and what is its role? How can the concept of variance and standard deviation be applied to solving a real world business-related prob

#### Construct the full design matrix for experiment

MS0601 - Implement appropriate multivariate techniques using statistical software. Compare, contrast, appraise and evaluate the results from the application of multivariate

#### Determining total and annual return rates

Compute the total and annual returns on the described investment four years after buying 100 shares of XYZ stock for \$60 per share, you sell the stock for \$9300.

#### Credit default swap-unconditional default probability

Calculate a simple one-year credit default swap spread using a recovery rate of 30% and an unconditional default probability of 4%. Assume that there are no accruals, paymen