Gonzalez_Chapter_5-7_Marriage_Start

Marriag Project De In this proble Steps to P Step 1 2 3 4 5 6 7 8 9 10 11

ge escription: em, you will investigate both marriage and divorce rates for the United States per 1,000 people in the population. You will also provide the resu Perform: Instructions Start Excel. Download and open the workbook named: Chapter_5-7_Marriage_Start In cell G12, determine how much the divorce rate will decrease per century. Format cell G12 as Number with 2 decimal places. Note: Enter a single value to answer the question. In cell F18, determine the slope of the marriage trendline. Format cell F18 as Number with 2 decimal places. Note: Type the slope value exactly as it appears in the equation on the chart. In cell G18, determine the y-intercept for the marriage trendline. Format cell G18 as Number with 2 decimal places. Note: Type the y-intercept value exactly as it appears in the equation on the chart. In cell G19, calculate the marriage rate in 2050. Format cell G19 as Number with 2 decimal places. Note: Use cell references for your calculations. In cell F23, determine the slope of the divorce trendline. Format cell F23 as Number with 2 decimal places. Note: Type the slope value exactly as it appears in the equation on the chart. In cell G23, determine the y-intercept for the divorce trendline. Format cell G23 as Number with 2 decimal places. Note: Type the y-intercept value exactly as it appears in the equation on the chart. In cell G24, calculate the divorce rate in 2050. Format cell G24 as Number with 2 decimal places. Note: Use cell references for your calculations. In cell G27, determine whether it is true that it is not possible for the divorce rate to be greater than the marriage rate in a given year because Save your file and submit for grading. In cells D32:K46, insert a Scatter Chart to show the marriage and divorce rates over the years given. Select range A9:C21. On the Insert tab, Charts tab, and then choose Scatter with the years on the horizontal axis and the rates per 1,000 on the vertical axis. Use cell references to B Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Marriage and Divorce Rates . Add a vertical axis tit per 1,000 people . Add the linear trendlines for both rates. To add a linear trendline to the data on the chart, select any point on the chart and Trendline Options window, select Linear with automatic trendline name and check "Display equation on chart". Drag it to any place on the cha

Marriage Rates per 1,000 Population Marriages Divorces 1990 9.8 4.7 2000 8.3 4.1 2004 7.8 3.7 2005 7.5 3.6 a.) 5.77 2006 7.5 3.7 2007 7.3 3.6 2008 7.1 3.5 2009 6.8 3.5 Marriage 2010 6.8 3.6 Slope Intercept 2011 6.8 3.6 b.) -0.13 270.25 2012 6.8 3.4 3.75 2013 6.8 3.3 2014 6.9 3.2 Divorce Slope Intercept c.) -0.06 119.54 1.26 d.) False a.) The sprea these, the marriages divorce ra in divorce year will b a.) Creat by filling CENTUR list: a. Marria b. rates p b.) Type i intercept c.) Type intercept d.) True people c 1985 1990 1995 2000 2005 2010 0 2 4 6 8 10 12 f(x) = − 0.057744055068836 x + 119.53728097622 f(x) = − 0.130976220275344 x + 270.249123904881 Marriage and Divorce rates

1985 1990 1995 2000 2005 2010 Marriages Linear (Marriages) Divorces Linear (Divorces)

2015 2020 )

n. To compute he number of The fact that the f all marriages end married in a given he divorce slope 0 people per be chosen from the e slope and - 𝑦 slope and - 𝑦 ause only married