Qatar University, CAS, MSPSTAT 101-Statistics I
Name: ……………………………..
Lab Assignment
Fall 2022
ID No:…………………………..
–
Use Minitab/SPSS/Excel software to answer the following
questions:
4
–
Interpret all answers.
–
You should send your solution to my e-mail (or hardcopy) by no
more than 11:59 PM on Tuesday 03/01/2023.
Q1: [3 marks] Use the excel file named “Lab Hwork Data” to answer this
question.
a) Use the qualitative random variable (Blood Type) in the excel sheet to
construct an appropriate two type of graphs. Use your name as a title of
the graphs.
b) Use the quantitative random variable (Age) in excel sheet to construct a
boxplot and histogram and identify outlier if any.
c) Use the quantitative random variable (Age) in excel sheet to conduct
the descriptive statistics for center and dispersion.
Q2: [2 marks] The Weight of female student is normally distributed with a
mean of 65 kg and a standard deviation of 9 KG.
a) What percentage of a female student population has weight exceeds by
67kg?
b) Find the weight where 20% of a female student have weights less than
this weight.
Q3: [2 marks] Generate a sample of size 200 using a Poisson distribution
with mean 21.
a) Calculate the sample mean and standard deviation.
b) Calculate the five numbers summary.
c) Construct the histogram of the data.
Q4: [3 marks] A student conducted a survey of 16 students and found
that the average time spent online on the social media platform was
26 hours per week with a standard deviation of 6.5 hours. A sociology
professor claimed that university students spend an average of 24
hours per week on social media platform.
a) Construct a 99% confidence interval for the average time.
b) Test at level α = 0.05 the claim that the average time is different from 24
hours.
c) Repeat part (b) if the number of students is 36.
Age
Blood_Type
36
16
28
34
28
23
26
24
19
18
26
55
26
35
8
30
22
24
25
23
27
24
34
26
33
33
27
17
24
28
26
31
27
24
33
23
19
17
33
23
16
35
15
AB
A
AB
A
A
B
AB
B
O
AB
AB
B
A
B
AB
A
B
AB
AB
A
A
A
AB
B
AB
O
A
AB
A
AB
AB
AB
A
AB
AB
AB
AB
A
AB
B
AB
B
AB
O
AB
B
AB
O
A
B
AB
B
A
A
A
A
B
A
AB
AB
B
AB
O
AB
B
B
B
O
A
B
AB
AB
O
AB
A
AB
AB
A
O
AB
A
