Hello , I am seeking an explanation on how to do each step of this question. We were asked to look at census data table s1701 and calculate the 90 percent confidence interval. The way I was taught by my professor was to add and subtract the margin of error from the percentage given for each year. (I will attach a photo of my findings for each year with the confidence intervals highlighted in blue) please tell me if I correctly got these totals. I will also attach the slide that shows the example for how to get the calculations with the formulas given by my professor. For the excel graphing portion I am not quite sure how to plot the confidence intervals in excel. Because there are two numbers in the confidence interval I do not know how to put them on a graph. (I will insert the graph example given by my professor.) for the last portion that asks if the poverty rates in 2022 are different from 2013 I am not sure how this question is supposed to be answered

. Consider poverty rates for the City of Detroit for the years 2013 through 2022 inclusive. Obtain this information from Table S1701 in the ACS using 1-year estimates. Calculate the 90 percent confidence interval for the poverty rate (1.e., Percent below poverty level\"; you may need to scroll to the right) for the \"Population for whom poverty status is determined\" for the years 2013 through 2022 inclusive. Plot these confidence intervals on a professional-grade graph like the one shown on Slide 31 on Lecture 4 notes (but you can do better than that, for example, putting the title at the bottom and outside the outline box of the graph and lining up the tick marks on the horizontal axis with the year; see also some notes I placed in module 2 on preparing tables and graphs). Note that Excel requires following some rules on how to create confidence interval graphs. Select a Charts a Stock a First option. Note that there are some specific instructions about how to organize your data. Export your graph to a Word document and complete your final formatting in Word, for example, centering and placing your title at the bottom. Upload only a Word or pdf document. 10 points. Since this is your first time doing a professional graph for me, I will grade a bit lightly on presentation, but future requirements for graphs and tables will be graded more strictly. Using the confidence intervals for 2013 and 2022, say whether the poverty rates in 2022 are different from poverty rates in 2013. Be sure to provide an answer that includes a probability or percentage statement. 5 points.