i need help computing the formulas for section.

IIHS Safety Rating Lookup Chart Large and Small Pickups 15. Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the formulas. a. Price b. MPG City c. MPG Highway d. Horsepower e. Torque 1. Maintenance/Year 9. Insurance/Year h. Amount to Borrow 1. APR j. Years k. Loan Payment 1. Gas m. Maintenance/Month n. Insurance/Month o. Total Monthly - Hint: Select cells B6:F30 and use Excel's Create from Selection command to create named ranges for each row u at the left side of the range as the names. - Hint: Open the Name Manager and review the names Excel created. Notice that any spaces or special characters names are converted to characters in the names. - Hint: To avoid typos as you create each formula. try using Formula AutoComplete to select the correct range name