Question: A statistical program is recommended. Suppose the following table shows a company's annual revenue (in billions of dollars) for 2012 (period 1) to 2017 (period

A statistical program is recommended.

Suppose the following table shows a company's annual revenue (in billions of dollars) for 2012 (period 1) to 2017 (period 6).

YearPeriodSale ($ Billions)
201211.54
201321.87
201432.36
201543.13
201653.54
201764.14

(a)

Construct a time-series plot.

A time series has a horizontal axis labeled "Period" with values from 0 to 7 and a vertical axis labeled "Budget ($ billions)" with values from 0 to 4. The time series plot contains a series of 6 points connected by line segments. The segments and the approximate points they connect are as follows.

  • The segments start at (1, 1.54),
  • go down and right through 2 points to (3, 1.36),
  • and go up and right through 3 points to stop at (6, 4.14).

A time series has a horizontal axis labeled "Period" with values from 0 to 7 and a vertical axis labeled "Budget ($ billions)" with values from 0 to 4. The time series plot contains a series of 6 points connected by line segments. The segments and the approximate points they connect are as follows.

  • The segments start at (1, 4.14),
  • go down and right through 3 points to (4, 1.36),
  • and go up and right through 2 points to stop at (6, 1.54).

A time series has a horizontal axis labeled "Period" with values from 0 to 7 and a vertical axis labeled "Budget ($ billions)" with values from 0 to 4. The time series plot contains a series of 6 points connected by line segments. The segments and the approximate points they connect are as follows.

  • The segments start at (1, 4.14),
  • and go down and right through 5 points to stop at (6, 1.54).

A time series has a horizontal axis labeled "Period" with values from 0 to 7 and a vertical axis labeled "Budget ($ billions)" with values from 0 to 4. The time series plot contains a series of 6 points connected by line segments. The segments and the approximate points they connect are as follows.

  • The segments start at (1, 1.54),
  • and go up and right through 5 points to stop at (6, 4.14).

What type of pattern exists in the data?

The time series plot shows an upward curvilinear trend.The time series plot shows a downward curvilinear trend. The time series plot shows an upward linear trend.The time series plot shows a downward linear trend.

(b) Develop a linear trend equation for this time series. (Round your numerical values to three decimal places.)

Tt =


(c) What is the forecast for sales (in billions of dollars) for period 7? (Round your answer to two decimal places.)

$ billions

Step by Step Solution

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Answer answer is obtai... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!