20180608002405project_part_b___reliable_housewares_201830 x20180608001834project_data___reliable_housewares_201830__2_.xlsx
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.
- The average annual income of credit customers is less than $50,000.
- The true population proportion of credit customers who live in an urban area exceeds 40%.
- The average number of years lived in the current home is less than 13 years.
- The average credit balance for suburban customers is at most $4,300.
- 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.
- Follow your work in (i) with computing a confidence interval for each of the variablesdescribed in (a) though (d). Interpret these intervals.
- 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.
- All DeVry University policies are in effect, including the plagiarism policy.
- Project Part B report is due by the end of Week 6.
- Project Part B is worth 100 total points. See grading rubric below
PROJECT PART B
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
Category
Points
%
Description
Executive Summary
20
20
One or two paragraphs on each of the speculations. Explain your conclusions in simple, cohesive, and concise way. Management does not know statistics.
Addressing each speculation – 20 pts. each
80
80
Hypothesis test, claim, confidence interval, p-value, and interpretations
Total
100
100
A quality paper will meet or exceed all of the above requirements. They will be concise, clear, and to the point. Also, since this is a graduate level course, spelling, grammar, clarity, logic, cohesiveness, and adherence to the above format are expected and will result in point deductions if not met.
2 | Page
>Sheet 00)
2 12 4 5 2 4 2 9 1 2 7 4 10 3 0
3 11 1 19 2 12 3 12 4
4 2
8
1
6 13 8
6 14 5 5 2 11 3 18 4 4 3,890 2 18 1 11 7 17 2 14 5 13 1 7
2
1
Location
Income
($
10
Size
Years
Credit
Balance ($)
Urban
5
4
3
12
4,0
1
6
Rural
30
3,
15
9
Suburban
32
1
7
5,100
Suburban
50
14
4,7
42
Rural
31
1,
8
64
Urban
55
4,070
Rural
37
20
2,731
Urban
40
3,3
48
Suburban
66
4,764
Urban
51
16
4,
11
Urban
25
4,208
Urban 48 4 16
4,2
19
Rural
27
2,477
Rural
33
2,514
Urban
65
4,
21
Suburban
63
13
4,965
Urban 55 6 15
4,
41
Urban 21 2
18
2,
44
Rural 44 1 7
2,995
Urban 37 5 5
4,
17
Suburban
62
5,
67
Urban 21 3 16
3,6
23
Suburban 55 7 15
5,301
Rural 42 2 19
3,020
Urban 41 7 18
4,828
Suburban
54
5,573
Rural 30 1 14
2,583
Urban 48 2 8
3,866
Urban
34
3,586
Suburban 67 4 13
5,037
Rural 50 2 11
3,605
Urban 67 5 1
5,345
Urban 55 6 10
5,370
Urban
52
3,890
Urban 62 3 2
4,705
Urban 64 2 6
4,157
Suburban
22
3,899
Urban
29
Suburban
39
2,972
Rural
35
3,121
Urban 39 4 15
4,183
Suburban 54 3 9
3,730
Suburban 23 6 18
4,127
Rural 27 2 1
2,921
Urban
26
4,603
Suburban
61
4,273
Rural 30 2 14
3,067
Rural 22 4 16
3,0
74
Suburban
46
4,820
Suburban 66 4 20
5,149
Rural
53
2845
Urban 44 6 5
3962
Suburban 74 7 12
5394
Urban 25 3 15
3442
Suburban 66 7 14
5036
Sheet2
Sheet3
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
