QUESTION 13 marks

A university lecturer at a large private university took a random sample of 55 students from her first-year Business Data Analysis course.She wishes to investigate the relation between the number of hours students spend on casual employment per week and marks attained in the most recent assessment item.For each student, the number of hours worked per week and marks attained were recorded.The data are stored in 'HoursMark55' worksheet in the xls. data file attached.

In addition, students were also asked to respond to survey questions concerning other variables (e.g. major of study chosen, suburb where student lives, country of origin, etc).The lecturer categorised the data collected on the variable suburb where student lives into ten suburbs, and calculated the frequencies as presented in the table below.

Suburb

Category

Frequency

Suburb A

3

Suburb B

9

Suburb C

7

Suburb D

6

Suburb E

8

Suburb F

7

Suburb G

5

Suburb H

5

Suburb I

2

Suburb J

3

Using the information presented in the table above, answer the following questions.

(a)Which graphical technique would you use for making comparison in the number of students in each suburb?Explain your reasoning in selecting this graphical chart.Using Excel, construct and present the chart.1.5 marks

(b)Which graphical technique would you use for making comparison of the proportion of the number of students in each suburb? Explain your reasoning in selecting this graphical chart.Using Excel, construct and present the chart.1.5 marks