question 3 (15 marky) A company aims to askess the henelit they obain in erms of is reverwe from whes as provides data for revenues in thousauts of dellars from wales and widvenisite Pidage Remark: The value Ni is the ith digit of your to-digit number. ther example, if your 10-digit number is 5697483715 , the table should be upsived to. 3.1. (1 mark) Write down your 10-digit number. 3.2. (1 mark) Update the table using your specific Ni values. 3.3 5 marks) The aim is to use linear regression and to find a linear function in the form of y=ax+b to fit these data. In particular. provide a convex optimization formulation for this regression with an objective to find the optimal values for a and b using the least squares method. The objective 3.4. (8 marks) Solve the convex optimization problem formulated in sub-question a and b using in two ways: (1) using Excel Solver and (2) obtain the optimal values of a and be usin (2). the analytical solution by Excel and observe the consistency Canvas. question 3 (15 marky) A company aims to askess the henelit they obain in erms of is reverwe from whes as provides data for revenues in thousauts of dellars from wales and widvenisite Pidage Remark: The value Ni is the ith digit of your to-digit number. ther example, if your 10-digit number is 5697483715 , the table should be upsived to. 3.1. (1 mark) Write down your 10-digit number. 3.2. (1 mark) Update the table using your specific Ni values. 3.3 5 marks) The aim is to use linear regression and to find a linear function in the form of y=ax+b to fit these data. In particular. provide a convex optimization formulation for this regression with an objective to find the optimal values for a and b using the least squares method. The objective 3.4. (8 marks) Solve the convex optimization problem formulated in sub-question a and b using in two ways: (1) using Excel Solver and (2) obtain the optimal values of a and be usin (2). the analytical solution by Excel and observe the consistency Canvas