Can anyone help me to solve this homework by using excel please? Thank You

1. Use goal seek to solve the following expressions, (a) y = cos(x) | If y = 0.707107, find the numerical solution for x in degrees.

(b) y = c₁x² + c₂x + c₃ | If y = 10, c1 = e, c₂ = , and c₃ = 0, find the numerical solution for x.

(c) y = ce^x | If y = 106 and c = 2.5, find the numerical solution for x.

2. Use goal seek to determine the interest rate needed to finance a car priced at $32,000 for 5 years with payments of $550 per month. The payment formula is Payment = , where r is the interest rate, n is the number of payment periods, and V is the principal value of the loan.

3. Using goal seek, determine how long it will take a savings account to grow from $1,000 to $10,000 at a %2.05 interest rate. The savings interest formula is Savings = , where i is the interest rate, t is the number of years in savings, and P V is the initial deposited in savings.

4. A tank is to be constructed that will hold 600m3 of material when filled. The shape is to be cylindrical, with a hemispherical top. Costs to construct the cylindrical portion will be $200/m2 , while costs for the hemispherical portion are slightly higher at $300/m2 . Using Excel Solver, find the tank dimensions that will result in the lowest dollar cost. The equations for volume and surface area are given below, V_total = R²H +

SA_total = 2RH + 2R² .

6. A car company is designing a gas tank that can hold 70 liters of fuel. The length of the tank needs to be 3 times the width, and must be less than or equal to 0.5 meters in depth. The cost of the material used to make each side is $50/m2 . Use Excel Solver to find the tank dimensions that will result in the lowest dollar cost. The equations for volume and surface area are given below, V_total = lwh SA_total = 2lw + 2lh + 2wh

Vu 2 r(PV)) 1-(1+r)-n PV (1 + i) 273 3 h w Figure 2: Reference figure for problem 6. L- 2R R Figure 1: Reference figure for problem 5. 5. A fenced enclosure consists of a rectangle of length L and width 2R and a semicircle of radius R, as shown in Fig. The enclosure is to be built to have an area A of 2000 ft? The cost of the fence is $50 per foot for the curved portion and $40 per foot for the straight sides. Using Excel Solver, find the fence dimensions that will result in the lowest dollar cost. The equations for surface area and perimeter are given below, 7T SAtotal Ptotal R2 2RL + 2 L2R+2+TR