Exercise 1

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 2

Exercise-1

1. Create data file and enter the data. Be sure to include variable and value labels and save
this file with name “Grade.sav”
Note: Return this sheet at end of class after answering the questions.

id Age Gender Average Hours of Number of Grade in Marks


Sleep Classes Course
Missed
1 19 Male Seven 0 A 15
2 18 Female Four 1 C 10
3 17 Female Six 2 B 13
4 19 Female Ten 5 F 18
5 20 Male Eight 2 B 17
6 21 Female Seven and a half 3 C 14
7 22 Male Nine 1 B 20
8 22 Male Eight 2 A 23
9 20 Male Six 3 D 15
10 20 Female seven 2 B 19
11 21 Female Four 5 F 18
12 23 Male Six 2 B 17
13 19 Female Ten 3 C 14
14 19 Female Eight 1 B 20
15 18 Male Six 5 A 23

2. Create a histogram for age using file Grade.sav


I. Check the skewness of data and mark the appropriate option
a. Symmetric b. Negative skewed c. Positive skewed
II. Check the Peakedness of data and mark the appropriate option
a. Mesokurtic b. Leptokurtic c. Platykurtic
III. Check the normality of data using normality test and mark the appropriate option
IV. Normal b. Not Normal
Create a boxplot for Marks using file Grade.sav
Write the following information using box plot
a.Minimum value ------- b. Maximum value--------c. Q1-------d.Q3---------e.
median---------

3. Create a scatter plot illustrating the relationship between age and Marks using file
Grade.sav. Include the line of best fit. Does there appear to be a relationship between
these variables? Using Line of scatter plot, write the values of Estimated marks.
Age 17 18 19 20 21 22 23 24 25
Estimated Marks

4. Create a pie chart with percentage of cases illustrating the Grade using file Grade,sav
and complete the following table reading from pie chart.
Grade A B C D E F
% of students

5. Create a bar chart of male and female with mean age? Complete the table

Male Mean age Female Mean age

6. Create a bar chart of male and female with different grades with mean age? Complete the
table
Grade Male Female Male Female Male Female Male Female
Grade A Grade A Grade B Grade B Grade C Grade C Grade D Grade D
Mean
Age

7. Apply independent samples t-tests to compare the Marks of Male and female and explain
whether there is significant difference in marks or not.

You might also like