How do I create this correlation matrix?

[michaelsmith559]

I have tried to recreate this correlation coefficient matrix using the data analysis tool-pak but have had no luck. How can I recreate this table?

Excel 2012
	A	B	C	D	E	F	G	H
1	SUMMARY OUTPUT: Regression using PredInt.xls
2
3		Regression Statistics
4	Multiple R	0.41833
5	R Square	0.175
6	Adjusted R Square	0.1580479
7	Standard Error	0.436069	= Standard Deviation of Residuals
8	Observations	150
9
10	ANOVA
11		df	SS	MS	F	Significance (p-value) for F
12	Regression	3	5.889077	1.963026	10.32323	3.33E-06
13	Residual	146	27.7628	0.190156	= Variance of Residuals
14	Total	149	33.65188	0.225852	= Variance of Dependent Variable
15
16	Dependent (Criterion) Variable: GPA	Coef-ficients	Standard Error	t Stat	P-value (2-tails)	Lower 95%	Upper 95%	X Values for Prediction
17	Intercept	2.2824953	0.467448	4.88289	2.71E-06	1.358657	3.206333
18	Gender	0.2559016	0.082582	3.098767	0.002332	0.092691	0.419112	0.253333333
19	Work	-0.0468131	0.014787	-3.16581	0.001883	-0.07604	-0.01759	4.86
20	GMAT	0.0018435	0.000723	2.548962	0.011837	0.000414	0.003273	628.3333333
21
22	Confidence Level	Confidence and Prediction Intervals for GPA
23	0.95	Predicted Y	Standard Error	Lower 95%	Upper 95%
24	Confidence Interval	3.2781333	0.035605	3.207766	3.348501
25	Prediction Interval	3.2781333	0.43752	2.413442	4.142824
26
27	Correlations of the Coefficients
28		Intercept	Gender	Work	GMAT
29	Intercept	1	-0.04637	-0.23539	-0.98332
30	Gender	-0.0463749	1	0.128259	-0.01862
31	Work	-0.2353922	0.128259	1	0.078087
32	GMAT	-0.9833205	-0.01862	0.078087	1
33
34	Covariances of the Coefficients
35		Intercept	Gender	Work	GMAT
36	Intercept	0.2185073	-0.00179	-0.00163	-0.00033
37	Gender	-0.0017902	0.00682	0.000157	-1.1E-06
38	Work	-0.0016271	0.000157	0.000219	8.35E-07
39	GMAT	-0.0003324	-1.1E-06	8.35E-07	5.23E-07
GPA Results

Cell Formulas
Range	Formula
F16	="Lower " & 100*$A$23 & "%"
F17	=B17-TINV(1-$A$23,146)*C17
F18	=B18-TINV(1-$A$23,146)*C18
F19	=B19-TINV(1-$A$23,146)*C19
F20	=B20-TINV(1-$A$23,146)*C20
G16	="Upper " & 100*$A$23 & "%"
G17	=B17+TINV(1-$A$23,146)*C17
G18	=B18+TINV(1-$A$23,146)*C18
G19	=B19+TINV(1-$A$23,146)*C19
G20	=B20+TINV(1-$A$23,146)*C20
B24	= $B$17 + SUMPRODUCT($B$18:$B$20, H18:H20)
B25	= $B$17 + SUMPRODUCT($B$18:$B$20, H18:H20)
D23	="Lower " & 100*$A$23 & "%"
D24	= B24 - C24*TINV(1-$A$23,146)
D25	= B25 - C25*TINV(1-$A$23,146)
E23	="Upper " & 100*$A$23 & "%"
E24	= B24 + C24*TINV(1-$A$23,146)
E25	= B25 + C25*TINV(1-$A$23,146)
C24	{=SQRT(MMULT(MMULT(TRANSPOSE(H18:H20), $C$37:$E$39),H18:H20) + 2*MMULT($C$36:$E$36,H18:H20) + $B$36)}
C25	{=SQRT($D$13 + MMULT(MMULT(TRANSPOSE(H18:H20), $C$37:$E$39),H18:H20) + 2*MMULT($C$36:$E$36,H18:H20) + $B$36)}
Press CTRL+SHIFT+ENTER to enter array formulas.

