Urgent SPSS Case Analysis-Needs Fixing

The variable used in the analysis is “Friendly Employees”. An independent sample t-test is conducted to compare, “friendly employees,” between Jose’s South-western Café(M=4.80,SD=0.489) and Santa Fe Grill(M=2.94,S.D=0.947).The result showed significant difference in the ,”Friendly Employee” between Jose Southwestern Café and Santa Fe Grill with t-value of t(395.25) =26.025 with the p-value being 0.000.

Answer

The variable used in the analysis is “Satisfaction”. An independent sample t-test is conducted to compare, “Satisfaction,” between Jose’s South-western Café(M=5.31,SD=1.141) and Santa Fe Grill(M=4.54,S.D=1.002).The result showed significant difference in the ,”Satisfaction” between Jose Southwestern Café and Santa Fe Grill with t-value of t(286.47) =6.86 with the p-value being 0.000.

The variable is the,” Likely to return”. The likelihood of returning to Santa Fe Grill and Jose’s Southwestern Café was found out using cross-tab in SPSS. The result showed 0% are highly likely to return to Santa Fe Grill whereas 6.6% are highly likely to return to Jose’s Southwestern Café. It is further evident from the stacked bar graph as shown below. The mean value for Jose’s Southwestern café,” likely to return” obtained was 4.96 with SD =1.291, whereas for Jose’s South Western café, “likely to return” was 4.17 with SD =0.848.

The variable used are as follows:

• Try New and Different Thing-X1

• Buy New Products-X9

• Try New Brands-X11

The descriptive statistics table shows man value of X1 being 5.39 with SD=1.863.The mean value of X9= 5.60 with SD= 1.606 and mean of X11 = 5.42 with SD =1.766.

A bivariate correlation test was used to compare the relationship among items X1,X9 and X11.The result showed the correlation between r(X1,X9)= 0.688,p= 0.000.Thus,positive significant correlation exists between X1 and X9.

The correlation coefficient between X1 and X11,r(X1,X11)=0.844,p-value =0.000.A positive and significant correlation exists between X1 and X11.

The correlation coefficient between X9 and X11,r(X9,X11)=0.693,p-value =0.000.A positive and significant correlation exists between X9 and X11.

Here positive correlation means increase in value of one of the variable causes an increase in another variable.

Answer

The variable is ,”Distance Driven”.which is ordinal.Therefore the appropriate test will be the Mann Whitney U test which is the non-parametric version of independent sample t-test.

The mean rank for distance driven for Jose’s South-western Café is 222.42 whereas the mean rank for Santa Fe Grill obtained is 191.33.The second table showed test statistic value of U=16276.5 with the p-value of 0.006.Further,it was analysed through stacked bar graph which showed large difference in each categories

Stacked Bar graph

The variable is ,”Distance Driven”.which is ordinal.Therefore the appropriate test will be the Mann Whitney U test which is the non-parametric version of independent sample t-test.

The mean rank for distance driven for Jose’s South-western Café is 222.42 whereas the mean rank for Santa Fe Grill obtained is 191.33.The second table showed test statistic value of U=16276.5 with the p-value of 0.006.Further,it was analysed through stacked bar graph which showed large difference in each categories

Answer

The variable Healthy_Food was computed by adding the following variable:

• X4-Avoid Fried Foods

• X8-Eat balanced Nutritious Meals

• X10-Careful about what I eat

The mean value for Jose’s Southwestern Café obtained was 10.73 with SD =2.23 whereas the mean value of Santa Fe Grill obtained was 14.54 with SD =3. 002.An independent sample t-test was used to compare the mean difference between Jose’s Southwestern Café and Santa Fe Grill with respect to Healthy Food. The result showed test statistic value of t (385) = -14.56 with the p-value of 0. 000.Thus the difference is significant between Jose’s Southwestern Café and Santa Fe Grill with respect to Healthy_Food.

Answer

The regression model for Santa Fe customers was developed considering the following variables:

Dependent Variable:X22-Satisfaction

Independent Variable:X12-Friendly Employees, X14-Large Size Portions, X15-Fresh Food.

The first table shows coefficient of determination being R-square = 0.629 meaning 62.9% of the variation in satisfaction is explained by variable, X12(friendly employees), X14(Large Size Portions) and X15(Fresh Food).

The second table shows whether the overall regression model is significant or not. The result shows F-value of F (3,249) =141.017 with the p-value of 0.000 meaning the overall regression is significant.

The third table is the individual independent variable interpretation.

The model can be represented as

----------------------- (1)

From the above model it is clear increase in 1 unit of friendly employees cause an increase of 0.436 unit of satisfaction. The test statistic obtained is t =9.999 with p-value =0.000.

The equation (1) shows that unit increase of,” Large Size Portions” cause an increase of 0.123 increase of satisfaction. The test statistic obtained is t =4.293 with p-value =0.000, meaning the slope is significant.

The equation (1) shows that unit increase of,” Fresh food” cause an increase of 0.559 increase of satisfaction. The test statistic obtained is t =15.403 with p-value =0.000, meaning the slope is significant.

The most important variable would be the variable that brings the most satisfaction per unit increase in independent variable. It can be obtained from the standardized coefficient of the regression(beta). Thus from the above regression model it is clear that the most important variable is,” Fresh food-X15(beta=0.649)” and the least important variable is.” Large Portion-X14(beta=0.182)”.