消费水平内部因素的五大问题，以及每个问题图

 B. Internal factors
内部因素
Issue 1: “Do Loyalty customers purchase more than Regular customers by more than $10?”
问题1：“忠实客户会比普通客户多花10美元购买更多的商品吗？”

1. Charts and Graphs

图表和图形
 

2. Descriptive Statistic

描述性统计

3. Hypothesis Testing 

假设检验
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
 

2. Descriptive Statistics

描述性统计

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
  图表和图形

3. Descriptive Statistics 

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
 图表和图形
 

2. Descriptive Statistic 

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/