Assignment details You are required to solve the optimisation problems below. You should produce a typed report of maximum length 4 pages. All questions must be answered in Excel, with the relevant spreadsheet(s) appended to your report as an appendix. Your report does not have to include an abstract, introduction, conclusions section etc. You are required to answer the questions. In answering each question, you should, 1. Formulate the optimisation problem; in other words, define the objective function and any associated constraints drawing on any relevant background theory, 2. Discuss the Excel implementation, 3. Show, discuss and analyse your results using any appropriate figures. Question 1 Given the following experimental data, Time, t (h) Weight, w (kg) 0.314 0.017 0.10 0.479 0.183 0.671 0.267 0.718 0.350 1.026 0.433 4.857 0.517 1.513 3.105 0.60 0.683 3.666 0.767 5.069 The following regression models have been proposed to develop a relationship between time and weight, w = exp(a] + @2 " t) w = exp(@1 + @2 . t + ag · t2) W= @1 .tªz What are the various model parameters and which model would be the most appropriate? Marking Criteria - Formulate the optimisation problem (equations and words) - Show spreadsheet implementation - professionally constructed, logical input output structure, results clearly demonstrated, model performance metrics quantified. - Discussion and quantification of model accuracy. Consideration of model performance statistics and arriving at appropriate choice of model structure. [25 marks]

Fig: 1