According to the Bureau of Labor Statistics, the North Carolina unemployment rat

Question

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

Explanation / Answer

Hi,

I would like to explain you the question first. However, there is one discrepency in the question.

The equation given means :

1. if the value of t (variable) is between 1 to 9 then use the equation 0.28t+4.44

2. if the value of t=9 then use 0.8t-0.93

The dicrepency is that both equal are no valid for t=9. the values are different if you substitute t=9 in both equations. So either 1st equation will be 1<=t<9 or 2nd should be t>9.

However, ill tell you how to solve

Now you need to open an excel sheet and do the following

Step 1 - Open excel, type t in cell A1 and type U in cell B1.

Step 2 - Enter nine values for x in column A. 1,2,3...9

Step 3 - In cell B2 enter the equation Excel will use to calculate Y. The equation will be = 0.28t+4.44

Step 4 - Press Enter after entering the equation. To put the same equation in each of the other cells, click on the cell where the equation is located. Put your cursor on top of the black block on the bottom right corner of the cell. When the cursor turns to a black plus, depress your left mouse button and drag down even with the last value on the left to fill the equation down.

But for the value where t=9 put the 2nd equation 0.8t-0.93 instead of the first one.

Step 5 - Highlight the data to be turned into a chart. Do not highlight the row headings. An easy way to highlight data is to click one time on the top left number, hold down the Shift key, and with the Shift key depressed, click on the bottom right number. All data between the clicks is highlighted.

Step 6 - Click on the Chart Wizard button or choose Chart from the Insert menu.

Step 7 - Select XY (Scatter) as the chart type. To see what the chart will look like, click on the button that says Press and Hold to View Sample. As long as you leave the mouse button depressed, you will see the sample graph produced from the data used.

Step 8 - Click the Next button at the bottom of the Chart Wizard window.

Step 9 - . Press the Next button at the bottom of the Chart Wizard window.

You can select legends and options if you need and you will be done

2. to find u(4) just substitute value t=4 in first equation as t belongs to 1<t<9

3. Once you have created the chart, you can answer this question.

Hope it helped you. All the best.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.