DATA ANLYSIS RELATED SUBJECT

Direction: compose a short report on the SPSS outputs given on each problem. 15 points each

1.An agent of large car manufacturer wants to determine whether there is a relationship between an individual's income and the price they pay for a car. As such, the individual's "income" is the independent variable and the "price" they pay for a car is the dependent variable. The agent wants to use this information to determine which cars to offer potential customers in new areas where average income is known.

Summarized SPSS output:

ANOVA Sum of Model Squares df Mean Square F Sig. Regression 44182633.37 44182633.37 57.737 .000 Residual 13774291.07 18 765238.393 Total 57956924.44 19 a. Dependent Variable: Price b. Predictors: (Constant), Income Coefficients Standardized Unstandardized Coefficients Coefficients Model B Std. Error Beta Sig. 1 (Constant) 8286.786 1852.256 4.474 .000 Income 564 074 873 7.598 000 a. Dependent Variable: Price\fCorrelations Correlations expenditure sales expenditure Pearson Correlation 1 951 * Sig. (2-tailed) 000 N 10 10 sales Pearson Correlation 951* 1 Sia. (2-tailed) 000 10 10 * Correlation is significant at the 0.01 level (2-tailed). Regression| Model Summary Adjusted R Std. Error of the Model R R Square Square Estimate 951= 905 893 5.65142 a. Predictors: (Constant), expenditure ANOVAa Model Sum of Squares df Mean Square F Sig 1 Regression 2424.492 2424.492 75.911 000b Residual 255.508 CO 31.939 Total 2680.000 a. Dependent Variable: sales b. Predictors: (Constant), expenditure Coefficientsa Standardized Unstandardized Coefficients Coefficients Model B Std. Error Beta Sig. 1 (Constant) 55.246 5.330 10.364 DO0 expenditure 2.574 295 951 8.713 000 a. Dependent Variable: sales