Share
Explore BrainMass

ANOVA in Megastat for ATM location

Please see attachment and answer , Highlighted question.

Location Number of transactions
Group A Location 1 96
Group B Location 2 102
Group C Location 3 84
Group D Location 4 78

I conducted an ANOVA in the following tables. I was trying to test the best location for a bank to pilot a new type of ATM machines. I based my ANOVA on the atm transactions of 4 different locations . I ran the test through megastat. I am not sure I understand what the results are , can you help me explain it? I used a .05 level of significance to establish if there is a mean daily atm transactions in the 4 locations.
H1= Transactions would be different at the different locations

Ho= Transactions would be the same.

I need a brief explanation below each table:

Table 2 Test Components
Source of Variation Sum of Squares d.f. Mean squares F
between 5.9954E+05 3 1.9985E+05 0.5375
error 1.3237E+08 356 3.7184E+05
total 1.3237E+08 359

Mean 215.99
95% confidence interval for Mean: 93.60 thru 338.4
Standard Deviation 515
High = 1913 Low = 0.000
Median 1.000
Average Absolute Deviation from Median 215

Table 3 above illustrates the number of ATM transactions at location 1 is 96.

Table 4 Group B: Number transaction =102 Calculation Results
Mean 316.40
95% confidence interval for Mean: 197.7 thru 435.1
Standard Deviation 716.
High = 2409. Low = 0.000
Median = 2.000
Average Absolute Deviation from Median 315
Table 4 above illustrates the number of ATM transactions at location number 2 is 102.

Table 4 Group C Calculation results
Mean 229.58
95% confidence interval for Mean 98.74 thru 360.4
Standard Deviation = 576
High = 2276 Low = 0.000

Median 3.000

Average Absolute Deviation from Median = 228.

Table 4 above illustrates the number of ATM transactions at location number 3 is 84.

Table 5 Group D, Calculation Results
Mean 240.62
95% confidence interval for Mean 104.8 thru 376.4
Standard Deviation 602.
High = 2557 Low = 0.000
Median 4.000
Average Absolute Deviation from Median 239

The table above illustrates that the number of transactions at location number four is 78.

Attachments

Solution Summary

The solution provides step by step method for the calculation of ANOVA in Megastat . Formula for the calculation and Interpretations of the results are also included.

$2.19