pls help asap i need to know step by step what formulas to plug in for #15
15. Complete the Analysis section using formulas with statistical functions. Use nared ranges instead of cell references in the formulas a. Price b.MPG City COMPG Highway d. Horsepower e. Torque 1. Maintenance/Year 9 Insurance/Year h. Amount to Borrow 1. APR J. D Years kLoan Payment 1. Gas m. Maintenance/Month n. Insurance/Month o. Total Monthly Hint: Select colls B6:F30 and use Excel's Create from Selection command to create named ranges for each row using the labels 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 in the label names are converted to _characters in the namos. Hint: To avoid typos as you create each formula, try using Formula Autocomplete to select the correct range namo. Truck Purchase Truck 2 Analysis Truck 1 Truck 3 Truck 4 Description 2015 Chevrolet Colorado 2019 Dodge Ram 1500 2019 Toyota Tacoma 2019 Chevrolet Silverado Sailer Het Low dele 534.990 pre $27007 private $12.995 537,95 Cinder Price MG MOHwy Hormowy Horn Torque wins MEGY 35.7 395 410 4500 15 21 13 6000 16 10 12 A 42 150 180 1800 19 24 215 Cinder 159 360 5500 16 22 19 Maintenance hrane AMO vehide Safety Amount to Be APA Year 5600 Yearly Costs Maintenance Heine insurance Need Loan? Ana B AR 5700 160 31200 5160 $200 $160 5600 5500 $160 5950 5800 VALUE VALUE G Manca/Month C/Month Total Moth $27.990 120N 3 3.60% 5 522.097 SOON > $12.995 SOON 2 Monthly Costs Loan Payment Mind Moth Insurance Month Total Monthly 578125 SODI $0.78 50.00 $7,20204 WVALUE INVALUE 550.00 $66 67 EVALUE 55.746.62 50.00 $1557 $50.00 55.76329 $3,379.52 5000 54167 5717 53.40119 10 Affordable yet ver 13 15. Complete the Analysis section using formulas with statistical functions. Use nared ranges instead of cell references in the formulas a. Price b.MPG City COMPG Highway d. Horsepower e. Torque 1. Maintenance/Year 9 Insurance/Year h. Amount to Borrow 1. APR J. D Years kLoan Payment 1. Gas m. Maintenance/Month n. Insurance/Month o. Total Monthly Hint: Select colls B6:F30 and use Excel's Create from Selection command to create named ranges for each row using the labels 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 in the label names are converted to _characters in the namos. Hint: To avoid typos as you create each formula, try using Formula Autocomplete to select the correct range namo. Truck Purchase Truck 2 Analysis Truck 1 Truck 3 Truck 4 Description 2015 Chevrolet Colorado 2019 Dodge Ram 1500 2019 Toyota Tacoma 2019 Chevrolet Silverado Sailer Het Low dele 534.990 pre $27007 private $12.995 537,95 Cinder Price MG MOHwy Hormowy Horn Torque wins MEGY 35.7 395 410 4500 15 21 13 6000 16 10 12 A 42 150 180 1800 19 24 215 Cinder 159 360 5500 16 22 19 Maintenance hrane AMO vehide Safety Amount to Be APA Year 5600 Yearly Costs Maintenance Heine insurance Need Loan? Ana B AR 5700 160 31200 5160 $200 $160 5600 5500 $160 5950 5800 VALUE VALUE G Manca/Month C/Month Total Moth $27.990 120N 3 3.60% 5 522.097 SOON > $12.995 SOON 2 Monthly Costs Loan Payment Mind Moth Insurance Month Total Monthly 578125 SODI $0.78 50.00 $7,20204 WVALUE INVALUE 550.00 $66 67 EVALUE 55.746.62 50.00 $1557 $50.00 55.76329 $3,379.52 5000 54167 5717 53.40119 10 Affordable yet ver 13
