3) When answering Questions 6, you're required to demonstrate detailed Excel workout steps and summary output wherever it is necessary

Question 6 Delivery Express is an independent distribution firm and a major portion of its business involves deliveries throughout its local area. To develop better work schedules, the managers want to estimate the total daily travel time for their drivers. No Distance travelled (km) Number of deliveries Travel time (hours) 1 100 4 9.3 2 50 4.8 3 100 8.9 4 100 NNN A W 6.5 5 50 4.2 6 80 6.2 7 75 7.4 8 65 6.0 NW A W 9 90 7.6 10 90 6.1 6.1) Perform multiple regression modeling in Excel with Travel time as the dependent variable (10 marks) 6.2) Find out and explain the 'coefficient of multiple determination' from Excel summary output (5 marks) 6.3) Find out and explain the 'significance of regression coefficients' from Excel summary output (5 marks) 6.4) Explain the assumptions made when estimating multiple regression (12 marks) 6.5) Explain the possible drawbacks associated with using Excel