Question

U.S. Civilian Labor Force, 2007-2016 Year Labor Force 2007 153,918 2008 154,655 2009 153,111 2010 153,650...

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


Homework Answers

Answer #1

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

The linear trend equation is

y = 152218 * e0.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.718280.0037 * 11

= 152218 * 1.04154

= 158541.1

= 158541 rounded to nearest whole number

For year 2018, x = 12

y = 152218 * 2.718280.0037 * 12

= 152218 * 1.0454

= 159128.8

= 159129 rounded to nearest whole number

For year 2019, x = 13

y = 152218 * 2.718280.0037 * 13

= 152218 * 1.049276

= 159718.6

= 159719 rounded to nearest whole number

= 159129 rounded to nearest whole number

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
U.S. Civilian Labor Force (thousands) Year Labor Force Year Labor Force 2007 153,918 2012 155,628 2008...
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...
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...
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...
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...
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...
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:...
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...
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  &n
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...
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT