ComputerScienceExpert
$18/per page/
I am not sure how to even began this assignment. I am not sure what it is wanting me to put in coloms a-40 to d-D50 I feel that if I understood that part I would be able to understand the rest of the assigment. Please help
Â
Bureau of Labor Statistics Please note that this assignment consists of multiple parts in multiple worksheets - see the tabs at the bottom to change sheets
Student Name: Applications Worksheet 1
MAT-250: College Algebra
Unemployment Rate Data from the Bureau of Labor Statistics http://data.bls.gov/
Year
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014 Jan Feb
5.7
5.3
4.7
4.6
5.0
7.8
9.7
9.1
8.2
7.9
6.6 Mar
5.6
5.4
4.8
4.5
4.9
8.3
9.8
9.0
8.3
7.7
6.7 5.8
5.2
4.7
4.4
5.1
8.7
9.9
9.0
8.2
7.5
6.7 Apr
May
5.6
5.6
5.2
5.1
4.7
4.6
4.5
4.4
5.0
5.4
9.0
9.4
9.9
9.6
9.1
9.0
8.2
8.2
7.5
7.5
6.3
6.3 Jun
5.6
5.0
4.6
4.6
5.6
9.5
9.4
9.1
8.2
7.5
6.1 Jul
Aug
5.5
5.4
5.0
4.9
4.7
4.7
4.7
4.6
5.8
6.1
9.5
9.6
9.5
9.5
9.0
9.0
8.2
8.1
7.3
7.2
6.2
6.1 Sep
5.4
5.0
4.5
4.7
6.1
9.8
9.5
9.0
7.8
7.2
5.9 Oct
Nov
5.5
5.4
5.0
5.0
4.4
4.5
4.7
4.7
6.5
6.8
10.0
9.9
9.5
9.8
8.8
8.6
7.8
7.8
7.2
7.0
5.8
5.8 GCU's Spring graduation is near the end of April each year, so you will likely be looking to start a job in May a few years from now. How hard
will it be to find a job? The goal of this project is to estimate the unemployment rate in May of the year you graduate.
To avoid combinations of large and small coefficients, data is often transformed to use smaller numbers. In cells A40:A50, enter the year
information from the above table but transform the data to "years after 2004". You may either use formulas or manually enter the numbers.
In cells B40:B50, copy and paste or use formulas to include the unemployment rate data from May of each year.
Create a scatter plot: Select the two columns of data in cells A40:B50. Go to the Insert tab on the ribbon and open the Scatter dropdown,
then choose the plot style that has point markers with no lines.
Find a linear function to model the data: Right-click on a data point and select "Add Trendline". Select Linear and check the boxes to display
the equation on the chart and to display the R-squared value on the chart.
Does the linear function look like a good model? Explain why or why not.
Answer:
Source: Bureau of Labor Statistics Generated on: December 18, 2014 (03:24:26 PM) Bureau of Labor Statistics Solve for the zero(s) of the function. Give each x-value and also state which year each one corresponds to.
Answer:
Explain what the zero(s) mean in the context of this particular data set.
Answer:
Use the model to predict the unemployment rate in your graduation year.
Answer:
Years after 2004 May unemployment rate Source: Bureau of Labor Statistics Generated on: December 18, 2014 (03:24:26 PM) Bureau of Labor Statistics tom to change sheets Dec Annual
5.4
4.9
4.4
5.0
7.3
9.9
9.4
8.5
7.9
6.7 years from now. How hard
e.
40:A50, enter the year
ually enter the numbers. n the Scatter dropdown, check the boxes to display Source: Bureau of Labor Statistics Generated on: December 18, 2014 (03:24:26 PM) Bureau of Labor Statistics Source: Bureau of Labor Statistics Generated on: December 18, 2014 (03:24:26 PM) Source: Cullen, M.R. (1992). Mathematics for the Biosciences. Teachbooks. A cattle population is divided into six categories: male newborn, female newborn, male yearling, female ye
female. If xi is the number of cattle in category i, assume that
X =[
20
24
13
11
The vector H specifies the number and the type that will soon be sold.
H=[
0
0
4
2
Compute the following quantities and interpret in the context of the problem.
a. X-H
Answer: X-H =[ 20 24 9 9 Interpretation: For the population of cattle that is being sold 0 will be sold when the polulation is at 20 as
female newborns. When the polulation is at 13 for male yearlings their will be 4 that will b
yearlings there will be 2 that will be sold. When there is an adult male there will be 8 in po
b. X-.5H
Answer: X-.5H =[ Interpretation: c. 1.1H
Answer:
Interpretation: 1.1H =[ 20 24 11 10 e yearling, female yearling, adult male, and adult
8 52
. 6 10 2 42 ] polulation is at 20 as well as at 24. When it is malle and
eir will be 4 that will be sold when there is 11 female
e there will be 8 in population and 6 will be sold. Lastly
5 47 ] Source: Cullen, M.R. (1992). Mathematics for the Biosciences. Teachbooks. A company has three warehouses, each of which stocks four types of items, A, B, C, and D. The invento
matrix: Item
A
B
C
D 1
300
150
560
220 Warehourse
2
240
200
700
560 3
420
80
350
280 If we denote the matrix by S, then s32=700 indicates that there are 700 units of item C stored in warehou
W=[
30
20
25
specifies the selling price for each of the items A, B, C, and D sold by the company.
a. Find the dimension of product W*S
Answer:
b. Compute W*S and give its interpretation.
Answer:
W*S= Interpretation: achbooks. items, A, B, C, and D. The inventory can be represented by a 4X3 0 units of item C stored in warehouse 2. Assume that the matrix
50
the company. The CEO of the new LopeLand amusement park wants to make sure the park's ticket prices are compa
Jackrabbit Farm.
Jackrabbit Farm offers three different ticket packages. Two tickets and two all-day ride passes cost $56
cost $68. Four tickets and three all-day ride passes cost $92. Set up an equation for each package that relates the price of a ticket y to the price of an all-day ride pas
terms of x and use cells A8:D17 below to create a table of values and graph the three equations. You m
trendlines to a regular scatter plot. Choose x values that allow you to see where the lines cross. A note about the way Excel interprets data for a scatter plot: If there are more columns than rows, Exce
horizonally rather than vertically. Two x values would be enough to graph the three equations, but if you
the scatter plot would not show the three graphs you are looking for. To avoid this, you can use more th
the graph, choose Select Data and switch the rows and columns. x y1 (2 tickets
y2 (3 tickets
y3 (4 tickets
and 2 passes) and 2 passes) and 3 passes) Is there a solution to the system of equations? Explain any assumptions you made in setting up the sys
Answer: Find the points of intersection and list them as ordered (x,y) pairs. You can use Goal Seek or solve by h
the graph mean in the context of the ticket and pass prices?
Answer: Considering the intersection points, is there one that you think would be the best to set the prices at Lop
Answer: 's ticket prices are comparable to another park across town, day ride passes cost $56. Three tickets and two all-day ride passes price of an all-day ride pass x. Write all three equations as y in
he three equations. You may use a scatter plot with lines or add
ere the lines cross. columns than rows, Excel will assume that your data is listed
three equations, but if you only used two rows and four columns,
this, you can use more than four x values, or you can right click on made in setting up the system that were not true. e Goal Seek or solve by hand. What do the intersection points on est to set the prices at Lopeland? Explain your choice.