Mathematics Major Assignment

MAT-144-RS-ONL-T2-MajorAssignment1ExcelOnline20250317.xlsx

Home >Mathematics homework help >Mathematics Major Assignment

Grading Sheet

		Major Assignment 1 Grading Sheet (03/17/2025)
	Competency	Requirements for full credit	(optional for student use) Did you meet the requirements?	Points possible	Your points	Scoring comments
Income Analysis	Name	You have entered your full name in the field provided. (Note that entering your name on this sheet is required in order to complete your other sheets.)		1
	Best-Fit Line and Predicted Incomes	You have correctly calculated the slope and y-intercept for the data provided, using appropriate Excel functions (6 points). You have formatted your slope and intercept as Number with 0 decimals (1 point).		7
		Your formulas for Average Weekly Incomes are correct, using cell references for the slope, y-intercept, and years of education (6 points). You have formatted these entries as Currency with 0 decimals (1 point).		7
	Scatter Plot	You have included an XY-Scatterplot of the BLS data (3 points), adding an appropriate title and axis labels (3 points).		6
		You have added a trendline to your scatterplot (1 point), extending it to 8 years on the left and 24 years on the right (1 point).		2
			Subtotals	23	0
Unit Conversions	Unit Conversions	You have identified the correct units for your final quantities, using the units abbreviations (including capitalization) provided in the conversion factors table. (1 point each)		4
		You have identified the conversion ratios to use, using correct units abbreviations from the table (including capitalization). (1 point each)		10
		Your formulas for the ratios are correct, using appropriate cell references. (2 points each)		20
		Your final quantity formulas are correct and use cell references for all inputs. (2 points each)		8
	Temperature Conversions	Your Fahrenheit to Celsius conversion formulas are correct and use cell references. The calculations are direct and do not use built-in Excel functions. (2 points each)		4
			Subtotals	46	0
Currency Conversions	Currency Conversions	You have entered the first two letters of your first and last names, using the letter M if one or both names consist of only one letter. (1/2 point each)		2
		You have chosen appropriate countries from the list provided below the table, using the procedure described in the instructions. (1/2 point each)		2
		You have entered the date(s) on which you looked up the exchange rates for your currencies, and this date is within 2 weeks of the due date of your assignment.		2
		You have entered the correct currency codes for your countries. (1 point each)		4
		You have provided each exchange rate to at least 3 significant digits. (1 point each)		4
		The trip budget in the foreign currency is a correct Excel formula, using cell references. (2 points each)		8
		Your calculation of the value of the foreign currency units into dollars is a correct Excel formula, using cell references. (2 points each)		8
		The cells containing the date, exchange rate, trip budget, and value of foreign currency are correctly formatted as specified in the last column of the table.		4
			Subtotals	34	0
			Totals	103	0
			Percentage	100.00%	0.00%
			Score out of 100	100.00	0.00

Income Analysis

1 Enter your name here. If your full name is less than 5 letters long, add additional letters 'X' at the end until you reach length 5.
2 On this sheet, you will investigate the relationship between years of education and average income. First, consider the following BLS Data chart of Years of Education versus Average Weekly Income. Below it, use Excel functions to find the slope and y-intercept of the best-fit line for the given coordinates. Then, to the right, use the slope and y-intercept to calculate the Average Weekly Incomes for all years of education from 8 through 24. Finally, create a chart showing the BLS Data as a scatterplot, and add an auto trendline to this chart showing years of education versus predicted average income superimposed on the BLS data and forecasting backward to 8 years and forward to 24 years. (That is, the line should start at 8 years and end at 24 years on the horizontal axis.) Here, you should format your slope and y-intercept as Numbers with 0 decimal places and your Average Weekly Incomes as Currency with the $ symbol and 0 decimal places. In case you'd like to explore the data, numbers here are derived from Bureau of Labor Statistics figures at https://www.bls.gov/emp/tables/unemployment-earnings-education.htm. However, you don't need to take any steps related to this reference for the assignment.				Assignment Advisory: You must use the latest desktop version of Excel for Microsoft 365 for this assigment. (This is provided free by GCU; contact the Help Desk for more information and help installing the software.) Using an earlier version of Excel or a different spreadsheet program may result in missing or corrupted template elements. Copying cells from or into this template may likewise result in corrupted data.
					Legend
					If a cell is shaded	You should
					Blue	Enter a text response
					Green	Enter a number
					Gold	Enter an Excel formula
					Any other color	Make no changes
BLS Data		Predicted Incomes Based on Best Fit
Years of Education (X)	Average Weekly Income (Y)	Years of Education (X)	Average Weekly Income (Y = m*X + b)
10	Enter your name in B1	8		3 Below, insert an XY-scatterplot of the BLS Data in columns A and B (not the predicted data in columns D and E). To that add a trendline forecasting backward to 8 years and forward to 24 years. (That is, the line should start at 8 years and end at 24 years on the horizontal axis.) Be sure to include an appropriate chart title and axis titles on the chart.
12	Enter your name in B1	9
13	Enter your name in B1	10
14	Enter your name in B1	11
16	Enter your name in B1	12
18	Enter your name in B1	13
19	Enter your name in B1	14
20	Enter your name in B1	15
		16
Best-Fit Line Parameters		17
		18
Slope (m)		19
Y-Intercept (b)		20
		21
		22
		23
		24

Unit Conversions

4 On this sheet, you will consider several conversions related to calculations you might see in a professional context. For each conversion, identify and apply appropriate ratios to yield the given result. Remember that you should order ratios so that units cancel in the numerator and denominator for intermediate steps. First, examine the Conversion Factor Table; you will use conversion factors from this table in your formulas in part 5. Note if you use a ratio of the Second Units over the First Units, then your multiplier will include a cell from column L over a cell from Column I; on the other hand, if you use a ratio of the First Units over the Second units, then your multiplier will include a cell from column I over a cell from Column L. For example, when multiplying by lb/kg, you would multiply by L9/I9; when multiplying by kg/lb, you would multiply by I9/L9.

Legend

If a cell is shaded

You should

Blue

Enter a text response

Green

Enter a number

Gold

Enter an Excel formula

Any other color

Make no changes

Conversion Factor Table

5 Use entries from the conversion table on the right to perform the following conversions. Note that you may only use entries from the Conversion Factor Table to the right, even if a more direct conversion is possible (do NOT use CONVERT()). For each part, the number of ratios required is shown in the table. Each ratio formula in the gold cells must include an Excel formula with cell references. In the blue cells, enter the ratio of units that you multiplied by for each conversion. Use the abbreviations provided in the table, including capitalization as given. No special formatting is required.

Quantity of

First Units

Conversion Factor

Second Units

kilogram (kg)

2.2046

pounds (lb)

fluid ounce (floz)

29.5735

milliliter (mL)

ounce (oz)

28.3495

gram (g)

kilogram (kg)

1000

gram (g)

1000

milligram (mg)

1000

microgram (mcg)

liter (L)

33.8140

fluid ounces (floz)

liter (L)

0.2642

gallons (gal)

teaspoon (tsp)

4.9289

milliliter (mL)

meter (m)

3.2808

feet (ft)

foot (ft)

inches (in)

inch (in)

2.54

centimeters (cm)

mile (mi)

5280

feet (ft)

day (d)

hours (h)

year (yr)

365

days (d)

Initial quantity and units

First ratio and units

Second ratio and units

Third ratio and units

Final quantity and units

Example: Convert fluid ounces per kilogram to milliliters per pound

floz/kg

29.5735

mL/floz

0.4536

kg/lb

939.0031

mL/lb

A) Convert miligrams per milliliter to micrograms per teaspoon