Reliable Housewares is a local store that sells many household items and issues its own credit card to its customers. The store manager wants to study the purchasing behavior of its "credit" customers. To that end, he has come to DeVry and asked our MBA students for help. The manager has brought with him data on five variables of 55 randomly selected credit customers.

· LOCATION (Rural, Urban, Suburban – Household location of the credit customer)

· INCOME (in $1,000's – be careful with this)

· SIZE (Household Size – number of people living in the household of credit customer)

· YEARS (the number of years that the customer has lived in the current location)

· CREDIT BALANCE ($ balance on customer’s store credit card)

Hypothesis Testing and Confidence Intervals

The Reliable Housewares store manager wants to learn more about the purchasing behavior of its "credit" customers. In fact, he is speculating about four specific cases shown below (a) through (d) and wants you to help him test their accuracy.

a. The average annual income of credit customers is less than $50,000.

b. The true population proportion of credit customers who live in an urban area exceeds 40%.

c. The average number of years lived in the current home is less than 13 years.

d. The average credit balance for suburban customers is at most $4,300.

i. Using the dataset provided in the course shell, perform the hypothesis test for each of the above speculations (a) through (d) in order to see if there is an statistical evidence to support the manager’s belief.  In each case, use the Seven Elements of a Test of Hypothesis , in Section 7.1 of your textbook (on or about Page 361). Use α=5% for all your analyses. Explain your conclusion in simple terms.  Also be sure to indicate which hypothesis is the “claim”, compute the p-value, and interpret your results.

ii. Follow your work in (i) with computing a confidence interval for each of the variables described in (a) though (d). Interpret these intervals.

iii. Write an executive summary for the Reliable Housewares store manager about your analysis, distilling down the results in a way that would be understandable to someone who does not know statistics.  Clear explanations and interpretations are critical.

iv. All DeVry University policies are in effect, including the plagiarism policy.

v. Project Part B report is due by the end of Week 6.

vi. Project Part B is worth 100 total points. See grading rubric below.

Submission: A report in Microsoft Word containing the following:

· The summary report from (iii) above. This will make the body of your report

· All of the relevant work done in the hypothesis testing (including your Excel calculations showing the excel functions or Excel calculator outputs) in Part (i). This will be in Appendix

· All of the relevant work done in calculating confidence intervals (using Excel Calculator outputs or Excel functions) in Part (ii). This will be in Appendix

Report Format:

I. Executive Summary – This will be the summary of your findings to the management of Reliable Housewares. It will have four sections (A) through (D) corresponding to the four speculations (a) through (d). Each section will be about one or two paragraphs long. Clarity and conciseness in your conclusions are key here. Avoid using technical terminologies in this section.

II. Appendix – Your report will have four appendices (A) through (D) corresponding to the four speculations (a) through (d). In each appendix, indicate all the steps in hypothesis testing (i.e., the Seven Elements of a Test of Hypothesis in Section 6.1 of your text book). Don’t forget to mark which hypothesis is the claim and interpret your findings. Also, show your results for the confidence interval and the p-value for each speculation. Include all relevant Excel outputs.

Project Part B: Grading Rubric

2 | Page