Question

In: Operations Management

Consider the two variables service quality and customer satisfaction. Service quality is independent variable and customer...

Consider the two variables service quality and customer satisfaction. Service quality is independent variable and customer satisfaction is dependent variable. Perform regression analysis using SPSS and explain the results.

PLEASE USE SPSS ONLY AND PASTE THE OUTPUT OF SPSS. DO NOT USE EXCEL OR ANY OTHER SOFTWARE. SPSS ONLY PLEASE.

SERVICE QUALITY

CUSTOMER SATISFACTION

2

1

3

2

4

4

5

7

6

6

7

7

8

9

6

11

6

9

4

5

5

4

6

7

2

3

10

11

8

5

9

6

11

2

11

4

13

8

2

8

4

8

3

9

1

1

2

2

2

3

1

4

2

5

4

5

5

6

6

3

7

4

2

4

2

5

2

6

1

4

4

4

13

11

12

11

1

2

2

2

4

4

4

4

6

6

7

5

3

4

1

2

3

3

4

5

6

6

7

7

2

2

3

3

1

4

5

4

5

1

Solutions

Expert Solution

  REGRESSION ANALYSIS OUTPUT EXPLANATION

Model Summary

Model

R

R Square

Adjusted R Square

Std. An error of the Estimate

Change Statistics

Durbin-Watson

R Square Change

F Change

df1

df2

Sig. F Change

1

.558a

.312

.298

2.684

.312

23.527

1

52

.000

.932

a. Predictors: (Constant), SATISFACTIONQUALITY

b. Dependent Variable: CUSTOMER SATISFACTION

Analysis- By looking at the above regression table, it can be said that there is a significant relationship between satisfaction quality and customer satisfaction ie. customer satisfaction is dependent on the quality of satisfaction, a customer gets on using a product or service. The value of R represents the correlation value between the dependent and the independent variable. The value of .558 does not represent a high correlation, but a significant correlation. The R square value depicts that 31.2 % of the variation in customer satisfaction is explained by the satisfaction quality. The value of Durbin Watson shows that there is autocorrelation between the residuals.

ANOVA

Model

Sum of Squares

df

Mean Square

F

Sig.

1

Regression

169.485

1

169.485

23.527

.000a

Residual

374.608

52

7.204

Total

544.093

53

a. Predictors: (Constant), SATISFACTIONQUALITY

b. Dependent Variable: CUSTOMER SATISFACTION

This above ANOVA table predicts that the regression table significantly predicts the relation between satisfaction quality and customer satisfaction.

Coefficients

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Collinearity Statistics

B

Std. Error

Beta

Tolerance

VIF

1

(Constant)

1.515

.782

1.937

.058

SATISFACTIONQUALITY

.664

.137

.558

4.850

.000

1.000

1.000

a. Dependent Variable: CUSTOMER SATISFACTION

This table shows that satisfaction quality has a significant relationship with customer relationships and has a significant contribution to the model formed by regression analysis. The VIF score of 1 indicates that there is a low multi collinearity among the variables as the score of VIF <3.

The model of the equation is  

Customer satisfaction = 1.515 + .664 (Satisfaction Quality)


Related Solutions

Consider the following data for a dependent variable and two independent variables, and . x1= 30...
Consider the following data for a dependent variable and two independent variables, and . x1= 30 46 24 50 41 51 74 36 60 77. x2 = 13 11 17 17 6 20 8 12 13 16. y = 95 109 112 178 94 176 170 117 142 212 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating to y to x1 . Predict y if...
Consider the following data for a dependent variable y and two independent variables, x2 and x1....
Consider the following data for a dependent variable y and two independent variables, x2 and x1. x1 x2 y 30 12 94 46 10 109 24 17 113 50 17 179 41 5 94 51 19 175 75 8 171 36 12 118 59 13 143 77 17 212 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to x1 . Predict y if x1=45....
Consider the following data for a dependent variable y and two independent variables, x1 and x2.
You may need to use the appropriate technology to answer this question. Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 12 93 47 10 108 25 17 112 51 16 178 40 5 94 51 19 175 74 7 170 36 12 117 59 13 142 76 16 211 The estimated regression equation for these data is ŷ = −18.89 + 2.02x1 + 4.74x2. Here, SST = 15,276.0,...
Consider the following data for a dependent variable y and two independent variables, x1 and x2....
Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 12 94 47 10 108 25 17 112 51 16 178 40 5 94 51 19 175 74 7 170 36 12 117 59 13 142 76 16 209 The estimated regression equation for these data is ŷ = −17.02 + 1.99x1 + 4.70x2. Here, SST = 14,902.9, SSR = 13,773.1, sb1 = 0.2470, and sb2 = 0.9480. (1a) Test...
Consider the following data for a dependent variable y and two independent variables, x1 and x2....
Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 13 95 46 10 108 25 18 113 50 16 179 40 5 95 51 20 176 74 7 170 36 12 117 59 13 142 77 16 211 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to x1. ŷ =_________ +___________ x1 Predict...
Consider the following data for a dependent variable y and two independent variables, x1 and x2....
Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 12 95 47 10 108 25 17 112 51 16 178 40 5 94 51 19 175 74 7 170 36 12 117 59 13 142 76 16 212 The estimated regression equation for these data is ŷ = −18.52 + 2.01x1 + 4.75x2. Here, SST = 15,234.1, SSR = 14,109.8, sb1 = 0.2464, and sb2 = 0.9457. (a)Test for...
Consider the following data for a dependent variable y and two independent variables, x1and x2. x...
Consider the following data for a dependent variable y and two independent variables, x1and x2. x 1 x 2 y 29 13 94 47 10 109 24 17 113 50 16 178 40 6 95 52 20 176 75 7 171 37 13 118 59 14 142 77 17 211 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to x1. ŷ =  +  x1 Predict y...
In the various sales and service industries, the satisfaction of the customer is paramount to the...
In the various sales and service industries, the satisfaction of the customer is paramount to the success of a product and company. Share at least two dominant factors for a company to consider in order to earn the satisfaction of the customer and keep the customers satisfied.
Given here are the data from a dependent variable and two independent variables. The second independent...
Given here are the data from a dependent variable and two independent variables. The second independent variable is an indicator variable with several categories. Hence, this variable is represented by x2, x3, and x4. How many categories are there for this independent variable? Use a computer to perform a multiple regression analysis on this data to predict y from the x values. Discuss the output and pay particular attention to the dummy variables. y x1 x2 x3 x4 11 1.9...
I am conducting ANOVA two ways tests. With two independent variables and one independent variable. the...
I am conducting ANOVA two ways tests. With two independent variables and one independent variable. the testing is about whether gender and income affect the purchase. after getting the result, how can I know which independent variables that affect the most? and why?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT