Question: Create a spreadsheet with a height/weight comparison using the formula/equation: 3w + 100 = 1 1(h-20) where w is measured in pounds and h is

Create a spreadsheet with a height/weight comparison using the formula/equation: 3w + 100 = 1 1(h-20) where w is measured in pounds and h is measured in inches. Height should be from 4'11" through 6'5" in one column with the corresponding weight formula in the next column. Remember the height must be converted to inches in the formula, but I want feet and inches in the first column so that someone using the chart does not have to make the conversion. Weight should be 2 decimal places. (Hint: You must solve formula for weight before entering formula in cell box, then click and drag.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
