Is There A Correlation Between Amount Of The Bank Balances And The Frequency Of ATM Use …

Two or more Sample Hypothesis testing paper (Century National Bank Data Set) Develop one business research question from which you will formulate a research hypothesis test of two population or more than two populations. Here is the research question “”Is there a correlation between amount of the bank balances and the frequency of ATM use?” Prepare a 1,050 to 1750 word paper describing the results of a hypothesis test of two populations or more than two populations Include the following in your paper: Formulate both a numerical and verbal hypothesis statement regarding your research issue. Here are the numerical and verbal hypothesis statements: Does city 2 have a greater mean account balance than city 3? H0: µ1 – µ2 0 Is the mean the ATM use of city 2 equal to city 3? H0: µ1 – µ2 = 0 H1: µ1 – µ2 ≠ 0 The mean account balance of City 2 is 1,879.65 with a standard deviation of 350.88. The mean account balance of City 3 is 1,359.79 with a standard deviation of 683.07. The mean ATM use of City 2 is 11.29 with a standard deviation of 3.5 and City 3 has a mean ATM use of 10 with a standard deviation of 4.2. Preform the five-step hypothesis test on data pertaining to your selection. Describe the results of your test, and explain how the findings from this hypothesis testing can be used to answer your research question. Include raw data tables and the results of your computations in your paper, using graphical and tabular methods of displaying data and results. I just need help with “perform the five-step hypothesis test on data pertaining to your selection”.
Must also include a bell shape curve to show the comparison.
the data set is as follows:
Legend:
X1: Account Balance in dollars
X2: Number of ATM transactions in the month
X3: Number of other bank services used
X4: Has a debit card (0=no, 1=yes)
X5: Receives interest on the account (0=no, 1=yes)
X6: City where banking is done
60 accounts
Balance, ATM, Services, Debit Interest, City,
1756 13 4 0 1 2
748 9 2 1 0 1
1501 10 1 0 0 1
1831 10 4 0 1 3
1622 14 6 0 1 4
1886 17 3 0 1 1
740 6 3 0 0 3
1593 10 8 1 0 1
1169 6 4 0 0 4
2125 18 6 0 0 2
1554 1 2 6 1 0 3
1474 12 7 1 0 1
1913 6 5 0 0 1
1218 10 3 1 0 1
1006 12 4 0 0 1
2215 20 3 1 0 4
137 7 2 0 0 3
167 5 4 0 0 4
343 7 2 0 0 1
2557 20 7 1 0 4
2276 15 4 1 0 3
1494 11 2 0 1 1
2144 17 3 0 0 3
1995 10 7 0 0 2
1053 8 4 1 0 3
1526 8 4 0 1 2
1120 8 6 1 0 3
1838 7 5 1 1 3
1746 11 2 0 0 2
1616 10 4 1 1 2
1958 6 2 1 0 2
634 2 7 1 0 4
580 4 1 0 0 1
1320 4 5 1 0 1
1675 6 7 1 0 2
789 8 4 0 0 4
1735 12 7 0 1 3
1784 11 5 0 0 1
1326 16 8 0 0 3
2051 14 4 1 0 4
1044 7 5 1 0 1
1885 10 6 1 1 2
1790 11 4 0 1 3
765 4 3 0 0 4
1645 6 9 0 1 4
32 2 0 0 0 3
1266 11 7 0 0 4
890 7 1 0 1 1
2204 14 5 0 0 2
2409 16 8 0 0 2
1338 14 4 1 0 2
2076 12 5 1 0 2
1708 13 3 1 0 1
2138 18 5 0 1 4
2375 12 4 0 0 2
1455 9 5 1 1 3
1487 8 4 1 0 4
1125 6 4 1 0 2
1989 12 3 0 1 2
2156 14 5 1 0 2