I have a question which I need really your help. I have a question related to regression data. The format of this question as an example needs to be like this:- so this is just an example not the question I need help with :

x1	x2	x3	x4	y in $				y= 27.64*x1 + 12530*x2 + 2553*x3 - 234.24*x4 + 52318
2310	2	2	20	142000				The developer can now estimate the assessed value of an office building in the same area which has
2333	2	2	12	144000				2500 square feet, 3 offices, 2 entrances and which is 25 years old
2356	3	1.5	33	151000				y= 27.64*2500 + 12530*3 + 2553*2 - 234.24*25 + 52318 = $ 158,261
2379	3	2	43	150000
2402	2	3	53	139000				Rsquared is 0.99675: strong relationship between independent and dependent variables
2425	4	2	23	169000
2448	2	1.5	99	126000				F statistic to show whether Rsquared occurred by chance
2471	2	2	34	142900				Is F statistic greater than F-critical value?
2494	3	3	23	163000				assume single tail test of 0.05 with degrees of freedom usually shown as v1 and v2
2517	4	4	55	169000				v1 = k = 4
2540	2	3	22	149000				v2 = n -(k+1) = 11 -(4+1) = 6
								F -critical vale is 4.53
								F -observed value > F -critical value
-234.23716	2553.211	12529.77	27.64139	52317.83
13.2680115	530.6692	400.0668	5.429374	12237.36
0.99674799	970.5785	#N/A	#N/A	#N/A
459.753674	6	#N/A	#N/A	#N/A				T-statistic
1732393319	5652135	#N/A	#N/A	#N/A				age slope coefficient: divide -234.24 by 13.268 or SE
#N/A	#N/A	#N/A	#N/A	#N/A				t-observed value is -234.24/13.268 = -17.7
#N/A	#N/A	#N/A	#N/A	#N/A				Find t-critical single tail with 6 degrees of freedom at 0.05 (1.94)
								17.7 > 1.94 age coefficient is significant or we reject the null hypothesis that the explanatory
								variable has no effect

My question is this and the below is the data to help you answering it for me.

The data (Y1, X2, X3, X4, X5, X6) refer to each franchise store that sells sportswear. Y1 = annual net sales/1000 X1 = number square metre/1000 X2 = inventory/1000 X3 = amount spent on advertising/1000 X4 = size of sales district/1000 families X5 = number of competing stores in district The letter A refers to Y1; B refer to X1 and so on.

. The letter A refers to Y1; B refer to X1 and so on.

a) Use regression analysis to carry out all the required tests and predict the value of annual net sales assuming independent variables have values of 6.5; 380; 14.5; 10.5 and6 respectively.

Y	X1	X2	X3	X4	X5
231	3.0	294	8.2	8.2	11
156	2.2	232	6.9	4.1	12
10	0.5	149	3	4.3	15
519	5.5	600	12	16.1	1
437	4.4	567	10.6	14.1	5
487	4.8	571	11.8	12.7	4
299	3.1	512	8.1	10.1	10
195	2.5	347	7.7	8.4	12
20	1.2	212	3.3	2.1	15
68	0.6	102	4.9	4.7	8
570	5.4	788	17.4	12.3	1
428	4.2	577	10.5	14	7
464	4.7	535	11.3	15	3
15	0.6	163	2.5	2.5	14
65	1.2	168	4.7	3.3	11
98	1.6	151	4.6	2.7	10
398	4.3	342	5.5	16	4
161	2.6	196	7.2	6.3	13
397	3.8	453	10.4	13.9	7
497	5.3	518	11.5	16.3	1
528	5.6	615	12.3	16	0
99	0.8	278	2.8	6.5	14
0.5	1.1	142	3.1	1.6	12
347	3.6	461	9.6	11.3	6
341	3.5	382	9.8	11.5	5
507	5.1	590	12	15.7	0
400	8.6	517	7	12	8
	-5.3109714	13.58	11.526	0.1746	16.202	-18.859
	1.7054265	1.7705	2.5321	0.0576	3.5444	30.15
	0.9931795	17.649	#N/A	#N/A	#N/A	#N/A
	611.59037	21	#N/A	#N/A	#N/A	#N/A
	952538.94	6541.4	#N/A	#N/A	#N/A	#N/A

the numbers in bold are linear I got from excel. Please help me to continue answer the question it is asked for and it needs to be in the format of the example I have sent you.