Do a frequency table - histogram and normal q

Assignment Help Advanced Statistics
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

Reference no: EM13742017

Questions Cloud

Make suitable assumptions for temperature and pressure : Determine the mass (in kg) and weight (in N) of the air contained in a typical school classroom whose dimensions are 40 ft x 60 ft x 12 ft. Make suitable assumptions for temperature and pressure given that the classroom is at Penn State in University..
Write a research paper on the movie is gone with the wind : Write a research paper on The movie is Gone with the Wind. In your paper you will compare the film with the true historical facts.
The prinicple of common desended helps explain why : the prinicple of common desended helps explain why
How much heat in btu is generated in the collision : A 4000 lb meteor hits the earth's surface at 15,000 ft/s. How much heat, in Btu, is generated in the collision?
Do a frequency table - histogram and normal q : Do a frequency table, histogram, normal Q - Do descriptive statistics - Different correlations between the any pairs of variables.
What is the long-run optimal input combination : Suppose the production function for pasta is Q = 4kl. What is the long-run optimal input combination when Q = 16 , r = 4 , and w = 36 ?
Describe some adaptations that species developed : Choose a species and describe some adaptations that species developed that allow them to survive in their native habitat
A mass weighs 15 newtons on the moon : A mass weighs 15 Newtons on the moon, where the acceleration of gravity is 1.67 m/s^2. Determine the weight, in Newtons, on Mars where g= 4.23 m/s^2
Examples of some clear-out cases and some borderline ones : Explain why there is a blurry line dividing objects that are “money” from those that are not. Give examples of some clear-out cases and some borderline ones. Could the position of this blurry line change over time?

Reviews

Write a Review

Advanced Statistics Questions & Answers

  Find the correlation coefficient between x and z

Find the correlation coefficient between X and Z - Consider two independent random variables X and W with identical variance.

  Evaluation of the forecasts for september

Prepare a forecast for January, 2015 using each of the three methods based on the results of evaluation of the forecasts for September through December.

  Estimating common equity from retained earnings

Your firm has been hired to help ABC Company to estimate the cost of common equity. The yield on the firm's bonds is 5.75%, and your firm's economists believe that the cost of common equity can be estimated using a risk premium of 2.5% over a firm..

  Part a a1 after some months of successful predation ie

part a a1. after some months of successful predation i.e. finally eliminating its rival miss youngs husband can charge

  Purpose of adding asset with negative-low positive beta

The purpose of adding an asset with a negative or low positive beta is to:

  Problem 11 there is a formula for sample size n with given

problem 11. there is a formula for sample size n with given margin of error m and condence level c for population

  Individual project most businesses can benefit from

individual project most businesses can benefit from statistical process controls to ensure consistency in product or

  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 technology

  Determine the maximum flow

Determine the maximum flow (in hundreds of gallons of water per minute) from node 1 to node 5. Remember that the arc has both capacity and reverse capacity.

  Do a one-way anova to test the hypothesis

Do a one-way ANOVA to test the hypothesis that the population means are equal and what are the hypotheses to be tested here? What is the value of F ?

  Determining statistical process controls

Using quantitative tools is one way to manage data. What kind of solutions may be derived using various statistical process controls (SPC)?

  What would be the predicted median household income

What would be the predicted median household income if the percentage of the population in the state were 50% or 50?

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