Use the following data Attached to answer the questions belowNO OUTSIDE SOURCES: Cards number of credit cards

Use the following data (Attached) to answer the questions below(NO OUTSIDE SOURCES!!!):
Cards = number of credit cards used
Size = number of individuals in a family
Income = family income measured in thousands
Autos = number of automobiles owned per family
Q1. Use the correlation matrix to determine which independent variable has the strongest relationship with the dependent variable.
Q2. Confirm your results running 3 separate regressions.
Q3. Use your regression of “cards” on “size” to interpret the following: 1) the intercept coefficient, 2) the slope coefficient, and 3) the coefficient of determination.
Construct a scattergram that relates predicted values and actual values to “size” (make sure that you “connect” predicted values).
Q4. Now, regress “cards” on both “size” and “income” before reinterpreting the results.
Is income statistically significant?
Should “income” be retained in the model?
Q5. Regress “cards” on all 3 independent variables.
Use Stata to “store” all 3 regressions before constructing a summary table of results.
Which model is best?
How can we determine whether to add an additional variable to our model?
Q6. Finally, use your final mathematical model to 1) predict card usage for each family in your data set and 2) predict the “errors” for each family in your dataset.
Use this data to manually solve for the standard error of the regression (please show your work).

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

Place Order