Write in Words and Excel too. TQ

Soalan/ Question 1 Dalam satu sesi temuduga terbuka, seramai 164 orang siswazah sains sosial telah ditemuduga. Maklumat dikumpulkan termasuk ijazah yang diperolehi dan bidang pekerjaan yang dipilih. Maklumat ditunjukkan dalam jadual berikut. In an open interview session, 164 social science graduates were interviewed. The information collected includes the degree obtained and the chosen field of employment. Information shown in the following table. Bidang Pekerjaan/ Field of work Ijazah yang diperolehi/ Degree obtained B.Ec B.Acc B.A Pendidikan/ Education 11 6 8 Ekonomi dan Kewangan/ Economics & Finance 32 14 17 Pemasaran/ Marketing 13 11 18 Perakaunan/ Accountancy 9 17 8 a. Tuliskan hipotesis Nul dan hipotesis Alternatif untuk menguji samada bidang pekerjaan bergantung kepada ijazah yang diperolehi. (Gunakan aras keertian 5%) State the Nul hypothesis and the Alternative hypothesis to test whether the field of work depends on the degree obtained. (Use 5% significance level) (1 markah/ marks) b. Tentukan nilai ujian statistik dan nilai kritikal. Determine the statistical test and critical values. (4 markah/ marks) C. Berikan keputusan ujian dan rumusan yang boleh dibuat berkaitan ijazah diperolehi dan bidang pekerjaan dipilih oleh siswazah sains sosial. State the decision and conclusion that can be made in relation to the degree obtained and the field of employment selected by the graduates of social sciences (1 markah/ marks) (Jumlah/Total: 6 markah/ marks)