MBA 646
Professor Carter
Assignment 4
In this assignment there are 2 problems on filtering with tables and 3 on probability.
For the first two problems, insert a table with a Total row. Paste a picture of the last five
rows of your filtered table in each case – including the total row with requested statistics –
and state how many cases there are in the filtered dataset.
Chapter 2: Problem 33 (a-c only)
Chapter 2 problem 35. Answer a-d then the additional three questions below:
e) Remove any filters then show the median value for each of the numerical variables.
Paste a picture of your total row.
f) Add a new column containing the ratio of Debt to Income (You only need to insert a
formula in the first data line to do this). Use an advanced table filter (with a single
criteria range) to find the households that meet all of the following conditions:
i) Monthly payment less than $1400
ii) Utilities greater than $250
iii) First income either less than $35000 or greater than $60000
iv) Debt to first income ratio less than 10%.
Paste a copy of your criteria range and the first 6 rows of the filtered data and
state how many cases were selected.
g) Now use a computed query to filter the data in place. (Note: If you filter in place, it’s
best to move the dataset down a few rows and put the criteria range above the first line
of column headings. So after filtering, the criteria range will always be visible.)
Identify all households that own their own home, live in the southeast or southwest
sector and have a monthly mortgage payment in the top 30% of the monthly payments
for all households. Remember to include this last requirement by inserting a formula in