c.) Using Years since 1970 as the inputs, use the SLOPE and INTERCEPT functions to determine the slope and y-intercept of the linear trendlines for both male and female median incomes in 2009 $ over the time period 1970 to 2009. Format to 2 decimal places .

Share Comments AutoSum APO Conditional 'Format as Cell Insert Delete Format Clear Sort & Find & Ideas Formatting . Table Styles Filter * Select Styles Cell Editing 2 This spreadsheet contains median income data for males and females in the U.S. from 1970 to 2009. 5 a.] Enter a formula which computes years since 1970, and use these values to make a well labeled scatterplot of the data for both male and female income in 20095. Insert trendline and display equation. sGOOD b.) Next enter a formula which computes what $100 in 2009 was worth in each current year's dollars. For example, we are given that in 1970 females earned a median income of $2,237 which is equivalent to $11,027 In 2009 5. You can use these two figures to determine what $100 in 2009 was worth in 1970 $ (Hint: set up a proportion and cross multiply) c.] Using Years since 1970 as the inputs, use the SLOPE Male Female to determine the slope and y intercept of the linear tre Slope: female median incomes in 2009 $ over the time period decimal places. Intercept: Part d: The The O d.) Interpret the SLOPE value in a sentence for both m for makes for females in the blanks in the sentence below. is changing by is changing by The is changing by per a l Ilea the ushunt from mart r In nee dict the mika and T 9:34 PM