(Solved) : According Bureau Labor Statistics North Carolina Unemployment Rate 2008 Approximated Funct Q26219929 . . . .

According to the Bureau of Labor Statistics, the North Carolinaunemployment rate for 2008 can be approximated by the functiongiven below, where U(t) represents the unemployment ratein percent and t is the month in 2008 (for example,January 2008 =1)

U(t) = {

0.28t+4.44   1<=t<=9

0.8t-0.93       9

Use a textbox to answer questions in complete sentences withunits. (Do this in excel)

1. Create a complete scatter plot of the function. You must usethe method that we learned in class.

2. Find U(4) and interpret it in context of the problem.

3. When in 2008 was the unemployment rate 6.25%?

There is no specific method used to do this in Excel.I’m