SHOW COMPLETE SOLUTIONSFOLLOW INSTRUCTIONS Direction:Perform hypothesis testing. Show all the steps and solutions.Note: Excel / Stat computation (Output) is already provided to you.An economist believed that the weekly consumption of food purchased by families with5 members from two cities, Manila and Makati are different. A random sample of 8families were chosen from each city. The result are as followsWeekly food purchase in pesosManila 2750 3240Makati 3500 3200 3945 2890 2780 3000 3540 2540COMPUTER OUTPUT:At 5% level, is the economist claim true? Assume the variance are equal.t-Test: Two-Sample Assuming Equal VariancesMeanVarianceObservationsdfPooled VarianceHypothesized Mean Differencet Stat2800 2675 2876 3250 3300 3500P(T<=t) one-tailt Critical one-tailP(T<=t) two-tailt Critical two-tailManila3048.87594927.267868154854.4821014-0.6378401180.2669359551.7613101150.533871912.144786681Makati3174.375214781.69648

Given df=14, level of significance=0.05

Direction: Perform hypothesis testing. Show all the steps and solutions. Note: Excel / Stat computation (Output) is already provided to you. An economist believed that the weekly consumption of food purchased by families with 5 members from two cities, Manila and Makati are different. A random sample of 8 families were chosen from each city. The result are as follows Weekly food purchase in pesos Manila 2750 COMPUTER OUTPUT: df Makati 3500 3200 3945 2890 2780 3000 3540 2540 3240 2800 2675 2876 t-Test: Two-Sample Assuming Equal Variances At 5% level, is the economist claim true? Assume the variance are equal. Mean Variance Observations Pooled Variance Hypothesized Mean Difference t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail Manila 3048.875 94927.26786 8 154854.4821 0 14 3250 3300 3500 -0.637840118 0.266935955 1.761310115 0.53387191 2.144786681 Makati 3174.375 214781.6964 8