how do I solve my conversion assignment its needing a formula for the first ratio second and third ration and is also need for the units too and at the bottom its need a formula for the Fahrenheit and Celsius onto and excel sheet. I appreciate the help.
C D / On this sheet, you will consider several conversions related to calculations you might see in a professional context. For each conversion you'll identify and apply appropriate ratios to yield the given result. Remember that ratios can use either unit over the other, and that you should order ratios so that units cancel in the numerator and denominator for intermediate steps. 6 First, examine this conversion factor table; you will use conversion factors from this table in your formulas in part S. Note that if you use a ratio 7 of the Second Units over the First Units, then your multiplier will be the conversion factor itself; on the other hand, if you use a ratio of the First Units over the Second units, then your multiplier will be 1 divided by the conversion factor for example, when multiplying by it/kg you would 8 multiply by D12; when multiplying by kg/lb, you would multiply by 1/D12. Conversion Quantity of First Units Factor Second Units 11 12 1 kilogram [kg) 2.20462 pounds (Ib) fluid ounce (floz) 29.5735 milliliter (ml) fa cell is shaded You should 13 Enter a text 1 ounce [ oz) 28.3495 gram (g) Blue 14 response 15 1 kilogram (kg) 1000 gram (g) Enter a number Enter an Excel 1 gram (a) 1000 milligram ( ma) Gold 16 formula 17 1 milligram (mg) 1000 microgram (mcg) Any other color | | | make no changes 18 1 liter (L) 33.8140 fluid ounces ( floz) 19 1 liter (L) 0.2642 gallons (Ball 1 11 11 11 11 11 20 1 teaspoon [tsp) 4.9289 milliliter (inL) 21 1 meter (m) 3.2808 feet ( full 22 1 day (d) 24 hours [h) 23 24 Now, use entries from the conversion table to perform the following conversions. Note that you may use entries only from the table above, 25 even if a more direct conversion is possible. For each part, the number of ratios required is shown in the table. Note that your ratios for the 26 formulas may be either one of the conversion factors above (like =F10) or the reciprocal (like =1/F), as illustrated in the example. No special 27 formatting is required for the cells containing your formulas. In the blue cells, enter the ratio of units that you multiplied by for each conversion. 23 You should use the abbreviations provided above, including capitalization as given. 20 Example: convert fluid ounces per A) Convert milligrams per liter to B) Convert grams per hour to () convert square feet per gallon to D) Convert milliliters per kilogram to milliliters nar bound micrograme ner fluid nunes. kilograms bar law square meters per liter (hint: one kilogram per hour to Grading Sheet Monthly Budget Income Analysis ConversionsE - Calibri - 11 - AA 82 Wrap Text General ZY Delete Conditional Format as Cel Soft & Find & Analyze Paste BIU- CA 96 Formatting Forrat Filter Select ~ Data Analysis Clipboard Font Alignment Number Style: Cells Faiting B51 X v A B D 21 meter (m) 3.2803 feet (ft) 22 day (d) 24 hours (h) 23 8 Now, use entries from the conversion table to perform the following conversions. Note that you may use entries only from the table above, even if a more direct conversion is possible. For each part, the number of ratios required is shown in the table, Note that your ratios for the formulas may be either one of the conversion factors above (like =F10) or the reciprocal (like =1/F9), as illustrated in the example. No special formatting is required for the cells containing your formulas. In the blue cells, enter the ratio of units that you multiplied by for each conversion. You should use the abbreviations provided above, including capitalization as given. 29 Example: convert fluid ounces per A) Convert milligrams per liter to [) Convert square feet per gallon to D) Convert milliliters per B) Convert grams per hour to square meters per liter (hint: one kilogram per hour to kilogram to milliliters per pound micrograms per fluid ounce kilograms per day 30 conversion factor is applied twice) teaspoons per pound per day Initial quantity and 10 floz/kg 50 mg/L 20 g/h 5000 ftaz/gal 30 mL/(kgth) 31 units to convert from 32 X 33 First ratio and units 29.5735 mt/floz 3.2808 4.9289 34 35 Second ratio and units 0.453592909 kg/lb 3.785411784 0.001 36 37 Third ratio and units 0.30479999 2.20462 38 Final quantity and units 134.1432991 mL/16 39 to convert to 0.052631579 0.453592905 40 Some conversions use ratios plus another additive term (summand). Here, you'll convert from Fahrenheit to Celsius and from Celsius to Fahrenheit, 12 using the following symbolic formulas: 43 Celsius to Fahrenheit: F = (9/5) FC + 32 Fahrenheit to Celsius: C = (5/9)+(F - 32) Use formulas to populate the two empty cells below. No special formatting is required for your cells here. 49 50 Fahrenheit 43 Celsius Grading Sheet Monthly Budget Income Analysis Conversions EnterShare Comme File Home Insert Page Layout Formulas Data CVIEW E- AY O Calibri -HI AA ce Wrap Text Gen Conditional |Format as Sort & Find & Arialyze Data Paste BIU- Formatting ~ Filter ~ Select Editing Analysis Clipboard Font A1 S B D E 30 31 32 33 34 35 Sheet1 Ready