Named Ranges
Name	Refers To	Cells
b	=#REF!$H$5:$H$8

 

[Ben Nevis]

Data Analysis, Regression
Y A1:A151
X B1:E151
Check Labels, Check Confidence Interval 95%
=>

Excel 2007
	A	B	C	D	E	F	G	H	I
1	SUMMARY OUTPUT
2
3	Regression Statistics
4	Multiple R	0.418329975
5	R Square	0.174999968
6	Adjusted R Square	0.158047913
7	Standard Error	0.436068987
8	Observations	150
9
10	ANOVA
11		df	SS	MS	F	Significance F
12	Regression	3	5.88907742	1.963025807	10.32323006	3.32833E-06
13	Residual	146	27.76279963	0.190156162
14	Total	149	33.65187705
15
16		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
17	Intercept	2.282495346	0.467447633	4.882889949	2.71202E-06	1.358657264	3.206333429	1.358657264	3.206333429
18	Gender	0.25590156	0.082581746	3.098766634	0.002331725	0.092691487	0.419111633	0.092691487	0.419111633
19	Work	-0.046813085	0.014787081	-3.165809685	0.001882856	-0.076037468	-0.017588702	-0.076037468	-0.017588702
20	GMAT	0.001843482	0.000723229	2.548961987	0.011836896	0.000414132	0.003272832	0.000414132	0.003272832
Sheet10

Cell Formulas
Range	Formula
A1	SUMMARY OUTPUT
A3	Regression Statistics
A4	Multiple R
A5	R Square
A6	Adjusted R Square
A7	Standard Error
A8	Observations
A10	ANOVA
A12	Regression
A13	Residual
A14	Total
A17	Intercept
A18	Gender
A19	Work
A20	GMAT
B4	0.41832997548915
B5	0.174999968392753
B6	0.158047912948768
B7	0.436068987469263
B8	150
B11	df
B12	3
B13	146
B14	149
B16	Coefficients
B17	2.28249534632797
B18	0.255901560106636
B19	-0.0468130845465847
B20	0.00184348199623425
C11	SS
C12	5.88907741960769
C13	27.7627996275403
C14	33.651877047148
C16	Standard Error
C17	0.467447632509954
C18	0.0825817463382317
C19	0.0147870810943461
C20	0.000723228516374942
D11	MS
D12	1.9630258065359
D13	0.190156161832468
D16	t Stat
D17	4.88288994870322
D18	3.09876663371267
D19	-3.16580968535325
D20	2.54896198711078
E11	F
E12	10.3232300632223
E16	P-value
E17	2.71201658186428E-06
E18	0.00233172451687196
E19	0.0018828555325775
E20	0.0118368964609194
F11	Significance F
F12	3.32833019400051E-06
F16	Lower 95%
F17	1.35865726405536
F18	0.0926914872302676
F19	-0.0760374675373777
F20	0.000414132483808459
G16	Upper 95%
G17	3.20633342860059
G18	0.419111632983005
G19	-0.0175887015557918
G20	0.00327283150866005
H16	Lower 95.0%
H17	1.35865726405536
H18	0.0926914872302676
H19	-0.0760374675373777
H20	0.000414132483808459
I16	Upper 95.0%
I17	3.20633342860059
I18	0.419111632983005
I19	-0.0175887015557918
I20	0.00327283150866005

Named Ranges
Name	Refers To	Cells
b	=#REF!$H$5:$H$8
y	=#REF!$A$2:$A$51

 

[Ben Nevis]

Correction:
X should only be B1:D151, Column E plays no part in the regression