(Solved): Please Solve these question with Excel and show the steps, I need to do it on Excel Objective: ...

Please Solve these question with Excel and show the steps, I need to do it on Excel

Objective: Determine the value and location of the maximum deflection for a simply supported beam loaded by a triangular load as shown. Formulation: $$y(x)=\frac{w_0}{120EIL}\left(?x^5+2L^2{x}^3?L^{4}x\right)$$ where $$\mathrm{y}$$ is the deflection of the beam $${\mathrm{w}}_0$$ is the intensity of the load $$\mathrm{E}$$ is elastic modulus of the beam $${\mathrm{I}}_{\mathrm{z}}$$ is the moment of inertia for the beam $$\mathrm{L}$$ is length of the beam Given data $${\mathrm{w}}_0=2\mathrm{kN}/\mathrm{m}$$ (neglect self weight of the beam) $$\mathrm{L}=4.5\mathrm{m}$$ $$\mathrm{E}=200\mathrm{N}/{\mathrm{mm}}^2$$ $${\mathrm{I}}_{\mathrm{z}}=849\times 10^6{\mathrm{mm}}^4$$