Question

U.S. Civilian Labor Force, 2007-2016 |
|||

Year |
Labor Force |
||

2007 | 153,918 | ||

2008 | 154,655 | ||

2009 | 153,111 | ||

2010 | 153,650 | ||

2011 | 153,995 | ||

2012 | 155,628 | ||

2013 | 155,151 | ||

2014 | 156,238 | ||

2015 | 157,957 | ||

2016 | 159,640 | ||

**(d)** Make forecasts using the following fitted
trend models for years 2017-2019. **(Round your answers to
the nearest whole number.)**

t |
Linear |
Quadratic |
Exponential |

11 | 158608 | 161301 | |

12 | 159192 | 163354 | |

13 | 159776 | 165653 | |

Answer #1

The exponentia trend model equation along with the scatter plot is as follows

The linear trend equation is

y = 152218 * e^{0.0037 * x}

where e is constant = 2.71828

Where y is the Labour force for the year "'x" where x = 1 represents year 2007 and son on

For year 2017, x = 11

y = 152218 * 2.71828^{0.0037 * 11}

= 152218 * 1.04154

= 158541.1

= 158541 rounded to nearest whole number

For year 2018, x = 12

y = 152218 * 2.71828^{0.0037 * 12}

= 152218 * 1.0454

= 159128.8

= 159129 rounded to nearest whole number

For year 2019, x = 13

y = 152218 * 2.71828^{0.0037 * 13}

= 152218 * 1.049276

= 159718.6

= 159719 rounded to nearest whole number

= 159129 rounded to nearest whole number

U.S. Civilian Labor Force (thousands)
Year
Labor Force
Year
Labor Force
2007
153,918
2012
155,628
2008
154,655
2013
155,151
2009
153,111
2014
156,238
2010
153,650
2015
157,957
2011
153,995
2016
159,640
Click here for the Excel Data File
(a) Make a line graph of the U.S. civilian labor
force data.
Line Graph A
Line Graph B
Line Graph C
Line Graph D
Line Graph A
Line Graph B
Line Graph C
Line Graph D
(b) Describe the trend (if any)...

U.S. Civilian Labor Force (thousands)
Year
Labor Force
Year
Labor Force
2007
153,918
2012
155,628
2008
154,655
2013
155,151
2009
153,111
2014
156,238
2010
153,650
2015
157,957
2011
153,995
2016
159,640
Click here for the Excel Data File
(a) Make a line graph of the U.S. civilian labor
force data.
Line Graph A
Line Graph B
Line Graph C
Line Graph D
Line Graph A
Line Graph B
Line Graph C
Line Graph D
(b) Describe the trend (if any)...

JetBlue Airlines Revenue,
2008–2015 (millions)
Year
Revenue
Year
Revenue
2008
3,388
2012
4,982
2009
3,286
2013
5,441
2010
3,779
2014
5,817
2011
4,504
2015
6,416
(a) Use Excel, MegaStat, or MINITAB to fit both a
linear and an exponential trend to the time series. (Round
your answers to 2 decimal places.)
Linear
yt = t +
Exponential
yt
= e t
(b) Make annual forecasts for 2016–2018, using the
linear and exponential trend models. (Do not round the
intermediate calculations. Round your final...

JetBlue Airlines Revenue,
2008–2015 (millions)
Year
Revenue
Year
Revenue
2008
3,388
2012
4,982
2009
3,286
2013
5,441
2010
3,779
2014
5,817
2011
4,504
2015
6,416
Click here for the Excel Data File
(a) Use Excel, MegaStat, or MINITAB to fit both a
linear and an exponential trend to the time series. (Round
your answers to 2 decimal places.)
Linear
yt = t +
Exponential
yt
= e t
(b) Make annual forecasts for 2016–2018, using the
linear and exponential trend models. (Do not...

Year
Consumer Price Index
Percentage Increase
2007
207.3
2008
215.3
2009
214.5
2010
218.1
2011
224.9
2012
229.6
2013
233.0
2014
236.7
2015
237.0
The following table gives the value of the consumer price index
for 2007 through 2015.
What was the inflation rate in 2008? ________________
What was the inflation rate in 2012 ___________________
What was the percentage increase of the average price level
from 2007 to 2015?__________
Inflation was highest in__________ and lowest in
__________year

Calculate the historical variance:
Year Closing Stock Price
2009 32.25
2010 43.83
2011 60.30
2012 41.18
2013 46.94
2014 50.94
2015 32.97
2016 55.34
2017 55.09
2018 44.86
2019 72.59
Submit your answer as a decimal.

Please use SPSS for analysis if available
Will give positive feedback for answering all
questions!
Question:
The sales data of a company's sales records is
provided.
a. Plot a time-series plot of the data
b. Fit a Linear trend line to these data
c. Conduct a hypothesis test of the linear trend model developed
in part b. Use significance level of 0.05
d. State the predicted value of sales from 2005 to 2020
e. Calculate MAD and MSE for the...

How can I do regression analysis for Sales Revenue for Macys
comparing it to TJX? Please show work and example in Excel if it's
easier.
Net Profit Margin
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
Sales Revenue - MACYS
$
15,776,000.00
$
22,390,000.00
$
26,970,000.00
$
26,313,000.00
$ 24,892,000.00
$
23,489,000.00
$
25,003,000.00
$
26,405,000.00
$
27,686,000.00
$
27,931,000.00
$
28,105,000.00
$
27,079,000.00
$
25,778,000.00
$
24,837,000.00
Net Profit Margin
2005
2006
2007...

DETROIT
ANN ARBOR
2008
59
2008 61
2009
60
2009 58
2010
61
2010 60
2011
69
2011 68
2012
66
2012 67
2013
62
2013 64
2014
64
2014 66
2015
71
2015 70
2016
69
2016 72
2017
66
2017 64
What is the mean, median, mode, range, midrange, variance, and
standard deviation for both cities?
Detroit
Mean
Median
Mode
Range
Midrange
Variance
Standard Deviation
Ann Arbor
Mean
Median
Mode
Range
Midrange
Variance
Standard Deviation
Make sure...

A company’s sales for the years 2010 to 2018 were as follows: (
x N$ 10 000 )
Year
2010
2011
2012
2013
2014
2015
2016
2017
2018
Sales
324
296
310
305
295
347
348
364
370
2.1) Derive, by using the method of least squares, an equation
of linear trend for the sales of the company. (Use sequential
numbering with x = 1 in 2010) (8)
2.2) Use the trend line equation obtained in Question 2.1 to
compute...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 22 minutes ago

asked 24 minutes ago

asked 43 minutes ago

asked 44 minutes ago

asked 44 minutes ago

asked 48 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago