Question: the equation i put in excel is wrong how do i fix it? what numbers do i put in. Hint: Unlike the Revenue spreadsheet used


Hint: Unlike the Revenue spreadsheet used in the workshop, this spreadsheet has more recent years at the top of the table and older years at the bottom. Your math equation needs to be adjusted to calculate a difference between years (newer year older year), then divide by the older year. Question 5 ( 1 point) What is the value in cell E36? a) 0.5% b) 6.8% c) 13.5% d) 4.0% c) 13.5% d) 4.0% e) 9.2% f) 12.8 g) 11.9 Hide hint for Question 5 Percent is calculated as a difference between years (newer year - older year), then divide by the older year. A positive value indicates growth, and a negative value indicates decline. Use the linear interpolation formula yy0+(y1y0)(x1x0xx0) Substitute in column 827 as follows: y=827
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
