query

[efeedback]

Have tables and queries set up in access. Trying to get excel query to look at and retrieve data for analysis. Can view the access database file but query cannot see any tables or queries in the file.

Any ideas??

 

[efeedback]

I am not sure which application is best for analysis. The data is in an access database.

I need to make statistical calculations for the results of survey data (around 40 questions); the basic calculations are Count, Percentages of those Counts, Average(Mean), Standard Deviation and Standard Error.

The survey has category data (around 9); using this I need to be able to break down the totals and make the same calculations for each category.

I am not sure which is the best for this. With 40 questions and 9 categories there are lots of cals to make. I would like to find a way of not writing loads of forumals or at least writing one sheet for question 1 and then being able to copy it for question 2 with a find|replace on the cells references.

The sort of output is below.

I was trying to use array forulas in excel, is there a simple way in access?

pdd data.xls
	A	B	C	D	E
1	q1a
2		Totals	UK	EUR	NONEU
3	Responses	49	39	9	1
4
5	1	20	16	3	1
6
7	2	23	18	5	0
8
9	3	0	0	0	0
10
11	4	4	3	1	0
12
13	5	2	2	0	0
14
15	Mean	1.8776	0.0979	0.0433	0.0125
16	StdDev	1.0534	0.4866	0.3124	0.1118
17	StdErr	0.0094	0.0049	0.0065	0.0070
Sheet1