Question

Looking to find what area needs to be focused on that is statistically significant

Dine In (1)/Take Out (2)	Satisfaction with Service	Satisfaction with Food	Driving Distance to Restaurant	Total Bill	Overall Satisfaction
1	4	4	5	10	4
1	2	3	5	15	3
1	3	3	10	10	3
1	5	5	12	15	5
2	3	4	10	25	3
2	2	4	15	25	3
2	3	4	10	26	3
1	4	3	16	27	3
2	3	3	2	25	3
1	2	3	10	26	2
2	1	3	15	20	2
2	2	2	10	20	2
1	5	4	12	20	4
1	4	5	16	20	4
1	4	5	18	20	4
1	3	4	20	27	3
1	4	3	18	28	4
2	3	4	20	28	3
2	3	4	16	28	3
1	4	5	7	12	4
2	4	5	9	20	4
1	2	3	10	24	3
2	3	5	6	26	4
2	3	4	10	28	3
1	3	4	9	27	3
2	4	5	8	24	4
2	3	3	10	22	3
1	4	4	6	23	4
2	3	4	10	25	4
1	4	5	10	20	4
2	2	3	15	20	2
2	2	2	16	20	2
1	4	4	18	20	4
2	3	2	16	20	3
2	3	3	14	25	3
1	3	3	20	22	3
1	3	3	16	23	3
1	4	5	17	28	4
2	3	3	16	23	3
2	3	4	5	15	3
1	4	4	10	28	4
2	3	3	6	24	3
2	2	3	10	27	2
1	3	3	6	26	3
2	4	4	7	28	4
1	2	3	6	24	2
2	4	5	8	22	4
1	4	5	6	23	4
1	5	5	8	20	5

Answer 1

SOLUTION

Lets enter the data in excel and then goto data > data analysis tab. The screenshots are as below

All the variables of interest are highlighted in yellow

The coeffecient of dtermination r2 is 0.863 , which means that model is able to explain 86.4% variation of the data. The regression equation can be formed using the coefficients as

	Coefficients
Intercept	0.7094315
Dine In (1)/Take Out (2)	-0.01884609
Satisfaction with Service	0.580369266
Satisfaction with Food	0.266814864
Driving Distance to Restaurant	-0.006352462
Total Bill	-0.0078379

Satisfaction = -0.007Bill -0.006Drving distance +0.26satisfaction +0.58 service - 0.018 dine in +0.709

based on the equation above , all variables that exhibit a negative coefficient contribute to a decrease in the overall satisfaction of the customer. Eg : a change of 1 unit in bill causes the satisfaction to go down by 0.07 units. Hence all variables with this inverse relationship must be focused on for improving the customer satisfaction