Copy of Major Assignment 1 publish

xlsx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

0500

Subject

Statistics

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by CommodoreGazelle3907

Student BLS Data Predicted Incomes Based on Best Fit 10 $649.00 8 $235 12 $814.00 9 $378 13 $898.00 10 $521 14 $949.00 11 $663 16 $1,347.00 12 $806 18 $1,549.00 13 $948 19 $1,998.00 14 $1,091 20 $1,949.00 15 $1,233 16 $1,376 Best-Fit Line Parameters 17 $1,519 18 $1,661 Slope (m) 143 19 $1,804 Y-Intercept (0, b) -905 20 $1,946 21 $2,089 22 $2,232 23 $2,374 24 $2,517 1 Enter your name here. 2 On this sheet, you will investigate the relationship between years of education and average income. First the following chart of education versus average income. Below it, use Excel functions to find the slope and y of the best-fit line for the given coordinates. Then, to the right, use the slope and y-intercept to calculate th weekly income 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 inco superimposed on the BLS data and forecasting backward to 8 years and forward to 24 years. (That is, the lin 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 wee 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 related to this reference for the assignment. Years of Education (X) Average Weekly Income (Y) Years of Education (X) Average Weekly Income (Y = m*X + b)

Legend If a cell is shaded You should Blue Green Enter a number Gold Any other color Make no changes 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. t, consider y-intercept he average a ome ne should ekly e any steps Enter a text response Enter an Excel formula 3 Add your chart here with an appropriate title and axis labels: an XY-scatterplot of the BLS Data in columns A and B (NOT the data in columns C and D) plus an auto trendline forecasting backward to 8 years and forward to 24 years (not periods).

Initial quantity and units x First ratio and u 19 floz/kg x 29.5735 28 mg/L x 1000 45 g/h x 0.001 70 ft^2/gal x 0.3047999902464 70 mL/(kg*h) x 0.202884201812973 4 On this sheet, you will consider several conversions related to calculations you might see in a yield the given result. Remember that you should order ratios so that units cancel in the numera First, examine this conversion factor table; you will use conversion factors from this table in you Note if you use a ratio of the Second Units over the First Units, then your multiplier will include the First Units over the Second units, then your multiplier will include a cell from column P ove For example, when multiplying by lb/kg, you would multiply by S3/P3; when multiplying by kg 5 Now, use entries from the conversion table to perform the following conversions. Note that y CONVERT()). For each part, the number of ratios required is shown in the table. Note that each units that you multiplied by for each conversion.You should use the abbreviations provided abov decimal places. Example: convert fluid ounces per kilogram to milliliters per pound A) Convert milligrams per liter to micrograms per fluid ounce B) Convert grams per hour to kilograms per day C) Convert square feet per gallon to square meters per liter (hint: one conversion factor is applied twice) D) Convert milliliters per (kilogram-hour) to teaspoons per (pound-day) 6 Here, you'll convert from Fahrenheit to Celsius and from Celsius to Fahrenheit, using the following s Celsius to Fahrenheit: F = (9/5)*C + 32 Fahrenheit to Celsius: C = (5/9)*(F - 32) Use formulas to populate the two empty cells below: specifically, you should convert the value from Fah special formatting is required for your cells here.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

-13.365 °F 6.569 °F -25.203 °C -14.128 °C Fahrenheit Celsius

units x Second ratio and units x Third ratio and units = mL/floz x 0.4536 kg/lb x = mcg/mg x 0.029573529651571 L/floz x = kg/g x 24 h/d x = m/ft x 0.3047999902464 m/ft x 0.264172052358 gal/L = tsp/mL x 0.45359290943564 kg/lb x 24 h/d = a professional context. For each conversion, you'll identify and apply appropriate ratios to ator and denominator for intermediate steps. ur formulas in part 5. e a cell from column S over a cell from Column P; on the other hand, if you use a ratio of er a cell from Column S. g/lb, you would multiply by P3/S3. you may use entries only from the table above, even if a more direct conversion is possible (do N h of your ratio formulas will include cell references, as illustrated in the example. In the blue ce ve, including capitalization as given. Format your cells containing your ratios and your final an symbolic formulas (do NOT use CONVERT()): hrenheit in B31 to Celsius in B32 and from Celsius in C32 to Fahrenheit in C31 . No

Legend If a cell is shaded You should Quantity of First Units = Conversion Factor Blue 1 kilogram (kg) = 2.2046 Green 1 fluid ounce (floz) = 29.5735 Gold 1 ounce (oz) = 28.3495 Any other color 1 kilogram (kg) = 1000 1 gram (g) = 1000 1 milligram (mg) = 1000 1 liter (L) = 33.8140 1 liter (L) = 0.2642 1 teaspoon (tsp) = 4.9289 1 meter (m) = 3.2808 Final quantity and units 1 day (d) = 24 254.8723 mL/lb 828.058830243995 mcg/floz 1.08 kg/d 1.71796696234693 m^2/L 154.605083436508 tsp/(lb*d) Enter a text response Enter a number Enter an Excel formula Make no changes NOT use ells, enter the ratio of nswer to number with 4

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Second Units pounds (lb) milliliter (mL) gram (g) gram (g) milligram (mg) microgram (mcg) fluid ounces (floz) gallons (gal) milliliter (mL) feet (ft) hours (h)

