a$)$ You have been provided with "ATM withdrawal Data" in Excel.

Data description: Number of ATM withdrawals from one of the ATMs located in

Nairobi CBD$.$

i$.$ Key in the data into SPSS: $($print the screen for variable view and data view$)$

Data description: Number of ATM withdrawals from one of the ATMs located in

Nairobi CBD$.$

i$.$ Key in the data into SPSS: $($print the screen for variable view and data view$)$

$(2$ marks$)$

ii$.$ Construct appropriate frequency distribution table with appropriate

intervals

$(4$ marks$)$

b$)$ Using test$\_$scores.sav data perform exploratory data analysis for "pre$-$test scores"

for "non$-$public school type"

$($a$)$ Using customer$\_$subset.sav data:

i$.$ Generate and interpret an appropriate graph$/$ chart that can be used to

compare Amount spent on primary card last month by different Income

categories in thousands. State the reasons for your graph selection

$(4$ marks$)$

ii$.$ Generate and interpret an appropriate graph$/$ chart that can be used to

compare relationship between Household income in thousands and Credit

card debts in thousands by gender. State the reasons for your graph

selection

$(5$ marks$)$