According to the Bureau of Labor Statistics, the North Carolina unemployment rate for 2008 can be approximated by the function given below, where U(t) represents the unemployment rate in 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 with units. (Do this in excel)

1. Create a complete scatter plot of the function. You must use the 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 new to excel, that's way I'm seeking help.

The equation isn't clear. is 0.8t-0.93 part of the equation? 0.28...-0.8t are in the same part of the equation.

It's due today