ASSIGNMENT/ TUGASAN

_________________________________________________________________________
SBST3203
ELEMENTARY DATA ANALYSIS
ANALISIS DATA PERMULAAN
SEPTEMBER 2021

SPECIFIC INSTRUCTION / ARAHAN KHUSUS

1. Answer in ENGLISH or MALAY /

Jawab dalam BAHASA INGGERIS atau BAHASA MELAYU

2. Submit your assignment ONCE only in a SINGLE file. /

Hantar tugasan SEKALI sahaja dalam SATU fail.

3. Submit your assignment ONLINE /

Tugasan ini dihantar secara ONLINE.

4. Submission date : 15 NOVEMBER 2021.

Tarikh penghantaran : 15 NOVEMBER 2021.

5. This assignment accounts for 60% of the total marks for the course / Tugasan ini
menyumbang sebanyak 60% dari jumlah markah kursus.
 ASSIGNMENT QUESTION

QUESTION 1

A Human Resource manager in an IT company would like to know whether the median
salary of fresh graduate employees with IT background is more than RM3500 per month.
Data of salary for 10 fresh graduates is shown in Table 1.
Table 1
Employee Salary (RM)
1 2300
2 1800
3 3600
4 3700
5 4000
6 5500
7 4400
8 3500
9 2900
10 3700

a) Explain which statistic distribution should be used in order to test the manager’s
claim.
b) Construct a complete hypothesis test to test whether the manager’s claim is
correct or not at  = 0.05.
c) Based on your answer in (b) state a brief summary of the median salary of fresh
graduate employees with IT background.
[Total: 20 / 60 marks]
Question 2

According to a fast-food manager, the average number of customers between 8am to

11am is 10, with a variance of two. His friend from another outlet does not believe that
the variance is two. He counts the number of customers in 15 other outlets and obtained
the data as in Table 2.
Table 2
Outlet Number of Customers
1 11
2 10
3 9
4 10
5 10
6 11
7 11
8 10
9 12
10 9
11 7
12 9
13 11
14 10
15 11

a) Explain which statistic distribution should be used in order to test whether the
variance is different from two.
b) Construct a complete hypothesis test to test the claim in (a) at  = 0.05.
c) Based on your answer in (b) state a brief summary of the variance number of
customers.

[Total: 20 / 60 marks]
Question 3

A homeowner is interested in the effect that using the air conditioner and washing
machine had on the electric bill. He recorded the number of hours the air conditioner and
the number of times washing machine were used for 14 days. He also monitored the
electric meter for these 14 days, and computed the amount of electricity used each day in
kilowatt-hours. Data is shown in Table 3.
Table 3
Air Conditioner Washing Machine Electricity Used
(hours) (times) (kwh)
1.5 1 35
4.5 2 63
5.0 2 66
2.0 0 17
8.5 3 94
6.0 3 79
13.5 1 93
8.0 1 66
12.5 1 94
7.5 2 82
8.0 3 78
7.5 1 65
12.0 1 77
6.0 0 75

a) Use Microsoft Excel to produce Analysis of Variance table for the multiple linear
regression and state the model.
b) Construct a complete hypothesis test to test whether the model in (a) is fit at  =
0.05.
c) Construct a complete hypothesis test to test whether the regression coefficients, 1
and 2, are significantly zero at  = 0.05.
d) Based on your answer in (b) and (c) state a brief summary on the linear
relationship between electricity used and the two factors.
[Total: 20 / 60 marks]
 SOALAN TUGASAN

Soalan 1

Seorang pengurus Sumber Manusia di sebuah syarikat IT ingin mengetahui sama ada
median gaji pekerja kalangan graduan baharu yang mempunyai latar belakang IT melebihi
RM3500 sebulan. Data gaji 10 graduan baharu dipaparkan dalam Jadual 1.

Jadual 1
Pekerja Gaji (RM)
1 2300
2 1800
3 3600
4 3700
5 4000
6 5500
7 4400
8 3500
9 2900
10 3700

a) Terangkan taburan statistik mana yang perlu digunakan untuk menguji dakwaan
pengurus tersebut.
b) Bina ujian hipotesis lengkap untuk menguji sama ada dakwaan pengurus tersebut
betul atau tidak pada  = 0.05.
c) Berdasarkan jawapan anda di (b) nyatakan ringkasan kesimpulan gaji pekerja
graduan baharu yang mempunyai latar belakang IT.
[Jumlah: 20 / 60 markah]
Soalan 2

Menurut seorang pengurus makanan segera, purata bilangan pelanggan antara jam 8 pagi
hingga 11 pagi adalah 10 orang, dengan varians dua orang. Rakan beliau dari cawangan lain
tidak percaya bahawa varians adalah dua. Dia menghitung bilangan pelanggan di 15
cawangan lain dan memperoleh data seperti Jadual 2.
Jadual 2
Cawangan Bilangan Pelanggan
1 11
2 10
3 9
4 10
5 10
6 11
7 11
8 10
9 12
10 9
11 7
12 9
13 11
14 10
15 11

a) Terangkan taburan statistik mana yang perlu digunakan untuk menguji sama ada
varians berbeza daripada dua.
b) Bina ujian hipotesis lengkap untuk menguji dakwaan (a) pada  = 0.05.
c) Berdasarkan jawapan anda di (b) nyatakan ringkasan kesimpulan mengenai varians
bilangan pelanggan.
[Jumlah: 20 / 60 markah]
Soalan 3

Seorang pemilik kediaman berminat mengenai kesan penggunaan penyaman udara dan
mesin basuh terhadap bil elektrik. Beliau merekodkan bilangan jam penyaman udara dan
kekerapan penggunaan mesin basuh untuk 14 hari. Beliau juga memantau meter elektrik
untuk 14 hari tersebut dan mengira penggunaan elektrik setiap hari dalam jam-kilowatt.
Data dipaparkan dalam Jadual 3.
Jadual 3
Penyaman Udara Mesin Basuh Kegunaan
(jam) (kekerapan kegunaan) Elektrik (kwh)
1.5 1 35
4.5 2 63
5.0 2 66
2.0 0 17
8.5 3 94
6.0 3 79
13.5 1 93
8.0 1 66
12.5 1 94
7.5 2 82
8.0 3 78
7.5 1 65
12.0 1 77
6.0 0 75

a) Gunakan Microsoft Excel untuk menghasilkan jadual Analisis Varians untuk regresi
linear berganda dan nyatakan modelnya.
b) Bina ujian hipotesis lengkap untuk menguji sama ada model di (a) adalah sesuai pada
 = 0.05.
c) Bina ujian hipotesis lengkap untuk menguji sama ada pekali regresi, 1 dan 2, adalah
kosong secara signifikasi pada  = 0.05.
d) Berdasarkan jawapan anda di (b) dan (c), nyatakan ringkasan kesimpulan hubungan
linear antara penggunaan elektrik dengan kedua-dua faktor.
[Jumlah: 20 / 60 markah]