|
APOLLO GROUP |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| LINEAR
REGRESSION EQUATION FITTED TO DATA FOR ANNUAL REVENUES |
|
|
|
|
| |
|
|
|
Annual Revenues, |
Forecast |
|
Std, Fcst. |
80% Confidence Limits |
|
|
| |
|
|
|
$ million |
Error, |
X-XM, |
Error, SFE |
Minimum |
Maximum |
|
|
| Year |
X |
X^2 |
|
Data |
Forecast |
$ million |
years |
$ million |
$ million |
$ million |
|
|
| 2000 |
0 |
0 |
|
$609,997 |
$462,742 |
$147,255 |
-3 |
$140,109 |
$255,957 |
$669,527 |
|
|
| 2001 |
1 |
1 |
|
$769,474 |
$796,869 |
-$27,395 |
-2 |
$131,288 |
$603,103 |
$990,636 |
|
|
| 2002 |
2 |
4 |
|
$1,009,455 |
$1,130,997 |
-$121,542 |
-1 |
$125,699 |
$945,480 |
$1,316,514 |
|
|
| 2003 |
3 |
9 |
|
$1,339,517 |
$1,465,124 |
-$125,607 |
0 |
$123,780 |
$1,282,440 |
$1,647,809 |
|
|
| 2004 |
4 |
16 |
|
$1,798,423 |
$1,799,252 |
-$829 |
1 |
$125,699 |
$1,613,735 |
$1,984,769 |
|
|
| 2005 |
5 |
25 |
|
$2,251,472 |
$2,133,380 |
$118,092 |
2 |
$131,288 |
$1,939,613 |
$2,327,146 |
|
|
| 2006 |
6 |
36 |
|
$2,477,533 |
$2,467,507 |
$10,026 |
3 |
$140,109 |
$2,260,722 |
$2,674,292 |
|
|
| 2007 |
7 |
49 |
|
|
$2,801,635 |
|
4 |
$151,599 |
$2,577,893 |
$3,025,377 |
|
|
| 2008 |
8 |
64 |
|
|
$3,135,762 |
|
5 |
$165,201 |
$2,891,945 |
$3,379,580 |
|
|
| |
|
|
|
|
Average Error |
$0 |
|
Student's t = |
|
1.4759 |
|
|
|
Sum of Squares of
Errors |
67,031,296,739 |
|
|
|
Model's Standard
Error of Estimate |
$ 115,785.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Intercept,
$ million |
462741.71 |
|
|
| Slope,
$ million/year |
334127.57 |
|
|
| Coeff.
Of Correlation, R |
0.98945 |
|
|
| Coeff.
Of Determination, R^2 |
0.97901 |
|
|
|
|
|
|
LINEST Output for Linear Model |
|
|
|
334127.57 |
462741.71 |
|
|
|
21881.3843 |
78894.4529 |
|
|
|
0.97901 |
115785.4 |
|
|
|
233.17127 |
5 |
|
|
|
3.12595E+12 |
67,031,296,739 |
|
|
|
|
|
| Model Specification: |
|
|
| Y=
462741.71 + 334127.57*X |
|
|
|
| where Y = annual revenue, $ million |
|
|
| and
X = number of years since 2000 (i.e., X=0 |
|
|
|
for 2000, 1 for 2001, 2 for 2002, etc.) |
|
|
| Model's standard error of estimate =
$115,785.4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
