Course Project AJ DAVIS DEPARTMENT STORES… – Professional Essay Writing Service

Course Project: AJ DAVIS DEPARTMENT STORES
.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#1″>Introduction|.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#2″>Project
Part A: Exploratory Data Analysis|.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#3″>Project
Part A: Grading Rubric|.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#4″>Project
Part B: Hypothesis Testing and Confidence Intervals|.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#5″>Project
Part B: Grading Rubric|.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#6″>Project
Part C: Regression and Correlation Analysis|.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#7″>Project
Part C: Grading Rubric

Introduction

.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#top”>.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#top”>.0/msohtmlclip1/01/clip_image001.gif” alt=”Back to top”>.next.ecollege.com/(NEXT(c272f9a6ef))/Main/CourseMode/VizedHtmlView/RenderVizedHtmlView.ed?courseItemSubId=289453118&courseItemType=CourseContentItem&#top”>

AJ DAVIS is a department store chain, which has many credit
customers and wants to find out more information about these customers. A sample
of 50 credit customers is selected with data collected on the following five
variables:

LOCATION (Rural,
Urban, Suburban)
INCOME (in
$1,000’s â€“ be careful with this)
SIZE (Household
Size, meaning number of people living in the household)
YEARS (the number
of years that the customer has lived in the current location)
CREDIT BALANCE
(the customers current credit card balance on the store’s credit card, in
$).

The data appears below, and is available in Doc Sharing Course
Project Data Set as an EXCEL file:

LOCATION

INCOME($1000)

SIZE

YEARS

CREDIT BALANCE($)

Urban

4016

Rural

3159

Suburban

5100

Suburban

4742

Rural

1864

Urban

4070

Rural

2731

Urban

3348

Suburban

4764

Urban

4110

Urban

4208

Urban

4219

Rural

2477

Rural

2514

Urban

4214

Suburban

4965

Urban

4412

Urban

2448

Rural

2995

Urban

4171

Suburban

5678

Urban

3623

Suburban

5301

Rural

3020

Urban

4828

Suburban

5573

Rural

2583

Rural

3866

Urban

3586

Suburban

5037

Rural

3605

Urban

5345

Urban

5370

Urban

3890

Urban

4705

Urban

4157

Suburban

3579

Urban

3890

Suburban

2972

Rural

3121

Urban

4183

Suburban

3730

Suburban

4127

Rural

2921

Urban

4603

Suburban

4273

Rural

3067

Rural

3074

Suburban

4820

Suburban

5149

PROJECT PART A: Exploratory Data
Analysis

Open the file
MATH533 Project Consumer.xls from the Course Project Data Set folder in
Doc Sharing.
For each of the
five variables, process, organize, present and summarize the data. Analyze
each variable by itself using graphical and numerical techniques of
summarization. Use MINITAB as much as possible, explaining what the
printout tells you. You may wish to use some of the following graphs:
stem-leaf diagram, frequency/relative frequency table, histogram, boxplot,
dotplot, pie chart, bar graph. Caution: not all of these are appropriate
for each of these variables, nor are they all necessary. More is not
necessarily better. In addition be sure to find the appropriate measures
of central tendency, and measures of dispersion for the above data. Where
appropriate use the five number summary (the Min, Q1, Median, Q3, Max).
Once again, use MINITAB as appropriate, and explain what the results mean.
Analyze the
connections or relationships between the variables. There are ten pairings
here (Location and Income, Location and Size, Location and Years, Location
and Credit Balance, income and Size, Income and Years, Income and Balance,
Size and Years, Size and Credit Balance, Years and Credit Balance). Use
graphical as well as numerical summary measures. Explain what you see. Be
sure to consider all 10 pairings. Some variables show clear relationships,
while others do not.
Prepare your
report in Microsoft Word (or some other word processing package),integrating your graphs and
tables with text explanations and interpretations.Be sure that you have graphical
and numerical back up for your explanations and interpretations. Be
selective in what you include in the report. I’m not looking for a 20 page
report on every variable and every possible relationship (that’s 15 things
to do). Rather what I want you do is to highlight what you see forthree individual variables(no more than 1 graph for each,
one or two measures of central tendency and variability (as appropriate),
and two or three sentences of interpretation). For the 10 pairings,
identify and report only onthree of the pairings,
again using graphical and numerical summary (as appropriate), with
interpretations.Please
note that at least one of your pairings must include Location and at least
one of your pairings must not include Location.

Project Part A
report is due by the end of Week 2.
Project Part A
is worth 100 total points. See grading rubric below.

Submission: The report from part 4 including all relevant graphs
and numerical analysis along with interpretations.
Format for report:

Brief
Introduction
Discuss your 1st
individual variable, using graphical, numerical summary and interpretation
Discuss your 2nd
individual variable, using graphical, numerical summary and interpretation
Discuss your 3rd
individual variable, using graphical, numerical summary and interpretation
Discuss your 1st
pairing of variables, using graphical, numerical summary and
interpretation
Discuss your 2nd
pairing of variables, using graphical, numerical summary and
interpretation
Discuss your 3rd
pairing of variables, using graphical, numerical summary and
interpretation
Conclusion

Project Part A: Grading Rubric

Category

Points

Description

Addressing
each speculation – 20 pts. each

hypothesis
test, interpretation, confidence interval and interpretation

Summary
report

1
paragraph on each of the speculations

Total

100

A
quality paper will meet or exceed all of the above requirements.

Project Part C: Regression and Correlation Analysis

Using MINITAB perform the regression and correlation analysis for
the data on CREDIT BALANCE (Y) and SIZE (X) by answering the following.

Generate a
scatterplot for CREDIT BALANCE vs. SIZE, including the graph of the
“best fit” line. Interpret.
Determine the
equation of the “best fit” line, which describes the
relationship between CREDIT BALANCE and SIZE.
Determine the
coefficient of correlation. Interpret.
Determine the
coefficient of determination. Interpret.
Test the utility
of this regression model (use a two tail test with α =.05). Interpret your
results, including the p-value.
Based on your
findings in 1-5, what is your opinion about using SIZE to predict CREDIT
BALANCE? Explain.
Compute the 95%
confidence interval for beta-1 (the population slope). Interpret
this interval.
Using an
interval, estimate the average credit balance for customers that have
household size of 5. Interpret this interval.
Using an
interval, predict the credit balance for a customer that has a household
size of 5. Interpret this interval.
What can we say
about the credit balance for a customer that has a household size of 10?
Explain your answer.

In an attempt to improve the model, we attempt to do a multiple
regression model predicting CREDIT BALANCE based on INCOME, SIZE and YEARS.

Using MINITAB
run the multiple regression analysis using the variables INCOME, SIZE and
YEARS to predict CREDIT BALANCE. State the equation for this multiple
regression model.
Perform the
Global Test for Utility (F-Test). Explain your conclusion.
Perform the
t-test on each independent variable. Explain your conclusions and clearly
state how you should proceed. In particular, which independent variables
should we keep and which should be discarded.
Is this multiple
regression model better than the linear model that we generated in parts
1-10? Explain.
All

Summarize your results from 1-14 in a report that is three pages
or less in length and explains and interprets the results in ways that are
understandable to someone who does not know statistics.
Submission: The summary report + all of the work done in 1-14
(Minitab Output + interpretations) as an appendix.
Format:

Summary Report
Points 1-14
addressed with appropriate output, graphs and interpretations. Be sure to
number each point 1-14.

Project Part C: Grading Rubric