Trip Budget $96,663.00 Foreign Currency Example The letter T J Tajikistan (TJS) Japan(JPY) 10.137 109.754 TJS 979,872.83 JPY 10,609,150.90 $139.01 $12.84 Choose your countries from this list Argentina (ARS) Malta (EUR) Australia (AUD) Mexico (MXN) Mexico (MXN) Brazil (BRL) Greece (EUR) Morocco (MAD) Bulgaria (BGN) Hungary (HUF) North Macedonia (MKD) 7 On this second conversion sheet, you will convert a trip budget into the equival equivalent number of dollars. Now, from the list below the table below, select four countries that start with the f letter long, use the letter M as the second letter of each name that is one letter long countries to choose from for a particular letter, go to the next letter of the alphabet letter. (If you are at the letter Z, go back to A.) For each country, identify the exchange rate for $1 using the following web page: https://data.oecd.org/chart/6Tcl Then, convert your trip budget above into this currency and convert the amount of formulas that use a cell reference for the exchange rate. Use formatting as indicate United States is not available for you to choose from the list. First letter of your first name Country starting with the letter (or next available letter) and currency code Exchange rate for the currency to at least 3 significant digits (or exact rate if there are fewer than 3 significant digits) Your trip budget in the country's currency X.XX units of the country's currency in dollars A lbania (ALL) D enmark (DKK) M adagascar (MGA) E stonia (EUR) F inland (EUR) B elgium (EUR) G eorgia (GEL) H ong Kong, China (HKD) N ew Zealand (NZD) C ameroon (XAF)

Canada (CAD) Norway (NOK) Chile (CLP) India (INR) Indonesia (IDR) Portugal (EUR) Colombia (COP) Ireland (EUR) Colombia (COU) Israel (ILS) Russia (RUB) Costa Rica (CRC) Croatia (HRK) Czech Republic (CZK) I celand (ISK) P oland (PLN) China (People's Republic of) (CNY) R omania (RON) J apan (JPY) K orea (KRW) L atvia (EUR)

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

1409.15 US Dollar $1.00 Format this entry as A B R General Albania(ALL) Belgium(EUR) Romania(RON) General 1.331 0.845 4.160 ALL 128,658.45 EUR 81,680.24 RON 402,118.08 $1,058.71 $1,667.63 $338.74 Senegal (XOF) Serbia (RSD) Singapore (SGD) Slovak Republic (EUR) Slovenia (EUR) South Africa (ZAR) lent amounts in several foreign currencies and convert local currencies into the first two letters of your first and last names. If your first or last name is only one g. If there is no country starting with a particular letter or you have run out of t that you still have available choices for and select a country starting with that f units of the local currency into dollars. These calculations must be Excel ed in the last column of the table. An example is provided for you. Note that the Second letter of your first name First letter of your last name Second letter of your last name Number to three decimal places. Currency with the country's currency code as a symbol to two decimal places. Currency with the $ symbol to two decimal places. S audi Arabia (SAR)

Sweden (SEK) Switzerland (CHF) Switzerland (CHE) Switzerland (CHW) T ürkiye (TRY) U nited Kingdom (GBP) Z ambia (ZMW)

Legend If a cell is shaded You should Blue Green Enter a number Yellow Any other color Enter a text response Enter an Excel formula Make no changes

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Competency Name Chart Conversions Income Analysis Best-Fit Line and Predicted Incomes Unit Conversions Fahrenheit / Celsius Conversions

Currency Conversions Currency Conversions

Major Assignment 1 Grad Requirements for full credit Your formulas for the ratios are correct, using appropriate cell references. You have the correct currency code as indicated in the list. 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.) You have correctly calculated the slope and y-intercept for the data provided, using appropriate Excel functions. Your formulas for Predicted Incomes are correct, using cell references for the slope, y-intercept, and years of education. Your slope, y-intercept, and Predicted incomes are formatted as indicated in the instructions. You have included an XY-Scatterplot of the BLS data, adding an appropriate title and axis labels. You have added a trendline to your scatterplot, extending it to 8 years on the left and 24 years on the right. You have identified the correct units for your final quantity, using the units abbreviations (including capitalization) provided in the conversion factors table. You have identified the conversion ratios to use, using correct units abbreviations from the table (including capitalization). Your final quantity formulas are correct and use cell references for all inputs. Your Fahrenheit to Celsius conversion formulas are correct and use cell references. The calculations are direct and do not use built-in Excel functions. 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. You have chosen appropriate countries from the list provided below the table, using the procedure described in the instructions.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

You have provided each exchange rate to at least 3 significant digits. The trip budget in the foreign currency is a correct Excel formula, using cell references. Your calculation of the value of the foreign currency units into dollars is a correct Excel formula, using cell references. The cells containing the trip budget and value of foreign currency are correctly formatted as specified in the last column of the table.

ding Sheet 1 12 51 19 12 4 Subtotals 99 0 9 20 40 18 4 Subtotals 91 0 4 4 4 (optional for student use) Did you meet the requirements? Points possible Your points