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

question 186

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 value of the t test statistic for testing the
appropriateness of the third-order autoregressive model?

---

Definitions:

Code Noir

A set of laws first enacted in the French colonies in 1685, governing the treatment of slaves, with the aim of regulating the slave trade and the lives of black people in the French colonial empire.

Louisiana Slaves

Enslaved Africans and their descendants who lived and worked primarily in the state of Louisiana, experiencing a unique blend of French, Spanish, African, and American cultures.

French Immigrants

Individuals from France who move to another country, often seeking better opportunities or escaping political and social issues in their homeland.

North America

A continent entirely within the Northern Hemisphere and almost all within the Western Hemisphere; it includes countries like the United States, Canada, and Mexico.