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
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and...
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data. Calculate the MSE and MAPE for each. Plot the original series, and each of the forecasts. Create forecasts for 2017 Q1, 2017 Q2, 2017 Q3 and 2017 Q4 using each of these three techniques. If you had to choose one of these, which would you choose and why? Given your data, and this time period, would you...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4 2.42 2010 1 2.72 2010 2 2.53 2010 3 2.61 2010 4 2.84 2011 1 2.95 2011 2 2.79 2011 3 2.93 2011 4 3.03 2012 1 3.44 2012 2 3.2 2012 3 3.3 2012 4 3.36 2013 1 3.79 2013 2 3.56 2013 3 3.74 2013 4 3.8 2014 1 4.24 2014 2 3.87 2014 3 4.15 2014 4 4.18 2015 1 4.8...
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...