In August 20, 2007 we asked the Department of Veterans Affairs to provide us two pieces of information under the Freedom of Information Act. We asked them for the budget of the Office of Information in the last decade (this office was recently organized and the FOIA officer had to estimate what the budget of the office would have been prior to the re-organization). We also asked for the number of patient records in VistA database. On October 16th 2007 they provided us with the following information.

Fiscal Year	Budget of Office of Information	Number of Records in VistA	VHA Cost per Patient Index
2004	533,190,714	4,976,773	0.8%
2003	316,467,395	4,806,871	-4.6%
2002	245,998,730	4,545,559	-9.1%
2001	187,087,714	4,088,075	-7.3%
2000	171,353,392	3,673,612	-6.5%
1999	203,211,123	3,425,474	-8.6%
1998	199,997,062	3,273,020	-6.2%
Table 2: Investment in IT, Use of VistA and Cost per Patient Index

2. Calculate the correlations between (a) index on cost of care per patient, (b) number of records in VistA system and the budget of the office of information.

3. Provide scatter diagram showing the relationship between IT investment (budget of Office of Information) and cost of care (VHA cost per Patient Index)?

4. What came first, IT investment or changes in cost of care?

answer the question 2, 3, 4

also provide the information with steps on how to do those. and please provide screen shots step by step.

in Excel

1. In August 20, 2007 we asked the Department of Veterans Affairs to provide us two pieces of information under the Freedom of Information Act. We asked them for the budget of the Office of Information in the last decade (this office was recently organized and the FOIA officer had to estimate what the budget of the office would have been prior to the re- organization). We also asked for the number of patient records in Vista database. On October 16th 2007 they provided us with the following information: Fiscal Year Budget of Office Number of of Information Records in Vista VHA Cost per Patient Index 533,190,714 2004 4,976,773 0.8% 2003 316,467,395 4,806,871 -4.6% 2002 245,998,730 4,545,559 -9.1% -7.3% 2001 187,087,714 4,088,075 2000 171,353,392 3,673,612 -6.5% 1999 203,211,123 3,425,474 -8.6% 1998 199,997,062 3,273,020 -6.2% Table 2: Investment in IT, Use of VistA and Cost per Patient Index 2. Calculate the correlations between (a) index on cost of care per patient, (b) number of records in VistA system and the budget of the office of information. 3. Provide scatter diagram showing the relationship between IT investment (budget of Office of Information) and cost of care (VHA cost per Patient Index)? How 4. What came first, IT investment or changes in cost of care? How 1. In August 20, 2007 we asked the Department of Veterans Affairs to provide us two pieces of information under the Freedom of Information Act. We asked them for the budget of the Office of Information in the last decade (this office was recently organized and the FOIA officer had to estimate what the budget of the office would have been prior to the re- organization). We also asked for the number of patient records in Vista database. On October 16th 2007 they provided us with the following information: Fiscal Year Budget of Office Number of of Information Records in Vista VHA Cost per Patient Index 533,190,714 2004 4,976,773 0.8% 2003 316,467,395 4,806,871 -4.6% 2002 245,998,730 4,545,559 -9.1% -7.3% 2001 187,087,714 4,088,075 2000 171,353,392 3,673,612 -6.5% 1999 203,211,123 3,425,474 -8.6% 1998 199,997,062 3,273,020 -6.2% Table 2: Investment in IT, Use of VistA and Cost per Patient Index 2. Calculate the correlations between (a) index on cost of care per patient, (b) number of records in VistA system and the budget of the office of information. 3. Provide scatter diagram showing the relationship between IT investment (budget of Office of Information) and cost of care (VHA cost per Patient Index)? How 4. What came first, IT investment or changes in cost of care? How