Part B

Create a formula in Excel to complete the following conversions, as separate columns, and copy the formula down the length of column A in #$1,$ to convert all the values in the table to the requested units in #$2-5.$

$2.$ In Column B$,$ convert the weights in Column A from Newtons to pounds $($Ibs$).$

$3.$ In Column C$,$ convert the weights in Column A from Newtons to mass $($SI units of kilograms$).$

$4.$ In Column D$,$ convert the mass in Column C from kilograms to slugs.

$5.$ In Column E$,$ convert the weights in Column D from slugs to pounds.

Part C

$6.$ Compare your values in Columns B and E$.$ They should be the same, to one decimal place. If not, inspect your equations$/$conversions and describe the error$($s$)$ you find.

A

B

C

D

E

F

$1$ Weight

$($N$)$

$\backslash$table$[[2,100],[3,150],[4,200],[5,25\mathrm{.}48],[6,34\mathrm{.}96],[7,56\mathrm{.}2],[8,350],[9,400],[10,450],[11,500]]$

$$

$\backslash$table$[[\backslash$table$[[$Weight$],[($N$)]]],[100],[150],[200],[250],[300],[350],[400],[450],[500]]$

Part B

Create a formula in Excel to complete the following conversions, as separate columns, and copy the formula down the length of column $A$ in #$1,$ to convert all the values in the table to the requested units in #$2-5.$

$2.$ In Column B$,$ convert the weights in Column A from Newtons to pounds $($lbs$).$

$3.$ In Column C$,$ convert the weights in Column A from Newtons to mass $($SI units of kilograms$).$

$4.$ In Column D$,$ convert the mass in Column C from kilograms to slugs.

$5.$ In Column E$,$ convert the weights in Column D from slugs to pounds.

Part C

$6.$ Compare your values in Columns B and $E.$ They should be the same, to one decimal place. If not, inspect your equations$/$conversions and describe the error$($s$)$ you find.