Please follow the description shown in the .pdf file.The supplements of the scattered data (.xlsx) is also provided

Please follow the description shown in the .pdf file.The supplements of the scattered data (.xlsx) is also provided


Assignment Software: MATLAB Description: Please use MATLAB to write a program to run polynomial fitting to extract the equation of the three raw data files. Equation form: Y = A0 + a1X + a2X2 + a3X3 + a4X4 +…+ anXn Note that n is the maximum order, this shall be adjustable. (Please mark in the script of MATLAB) Note that A0 must equal to the Y value provided in the raw data where X = 0. For example, for the file “raw_data1.xlsx”, A0 = 1.91652. After the extraction of the polynomial equation, please plot the fitted curve with the scattered points provided in the .xlsx file. The example is shown below in Fig. 1. Fig. 1. Example plotting the scattered and fitted data together. Next, please generate an .xlsx file outputting the raw data with the range of x – [-5,2], and include Y value in the file. Please use the extracted polynomial equation to plot the derivative and second derivative equations of it. The range of x is also set to be from -5 to 2. Y’ = a1 + 2a2X1 + 3a3X2 + 4a4X3 +…+ nanXn-1 Y’ = 2a2 + 6a3X + 12a4X2 +…+ n(n-1)anXn-2 In this work, three plots, one .xlsx and three equations must be generated to fulfill the requirements. Figures: 1. Plot showing the fitted curve with scattered data together 2. Plot the first derivative of the fitted curve at x range from -5 to 2 3. Plot the second derivative of the fitted curve at x range from -5 to 2 .xlsx file to be generated: The raw data of the fitted curve, at x range from -5 to 2, with a step of 0.1 Equations: 1. Fitted polynomial equation with the provided raw data 2. First derivative of the fitted polynomial equation 3. Second derivative of the fitted polynomial equation 工作表1 XY -59.58E-06 -4.9651.71E-05 -4.933.07E-05 -4.8955.52E-05 -4.869.95E-05 -4.8251.79E-04 -4.793.22E-04 -4.7555.75E-04 -4.720.00102 -4.6850.00177 -4.650.003 -4.6150.00491 -4.580.00772 -4.5450.01158 -4.510.01661 -4.4750.0228 -4.440.03011 -4.4050.03843 -4.370.04767 -4.3350.05772 -4.30.06848 -4.2650.07987 -4.230.09181 -4.1950.10423 -4.160.11708 -4.1250.13031 -4.090.14389 -4.0550.15776 -4.020.17191 -3.9850.1863 -3.950.20091 -3.9150.21571 -3.880.2307 -3.8450.24584 -3.810.26113 -3.7750.27655 -3.740.29208 -3.7050.30772 -3.670.32346 -3.6350.33928 -3.60.35518 -3.5650.37115 -3.530.38718 -3.4950.40326 -3.460.41939 -3.4250.43556 -3.390.45176 -3.3550.468 -3.320.48425 -3.2850.50053 -3.250.51683 -3.2150.53315 -3.180.54948 -3.1450.56582 -3.110.58219 -3.0750.59858 -3.040.61501 -3.0050.63149 -2.970.64801 -2.9350.6646 -2.90.68123 -2.8650.69792 -2.830.71464 -2.7950.73139 -2.760.74816 -2.7250.76493 -2.690.78171 -2.6550.79848 -2.620.81524 -2.5850.83198 -2.550.84871 -2.5150.86542 -2.480.8821 -2.4450.89877 -2.410.9154 -2.3750.93201 -2.340.94858 -2.3050.96513 -2.270.98164 -2.2350.99812 -2.21.01456 -2.1651.03096 -2.131.04732 -2.0951.06365 -2.061.07993 -2.0251.09616 -1.991.11236 -1.9551.12851 -1.921.14461 -1.8851.16066 -1.851.17667 -1.8151.19262 -1.781.20853 -1.7451.22438 -1.711.24017 -1.6751.2559 -1.641.27158 -1.6051.28719 -1.571.30273 -1.5351.31821 -1.51.33361 -1.4651.34895 -1.431.36421 -1.3951.3794 -1.361.39451 -1.3251.40955 -1.291.42451 -1.2551.4394 -1.221.45421 -1.1851.46894 -1.151.48359 -1.1151.49817 -1.081.51266 -1.0451.52708 -1.011.54141 -0.9751.55566 -0.941.56983 -0.9051.5839 -0.871.5979 -0.8351.6118 -0.81.62562 -0.7651.63935 -0.731.65299 -0.6951.66655 -0.661.68001 -0.6251.69337 -0.591.70665 -0.5551.71982 -0.521.73291 -0.4851.74589 -0.451.75877 -0.4151.77155 -0.381.78423 -0.3451.7968 -0.311.80927 -0.2751.82163 -0.241.83388 -0.2051.84602 -0.171.85805 -0.1351.86997 -0.11.88178 -0.0651.89347 -0.031.90505 0.0051.91652 0.041.92786 0.0751.93909 0.111.9502 0.1451.96118 0.181.97202 0.2151.98274 0.251.9933 0.2852.0037 0.322.01392 0.3552.02392 0.392.03365 0.4252.04302 0.462.05188 0.4952.06018 0.532.06808 0.5652.07578 0.62.08326 0.6352.09047 0.672.09743 0.7052.10414 0.742.11063 0.7752.1169 0.812.12296 0.8452.12881 0.882.13446 0.9152.13991 0.952.14515 0.9852.15021 1.022.15507 1.0552.15975 1.092.16426 1.1252.16859 1.162.17277 1.1952.17679 1.232.18066 1.2652.18441 1.32.18804 1.3352.19155 1.372.19494 1.4052.19821 1.442.20139 1.4752.20446 1.512.20745 1.5452.21033 1.582.21313 1.6152.21584 1.652.21848 1.6852.22104 1.722.22355 1.7552.22599 1.792.22837 1.8252.23069 1.862.23295 1.8952.23515 1.932.23729 1.9652.23938 22.24141 工作表1 XY -51.39E-12 -4.9652.24E-12 -4.933.63E-12 -4.8955.91E-12 -4.869.66E-12 -4.8251.58E-11 -4.792.59E-11 -4.7554.23E-11 -4.726.86E-11 -4.6851.10E-10 -4.651.75E-10 -4.6152.77E-10 -4.584.41E-10 -4.5457.13E-10 -4.511.17E-09 -4.51.36E-09 -4.4652.28E-09 -4.433.89E-09 -4.3956.71E-09 -4.361.17E-08 -4.3252.04E-08 -4.293.60E-08 -4.2556.40E-08 -4.221.14E-07 -4.1852.06E-07 -4.153.74E-07 -4.1156.83E-07 -4.081.26E-06 -4.0452.35E-06 -4.014.41E-06 -45.29E-06 -3.9651.00E-05 -3.931.92E-05 -3.8953.71E-05 -3.867.19E-05 -3.8251.40E-04 -3.792.73E-04 -3.7555.31E-04 -3.720.00102 -3.6850.00193 -3.650.00352 -3.6150.00613 -3.580.01006 -3.5450.01551 -3.510.02252 -3.50.0248 -3.4650.03368 -3.430.04384 -3.3950.05512 -3.360.06736 -3.3250.08044 -3.290.09422 -3.2550.10863 -3.220.12358 -3.1850.13899 -3.150.15482 -3.1150.17102 -3.080.18753 -3.0450.20433 -3.010.22138 -30.2263 -2.9650.24363 -2.930.26116 -2.8950.27885 -2.860.2967 -2.8250.31469 -2.790.33279 -2.7550.351 -2.720.36929 -2.6850.38767 -2.650.40612 -2.6150.42463 -2.580.44319 -2.5450.46179 -2.510.48042 -2.50.48575 -2.4650.50442 -2.430.52311 -2.3950.54182 -2.360.56055 -2.3250.57931 -2.290.59811 -2.2550.61695 -2.220.63587 -2.1850.65485 -2.150.67392 -2.1150.69305 -2.080.71224 -2.0450.73147 -2.010.75071 -20.75622 -1.9650.77547 -1.930.79471 -1.8950.81394 -1.860.83315 -1.8250.85232 -1.790.87147 -1.7550.89057 -1.720.90964 -1.6850.92867 -1.650.94765 -1.6150.96658 -1.580.98547 -1.5451.0043 -1.511.02307 -1.51.02843 -1.4651.04713 -1.431.06577 -1.3951.08436 -1.361.10287 -1.3251.12133 -1.291.13971 -1.2551.15802 -1.221.17626 -1.1851.19443 -1.151.21251 -1.1151.23051 -1.081.24843 -1.0451.26626 -1.011.28401 -11.28906 -0.9651.30669 -0.931.32423 -0.8951.34168 -0.861.35903 -0.8251.37628 -0.791.39343 -0.7551.41047 -0.721.42742 -0.6851.44425 -0.651.46098 -0.6151.4776 -0.581.49411 -0.5451.5105 -0.511.52679 -0.51.53142 -0.4651.54756 -0.431.56359 -0.3951.57951 -0.361.59531 -0.3251.611 -0.291.62656 -0.2551.64201 -0.221.65733 -0.1851.67252 -0.151.68759 -0.1151.70253 -0.081.71734 -0.0451.73202 -0.011.74656 2.00E-121.75069 0.0351.76505 0.071.77928 0.1051.79336 0.141.8073 0.1751.8211 0.211.83475 0.2451.84826 0.281.86161 0.3151.87482 0.351.88787 0.3851.90078 0.421.91353 0.4551.92612 0.491.93856 0.5251.95084 0.561.96296 0.5951.9749 0.631.98666 0.6651.99822 0.72.00956 0.7352.02065 0.772.0314 0.8052.04172 0.842.05143 0.8752.06042 0.912.06894 0.9452.07721 0.982.08519 1.0152.09284 1.052.10019 1.0852.10725 1.122.11405 1.1552.12059 1.192.12688 1.2252.13293 1.262.13874 1.2952.14431 1.332.14967 1.3652.1548 1.42.15972 1.4352.16443 1.472.16896 1.5052.1733 1.542.17747 1.5752.18148 1.612.18536 1.6452.18909 1.682.1927 1.7152.19617 1.752.19952 1.7852.20277 1.822.20591 1.8552.20894 1.892.21188 1.9252.21472 1.962.21747 1.9952.22013 22.22051 工作表1 XY -51.10E-05 -4.99131.27E-05 -4.95632.26E-05 -4.92134.03E-05 -4.890966.67E-05 -4.873468.93E-05 -4.838461.60E-04 -4.803462.86E-04 -4.781564.10E-04 -4.768925.04E-04 -4.753756.46E-04 -4.7457.44E-04 -4.711.30E-03 -4.6752.23E-03 -4.643.72E-03 -4.6055.98E-03 -4.579.22E-03 -4.5351.36E-02 -4.51.91E-02 -4.492.09E-02 -4.4552.80E-02 -4.423.61E-02 -4.3854.53E-02 -4.355.53E-02 -4.3156.61E-02 -4.287.76E-02 -4.2458.96E-02 -4.211.02E-01 -4.1751.15E-01 -4.141.29E-01 -4.1051.43E-01 -4.071.57E-01 -4.0351.72E-01 -41.87E-01 -3.991.91E-01 -3.9552.06E-01 -3.922.21E-01 -3.8852.37E-01 -3.850.25273 -3.8150.26866 -3.780.28475 -3.7450.30098 -3.710.31733 -3.6750.33379 -3.640.35036 -3.6050.36702 -3.570.38378 -3.5350.40061 -3.50.41752 -3.490.42236 -3.4550.43935 -3.420.4564 -3.3850.4735 -3.350.49065 -3.3150.50784 -3.280.52508 -3.2450.54234 -3.210.55964 -3.1750.57697 -3.140.59432 -3.1050.61169 -3.070.62908 -3.0350.64648 -30.6639 -2.990.66887 -2.9550.6863 -2.920.70373 -2.8850.72117 -2.850.7386 -2.8150.75604 -2.780.77347 -2.7450.7909 -2.710.80832 -2.6750.82573 -2.640.84314 -2.6050.86052 -2.570.8779 -2.5350.89526 -2.50.9126 -2.490.91755 -2.4550.93487 -2.420.95216 -2.3850.96944 -2.350.98668 -2.3151.00391 -2.281.0211 -2.2451.03827 -2.211.05541 -2.1751.07251 -2.141.08958 -2.1051.10662 -2.071.12362 -2.0351.14059 -21.15752 -1.991.16235 -1.9551.17922 -1.921.19606 -1.8851.21286 -1.851.22962 -1.8151.24633 -1.781.263 -1.7451.27964 -1.711.29623 -1.6751.31278 -1.641.32929 -1.6051.34577 -1.571.3622 -1.5351.3786 -1.51.39497 -1.491.39964 -1.4551.41596 -1.421.43224 -1.3851.44849 -1.351.4647 -1.3151.48087 -1.281.49701 -1.2451.5131 -1.211.52915 -1.1751.54516 -1.141.56112 -1.1051.57703 -1.071.5929 -1.0351.60872 -11.62448 -0.991.62897 -0.9551.64467 -0.921.6603 -0.8851.67588 -0.851.69139 -0.8151.70683 -0.781.72221 -0.7451.73752 -0.711.75275 -0.6751.7679 -0.641