ANOVA TEST to Determine Statistical Significance

Running ANOVA test to check whether the total value of ATM transactions using debit cards in India is influenced by the month of the year. The data for the analysis has been obtained from the RBI (Reserve Bank of India) database and can be accessed here:

https://www.rbi.org.in/Scripts/ATMView.aspx

In order to make sure the data is in a format fit for analysis, I have reformated the data to look like the following:

http://falcon80.com/Blogs/wp-content/uploads/2016/03/ATMTRANSACTIONS.xlsx

Null Hypothesis: The value of ATM transactions is not influenced by the time of the year.

SAS Code for the ANOVA Test:

/* Generated Code (IMPORT) */
/* Source File: ATMTransactionsIndia.xlsx */
/* Source Path: /home/isabelleraja0 */
/* Code generated on: Sunday, March 13, 2016 2:13:24 AM */

/* Generated Code (IMPORT) */
/* Source File: ATMTRANSVALUE.xlsx */
/* Source Path: /home/isabelleraja0/sasuser.v94 */
/* Code generated on: Sunday, March 13, 2016 10:50:31 PM */

%web_drop_table(WORK.IMPORT);

FILENAME REFFILE “/home/isabelleraja0/sasuser.v94/ATMTRANSACTIONS.xlsx” TERMSTR=CR;

PROC IMPORT DATAFILE=REFFILE
DBMS=XLSX
OUT=WORK.IMPORT;
GETNAMES=YES;
PROC CONTENTS DATA=WORK.IMPORT;

%web_open_table(WORK.IMPORT);
RUN;
LABEL AVERAGE= “Average Value of ATM debit Card Transactions”;

PROC ANOVA; CLASS Month;
MODEL AVERAGE = Month;
MEANS Month;

RUN;

Output:

Dependent Variable: AVERAGE AVERAGE

Source	DF	Sum of Squares	Mean Square	F Value	Pr > F
Model	11	141511021368	12864638306	0.10	0.9999
Error	44	5.4603717E12	124099357802
Corrected Total	55	5.6018828E12

R-Square	Coeff Var	Root MSE	AVERAGE Mean
0.025261	22.24858	352277.4	1583370

Source	DF	Anova SS	Mean Square	F Value	Pr > F
Month	11	141511021368	12864638306	0.10	0.9999

Inference:

Since the P value =0.99 and is very high, there is not enough evidence to reject the null hypothesis. Since there is not evidence to reject the null hypothesis, there is no need for a post-hoc test.