The file credit.xls contains a recent survey about 50 consumers. The data were collected on annual income, household size, and annual credit card charges. You are to analyze the data and write a managerial report on your findings using EXCEL or PHStat2. The following is a minimum guideline about what you should analyze. You need to perform more in-depth analysis for a better grade than a C. For example, you may have to use such tools as confidence interval estimates, one or two-sample hypothesis tests on the data to improve the quality of your report.
State statistical objective(s) for the project. You state clearly what you are going to report in your project.
Perform EDA (Section 3.3) including numerical descriptive measures. Comment on the findings.
Construct scatter diagrams for pairs of variables. Do any of these appear to have some association?
From (b) and (c), does any simple linear model appear to hold? You may want to run some testing to substantiate your findings.
Does a multiple regression model appear to hold? You may want to run some testing to substantiate why or why not. If so, is there more than one variable that may be used as a dependent variable?
Is the regression significant? Report the results of the appropriate test, and interpret its meaning.
Discuss the need for other independent variables that could be added to the model. What additional variables might be helpful?
Do you find any dummy variable in the model that makes a significant contribution to the model?
Summarize and comment on your results and an applicability of your model equation(s).
Subject | Mathematics |
Due By (Pacific Time) | 08/15/2015 12:00 am |
Tutor | Rating |
---|---|
pallavi Chat Now! |
out of 1971 reviews More.. |
amosmm Chat Now! |
out of 766 reviews More.. |
PhyzKyd Chat Now! |
out of 1164 reviews More.. |
rajdeep77 Chat Now! |
out of 721 reviews More.. |
sctys Chat Now! |
out of 1600 reviews More.. |
sharadgreen Chat Now! |
out of 770 reviews More.. |
topnotcher Chat Now! |
out of 766 reviews More.. |
XXXIAO Chat Now! |
out of 680 reviews More.. |