SCENARIO 16-15-A
You Are the CEO of a Diary Company

question 60

Short Answer

SCENARIO 16-15-A
You are the CEO of a diary company. The total milk production (in gallons) from your company
over the past 30 years are presented below and also contained in the Excel file SCENARIO 16-
15-A.XLSX. $$\begin{array} { l r r r r r r r r r r r } \text { Year } & 1986 & 1987 & 1988 & 1989 & 1990 & 1991 & 1992 & 1993 & 1994 & 1995 \\& 1996 & 1997 & 1998 & 1999 & 2000 & 2001 & 2002 & 2003 & 2004 & 2005 \\& 2006 & 2007 & 2008 & 2009 & 2010 & 2011 & 2012 & 2013 & 2014 & 2015 \\\text { Milk } & 150201 & 172719 & 171357 & 157121 & 155727 & 152974 & 153443 & 158548 & 162614 & 164210 \\\text { Prod } & & & & & & & & & \\& 159127 & 153866 & 165992 & 177843 & 167477 & 163821 & 161700 & 170348 & 174105 & 185103 \\& 184670 & 173385 & 159695 & 173641 & 165706 & 171164 & 168706 & 150684 & 179314 & 163802\end{array}$$ You want to predict your company's future total milk production using the linear trend, quadratic
trend, exponential trend, first-order autoregressive, second-order autoregressive and third-order
autoregressive model.
-Referring to Scenario 16-15-A, what is the p-value of the t test statistic for testing the
appropriateness of the first-order autoregressive model?

---

Definitions:

Trade Discounts

Discounts given to buyers that generally are based on the quantity purchased.

Net Price

The real cost incurred for a product or service once all discounts, rebates, or allowances have been subtracted.

Complement Rates

In probability, the complement of an event's rate, representing the likelihood of the event not occurring.

Net Price

The actual price paid for a product or service after subtracting any discounts, rebates, or other deductions from the list or sticker price.