Question

No	price satisfaction	design satisfaction	performance satisfaction	overall customer satisfaction
1	1	2	2	3
2	2	2	7	7
3	4	5	5	6
4	4	3	3	6
5	4	6	1	3
6	6	2	7	7
7	2	5	3	4
8	1	2	6	6
9	2	4	3	3
10	7	1	3	7
11	3	7	6	6
12	7	3	2	5
13	5	4	1	3
14	1	2	4	4
15	2	3	6	6
16	4	2	3	6
17	3	6	3	5
18	2	5	2	3
19	7	2	2	6
20	3	6	2	3
21	1	1	7	7
22	3	3	2	5
23	7	7	6	7
24	4	1	3	5
25	3	4	1	2
26	6	1	6	7
27	4	7	2	5
28	6	5	6	7
29	4	3	4	4
30	6	1	4	7
31	2	7	6	7
32	5	6	4	7
33	3	6	5	7
34	7	7	5	6
35	1	1	2	3
36	6	4	3	5
37	4	3	1	4
38	3	4	2	3
39	7	1	2	5
40	7	4	5	7
41	6	3	3	5
42	1	2	1	2
43	4	2	1	3
44	6	3	7	7
45	3	1	4	5
46	6	2	1	4
47	4	3	5	7
48	2	6	6	5
49	4	1	7	7
50	3	2	4	5
51	3	3	2	3
52	2	2	2	3
53	1	2	4	4
54	3	3	2	4
55	6	3	3	6
56	7	4	2	4
57	2	1	4	5
58	2	3	6	5
59	5	1	4	6
60	4	3	4	6
61	7	4	6	7
62	1	4	3	3
63	2	2	4	4
64	4	2	5	5
65	7	1	1	4
66	2	3	5	7
67	1	6	3	3
68	1	2	5	5
69	5	2	4	6
70	5	5	3	6
71	3	6	3	4
72	1	3	2	4
73	5	6	7	7
74	2	4	1	2
75	4	2	1	5
76	7	7	2	4
77	3	1	2	3
78	2	2	1	3
79	3	3	4	5
80	4	3	3	4
81	3	1	7	7
82	1	2	7	6
83	7	2	4	6
84	5	2	7	7
85	4	3	3	5
86	1	3	4	4
87	2	3	5	5
88	7	1	1	4
89	2	2	2	4
90	7	4	7	7
91	3	3	6	7
92	3	4	5	5
93	6	1	2	4
94	1	1	2	2
95	6	1	1	3
96	7	2	2	5
97	4	3	2	3
98	4	2	5	7
99	3	5	1	2
100	5	2	1	2

Download the excel file, "Data for Exam 1" under Course Content.

Run a regression to examine the influence of three independent variables (price satisfaction, design satisfaction, performance satisfaction) on the dependent variable (overall customer satisfaction).

Save the result sheet.

Submit the file here.

QUESTION 2

1. What is the coefficient of price satisfaction?

5 points   

QUESTION 3

1. What is the coefficient of design satisfaction?

5 points   

QUESTION 4

1. What is the coefficient of performance satisfaction?

5 points   

QUESTION 5

1. Is the following statement true or false?

   "Considering the p-value of price satisfaction in the result, the influence of price satisfaction on overall customer satisfaction is statistically significant"

   True

   False

5 points   

QUESTION 6

1. Is the following statement true or false?

   "Considering the p-value of design satisfaction in the result, the influence of design satisfaction on overall customer satisfaction is statistically significant"

   True

   False

5 points   

QUESTION 7

1. Is the following statement true or false?

   "Considering the p-value of performance satisfaction in the result, the influence of performance satisfaction on overall customer satisfaction is statistically significant"

   True

   False

Answer 1

21-02-2020 15:08:11

Ordinary Least Squares Estimation   
*******************************************************************************
Dependent variable is Y
100 observations used for estimation from 1 to 100
*******************************************************************************
Regressor Coefficient Standard Error T-Ratio[Prob]
INPT 1.4966 .25481 5.8732[.000]
X1 .30303 .038755 7.8191[.000]
X2 -.038329 .043735 -.87638[.383]
X3 .66280 .040207 16.4847[.000]
*******************************************************************************
R-Squared .77089 R-Bar-Squared .76373
S.E. of Regression .76652 F-Stat. F(3,96) 107.6688[.000]
Mean of Dependent Variable 4.9100 S.D. of Dependent Variable 1.5769
Residual Sum of Squares 56.4055 Equation Log-likelihood -113.2636
Akaike Info. Criterion -117.2636 Schwarz Bayesian Criterion -122.4740
DW-statistic 2.0599
*******************************************************************************


Diagnostic Tests
*******************************************************************************
* Test Statistics * LM Version * F Version *
*******************************************************************************
* * * *
* A:Serial Correlation*CHSQ(1) = .97323[.324]*F(1,95) = .93366[.336]*
* * * *
* B:Functional Form *CHSQ(1) = 10.4271[.001]*F(1,95) = 11.0588[.001]*
* * * *
* C:Normality *CHSQ(2) = 5.5501[.062]* Not applicable *
* * * *
* D:Heteroscedasticity*CHSQ(1) = .36025[.548]*F(1,98) = .35433[.553]*
*******************************************************************************
A:Lagrange multiplier test of residual serial correlation
B:Ramsey's RESET test using the square of the fitted values
C:Based on a test of skewness and kurtosis of residuals
D:Based on the regression of squared residuals on squared fitted values

X1=price satisfaction

X2=design satisfaction

X3=performance satisfaction

Y=overall customer satisfaction

Sofware used: Microfit

(If you need a excel file , please comment down your mail id. I'll mail the worksheets.)

2. the coefficient of price satisfaction: .30303

3.the coefficient of design satisfaction: -.038329

4. the coefficient of performance satisfaction: .66280

5. true. because p value=0.00<0.05

6. False. because p value=0.383>0.05

6. True because P value=0.00<0.05

If you like my work, then give a thumbs up.