Question 1. Write a program that imports the data from the first excel sheet and plot each data set on the same plot. Create another program that plots all the data on its own graph but in the same window. Remember to include titles, legends, and axes labels.
Question 2. Write a program that will read the data from the second tab. Use polyfit to create a linear best fit line. Calculate the R2 value for fit. Plot both the individual data points (red) and the fit line (blue) on the same graph. Include a title and axis labels.
Question 3. Use a matlab script to solve the following set of equations using the Ax = b → x = A\b matrix notation.
40 = -5a + 10b + 6c + 3d + 1e
33.25 = 5b + 1/2c - 2d + 8e
43.5 = 3 - 4a + 9d + 6b
41 = 7a + b + 8c + 4d - e
0 = 2a + 6c - 3d - 7e + 15.5
Load the .mat file to complete questions 4 & 5. Use Matlab in the computer labs to complete question 5.
Question 4. Use one of the 3D plotting functions that we discussed to graph variable A.
Question 5. Use the curve fitting tool to find equations for the data sets x,y and x2,y2 (separately). Keep in mind the correct type of fit may not be polynomial. Take screen shots of the solution you select for each and include in the submission.