What you need to do
你需要做什么
You are required to take a random sample of 100 transactions and conduct your analysis on the basis of this sample. DO NOT JUST TAKE THE FIRST 100
OBSERVATIONS IN THE DATABASE!
需要你采取100个交易随机样品,并在这个样品的基础上进行分析。不要只采取数据库的第100个观察!
Because your analysis is done on a RANDOM sample, your results will not be the same as the results of any other student group. Using statistical methods
listed below and any other techniques you think may be useful, summarise the data and comment on your findings.
因为您的分析是采用随机抽样,结果将作为其他学生组的结果是不一样的。下面列出了使用的统计方法和任何其他技术,你认为可能是有用的,汇总数据,并评论你的发现。
•Descriptive statistics
描述性统计
•Inferential statistics
推论统计
•Graphical representation of quantitative and qualitative variables
图形表示的定性和定量变量
•Sorting
排序
Analysis by Customer Type
按客户类别分析
Management is interested in knowing relationships between Customer Type (i.e. Loyalty or Regular) and the other variables. After sorting the data by Customer
Type, you are initially interested in analysing the following variables:
管理层知道客户类型(即忠诚或定期)和其他变量之间的关系感兴趣。按客户类型划分的数据排序后,你最初热衷于分析以下变量:
• •Value – Total $ amount per transaction
总价值$每笔交易金额
• •Items – Number of items purchased
项目 - 购买的物品数量
For each of the above variables and for both Loyalty and Regular customers you need to:
对于上述各变量的忠诚和熟客,你需要:
(i) Prepare a histogram and frequency distribution.
准备的直方图和频率分布。
(ii) Prepare a table of summary statistics (i.e. mean, median, standard deviation, sample variance and 95% confidence interval for the population mean).
准备一个表的汇总统计数据(即平均,中位数,标准偏差,样本方差的人口和95%的总体平均数置信区间)。
(iii) Determine if there is a statistical difference between Loyalty and Regular customers. Make sure that you explicitly state your both null and
alternative hypothesis for each analysis.
确定忠诚和定期客户如果有一个统计上的差异。确保您明确说出你的null和替代假说每个分析。
(iv) For (iii) and (iv) above you need to also provide details of the test statistic that you used.
(iv)就(iii)及(iv)项,您还需要提供您使用的检验统计量的细节。
Analysis of all JMart customers
分析所有JMart客户
Management is also interested in understanding JMart customers and their spending habits based on the value and number of items in customer transactions.
From your random sample of 100 transactions, you are interested in analysing JMart customers on the basis of:
管理是在了解JMart的客户和他们的消费习惯基础上的价值和顾客交易的项目数量也有兴趣。从你随机抽取的100宗交易中,你有兴趣在分析JMart的客户的基础上,
• •Payment Method – Cash or Credit Card
付款方式 - 现金或信用卡
• •Age – Customers ≤40 years old vs. customers >40 years old
年龄≤40岁与40岁的客户 - 客户
• •Marital status – Married or Single
婚姻状况 - 已婚或单身
• •Gender – Male or Female
性别 - 男或女
Payment Method
付款方法
First sort the data by Payment Method. Then for Cash and Credit card customers perform an analysis of:
首先对数据进行排序付款方法。然后现金及信用卡客户进行分析:
• •Value – Total $ amount per transaction
总价值$每笔交易金额
• •Items – Number of items purchased
项目 - 购买的物品数量
For each of the above variables you need to:
对于每一个上述的变量,你需要:
(i) Prepare a table of summary statistics (i.e. mean, median, standard deviation, sample variance and 95% confidence interval for the population mean)
准备一个表的汇总统计数据(即平均数,中位数,标准差,样本方差的人口和95%的总体平均数可靠区间)
(ii) Determine if there is a statistical difference between Cash and Credit Card customers. Make sure that you explicitly state your both null and
alternative hypothesis for each analysis.
确定现金及信用卡客户,如果有一个统计上的差异。确保您明确说出你的null和替代假说每个分析。
(iii) For (i) and (ii) above you need to also provide details of the test statistic that you used.
(iii)就(i)及(ii)项,您还需要提供您使用的检验统计量的细节。
Age
年龄
First sort the data by Age. Then for customers who are 40 years old or younger and customers who are older than 40 years old perform an analysis of:
首先按年龄排序的数据。然后在40岁或以下及40岁以上的客户是谁的客户谁执行方面进行分析:
• •Value – Total $ amount per transaction
总价值$每笔交易金额
• •Items – Number of items purchased
项目 - 购买的物品数量
For each of the above variables you need to:
对于每一个上述的变量,你需要:
(i) Prepare a table of summary statistics (i.e. mean, median, standard deviation, sample variance and 95% confidence interval for the population mean)
准备一个表的汇总统计数据(即平均数,中位数,标准差,样本方差的人口和95%总体平均数的置信区间)
(ii) Determine if there is a statistical difference between customers who are ≤40 years old and customers who are >40 years customers. Make sure that you
explicitly state your both null and alternative hypothesis for each analysis
确定,如果有一个是≤40岁和> 40岁客户的客户的客户之间的统计学差异。请确保您明确说明你的null和替代假说每个分析
(iii) For (i) and (ii) above you need to also provide details of the test statistic that you used.
(iii)就(i)及(ii)项,您还需要提供您使用的检验统计量的细节。
Marital Status
婚姻状况
First sort the data by Marital Status. Then for Married and Single customers perform an analysis of:
首先对数据进行排序婚姻状况。然后为已婚和单客户进行分析:
• •Value – Total $ amount per transaction
总价值$每笔交易金额
• •Items – Number of items purchased
项目 - 购买的物品数量
For each of the above variables you need to:
(i) Prepare a table of summary statistics (i.e. mean, median, standard deviation, sample variance and 95% confidence interval for the population mean)
(ii) Determine if there is a statistical difference between Married and Single customers. Make sure that you explicitly state your both null and alternative
hypothesis for each analysis
(iii) For (i) and (ii) above you need to also provide details of the test statistic that you used.
Gender
性别
Sort the data by Gender, then for Male and Female customers perform an analysis of:
• •Value – Total $ amount per transaction
• •Items – Number of items purchased
For each of the above variables you need to:
对于每一个上述的变量,你需要:
(i) Prepare a table of summary statistics (i.e. mean, median, standard deviation, sample variance and 95% confidence interval for the population mean)
准备一个表的汇总统计数据(即平均数,中位数,标准差,样本方差的人口和95%的置信区间意味着)
(ii) Determine if there is a statistical difference between Male and Female customers. Make sure that you explicitly state your both null and alternative
hypothesis for each analysis
确定是否有显着差异,男性和女性之间的客户。请确保您明确说明你的null和替代假说每个分析
(iii) For (i) and (ii) above you need to also provide details of the test statistic that you used.
(iii)就(i)及(ii)项,您还需要提供您使用的检验统计量的细节。
Discussion of your findings
讨论你的发现
You will need to discuss the results of your analyses! Do not just present a series of tables and figures. In the discussion of your results, some of the
questions you might want to address include:
您将需要讨论的结果,你的分析!不要只是提出了一系列表格和数字。在讨论你的结果,你可能想解决的一些问题,包括:
Analysis by Customer Type
按客户类别分析
• •Are Loyalty customers likely to spend more or less than Regular customers?