B( ii)

The owners of Oheneba car yard are concerned with their declining sales over the past few months. As a result they want to determine whether there is a difference in the motivation of sales staff paid on an hourly rate plus commission or on commission only (but at a higher percentage rate). Of 24 randomly selected newly trained sales staff, 12 were paid at an hourly rate and 12 on a commission basis only. The following data represent the sales in volume (in thousands of dollars) achieved during the first month on the job.

Hourly rate. commission

147 330

224. 472

118. 195

209. 489

126. 386

372. 462

197. 509

260. 312

372. 227

451. 325

447. 518

328. 476

REQUIRED

A) Input this data in SPSS 4 marks

B) Draw the bar chart showing the relationship between hourly rate and commission given to employees 4 marks

C) Generate the following descriptive statistics; mean, median and mode

D) Analyse with appropriate statistical tool to determine whether there is any difference in the sales volume of the two motivational methods. Ensure to save both data and output files to be collected at the end of the exam.

E) Write a full report with recommendation to management of Oheneba car on the relationship you found in D) above and what strategies it should take .