B. Internal factors 内部因素 Issue 1: “Do Loyalty customers purchase more than Regular customers by more than $10?” 问题1:“忠实客户会比普通客户多花10美元购买更多的商品吗?”
The Hypothesis are : Ho :Loyalty customers purchased more than regular customer by no more or equal than $10 – Ho: µL - µr ≤ $10 忠实顾客购买大于常客少于或等于10美元 Ha : Loyalty customers purchased more than regular customer by more than $10 - Ha: µL - µr > $10 忠实顾客购买大于常客多于10美元 The Excel Output Excels输出 Conclusion 结论 With the assumption with the populations are normally distributed and the population variances are equal, the p -value for the test is 0.0003, which is much lower than the significance level of 0.05. Therefore, the null hypothesis is rejected and it can be concluded that there is sufficient evidence to suggest that loyalty customers are purchasing more than regular customers by no more or equal than $10. 假设人口是正态分布,总体方差是公平的,测试的p值是0.0003,远低于0.05的显着性水平。因此,零假设被拒绝,可以有足够的证据表明得出的结论是,忠实顾客比普通顾客购买更多不大于于或等于10美元。 Issue 2 : “Between customers who pay with credit cards and customers paying in cash, who tend to purchase more items?” 问题2:“在用信用卡支付和现金支付的客户直接,哪个倾向购买更多的商品?” a. Charts and Graphs
c. Hypothesis Testing The Hypothesis are : Ho: Customers who pay with Credit Cards purchased fewer or equal items than customers paying by Cash - Ho: µCC - µC ≤ 0 Ha: Customers who pay with Credit Cards purchased more items than customers paying by Cash - Ha: µCC - µC > 0 The Excel Output Conclusion With the assumption with the populations are normally distributed and the population variances are equal, the p -value for the test is 0.2089, which is much greater than the significance level of 0.05. Thus, the null hypothesis is not rejected and it can be concluded that there is no enough evidence to suggest that customers who pay by Credit Cards purchased more than customers paying by Cash. 结论 与假设通常与人口分布和人口方差相等,测试的p值是0.2089,这是远远大于0.05的显着性水平。因此,零假设不被拒绝,可以得出的结论是没有足够的证据表明,通过信用卡支付的客户超过用现金支付的客户。 Issue 3 : “Who tend to spend more money each transaction? Male or Female?” 问题3:“每一笔交易谁往往要花费更多的钱吗?男性或者女性?“ a. Charts and Graph 图表和图形
c. Hypothesis Testing The Hypothesis are : Ho : Female customers spend less or equal amount of money than Male customers Ho: µFM - µM ≤ 0 Ha: Female customers spend more amount of money than Male customers Ha: µFM - µM > 0 The Excel Output Conclusion 结论 With the assumption with the populations are normally distributed and the population variances are equal, the p-value for the test is 3.87508E-06, which is much lower than the significance level of 0.05. As a result, the null hypothesis is rejected and it can be concluded that there is adequate evidence to suggest that female customers spend more amount of money per transaction than male customers. 假设人口是正态分布,总体方差相等,测试的p值是3.87508E-06,这是远低于0.05的显着性水平。其结果是,零假设被拒绝,有足够的证据表明可以得出结论,每笔交易上女性客户比男性客户花更多的金钱。 Issue 4 : “Do Married customers purchase more items than Single customers?” 问题4:“已婚客户比单身客户购买更多种类的商品吗?” a. Charts and Graphs 图表和图形
c. Hypothesis Testing The Hypothesis are : Ho: Single customers purchased fewer or equal items than Married customers Ho: µS - µM ≤ 0 Ha : Single customers purchased more items than Married customers Ha: µS - µM > 0 The Excel Output Conclusion 结论 With the assumption with the populations are normally distributed and the population variances are equal, the p -value for the test is 0.2845, which is much greater than the significance level of 0.05. Consequently, the null hypothesis is not rejected and it can be concluded that there is no sufficient evidence to suggest that Single customers purchase more number of items than Married customers. 假设人口是正态分布,人口总体方差相等,测试的p值是0.2845,这是远远大于0.05的显着性水平。因此,零假设不被拒绝,可以得出的结论是没有足够的证据表明,单身客户比已婚客户购买更多件的商品。 Issue 5 : “Do Female customers purchase more items than Male customers?” 问题5:“女性消费者会比男性消费者购买更多见商品吗?” a. Charts and Graphs Descriptive Statistic c. Hypothesis Testing The Hypothesis are : Ho: Female customers purchased less or equal number of items than Male customers - Ho: µF - µM ≤ 0 Ha: Female customers bought more number of items than customers who are Male - Ha: µF - µM > 0 The Excel Output Conclusion 结论 With the assumption with the populations are normally distributed and the population variances are equal, the p -value for the test is 0.1314, which is much greater than the significance level of 0.05. Therefore, the null hypothesis is not rejected and it can be concluded that there is insufficient evidence to suggest that female customers tend to purchase more number of items than male. 假设人口是正态分布,总体方差相等,测试的p值是0.1314,这是远远大于0.05的显着性水平。因此,零假设不被拒绝,可以得出结论,没有足够的证据表明,女性消费者会比男性消费者倾向于购买更多数量的商品。 http://www.ukassignment.org/dxassignment/ |