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.

-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

Related Questions

A statistical program is recommended. Occasionally, it has been the case that home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent. City Rent ($) Mortgage ($) A 840 539 B 1,062 1,002 C 823 628 D 779 713 E 796 655 F 1,071 975 G 953 776 H 851 695 I 762 651 J 723 654 Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent. (Round your numerical values to three decimal places.) ŷ = c.) Do the assumptions about the error term and model form seem reasonable in light of the residual plot? The plot suggests curvature in the residuals indicating that the assumption of a linear relationship between the…

U.S. Bureau of Labor Statistics current population survey of unemployment rate and median weekly earnings to highest degree earned. Note: Data are for persons age 25 and over. Highest Degree Earned Unemployment Rate (%) Median Weekly Earnings ($) Doctoral Degree 1.5 1,743 Professional Degree 1.5 1,836 Master's Degree 2.2 1,401 Bachelor's Degree 2.5 1,173 Associate's Degree 3.4 836 Some College, No Degree 4.0 774 High School Diploma 4.6 712 Less than a High School Diploma 6.5 520 Overall 3.6 907 What was the overall national: a) percentage of unemployment? b) median weekly earnings?

U.S. Bureau of Labor Statistics current population survey of unemployment rate and median weekly earnings to highest degree earned. Note: Data are for persons age 25 and over. Highest Degree Earned Unemployment Rate (%) Median Weekly Earnings ($) Doctoral Degree 1.5 1,743 Professional Degree 1.5 1,836 Master's Degree 2.2 1,401 Bachelor's Degree 2.5 1,173 Associate's Degree 3.4 836 Some College, No Degree 4.0 774 High School Diploma 4.6 712 Less than a High School Diploma 6.5 520 Overall 3.6 907 Based on this data, is it better to earn a doctoral degree or a professional degree? Why?

U.S. Bureau of Labor Statistics current population survey of unemployment rate and median weekly earnings to highest degree earned. Note: Data are for persons age 25 and over. Highest Degree Earned Unemployment Rate (%) Median Weekly Earnings ($) Doctoral Degree 1.5 1,743 Professional Degree 1.5 1,836 Master's Degree 2.2 1,401 Bachelor's Degree 2.5 1,173 Associate's Degree 3.4 836 Some College, No Degree 4.0 774 High School Diploma 4.6 712 Less than a High School Diploma 6.5 520 Overall 3.6 907 Describe the relationship between:a) unemployment and educational attainmentb) weekly earnings and educational attainment

Examine the data in Box C and answer the questions that follow. BOX C Marital status (Household population 10 years old and over) 2015 2010 2007 2000 Total 1,018,744 941,611 881,972 798,398 Single 361,638 359,750 473,802 433,235 404,700 410,882 Married 392.927 382,921 Widowed 51,806 46,645 9,295 43,627 36,933 Divorced/Separated Common-Law/Live-in Unknown/Not Stated 11,192 6,900 5,916 88,771 47,064 35,846 1,796 27,275 246 672 6,996 Source: 2000 and 2010 Census of Population and Housing (CPH) 2007 and 2015 Census of Population (POPCEN) Statistics are numbers that describe some characteristics of a variable. 1. What is the variable being described? 2. What measurement scale is used to describe the data? 3. Illustrate how you will determine the percentage increase/decrease of the observations (data) across the years? 4. If you analyze the distribution of the data in BOX C, you can say may things. Write a paragraph about your observation.

SEE MORE QUESTIONS

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...

Algebra

ISBN:9780079039897

Author:Carter

Publisher:McGraw Hill

SEE MORE TEXTBOOKS