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
按客户类别分析
http://www.ukassignment.org/azdxassignment/
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?#p#分页标题#e#
忠诚客户可能比普通客户要花费或多或少的?
• •Are Loyalty customers likely to buy more or less items than Regular customers?
忠诚客户可能比普通客户购买更多或更少的项目?
• •What other inferences or conclusions are you able to draw from your results?
什么其他的推论或结论你能够得出结果吗?
• •What recommendations would you make for future research? What kind analyses would you conduct in future phases of research?
你有什么建议,为今后的研究?在未来阶段的研究中,你将进行什么样的分析?
• •What marketing recommendations would you make to the JMart senior management team? 你会对JMart高级管理团队做什么样的营销建议的?
Analysis of all JMart customers
分析所有JMart客户
• •Are customers who pay by cash likely to spend more or less than those who pay by credit card?
客户用现金支付的人可能花费多于或少于那些用信用卡支付的人?
• •Are customers who pay by cash likely to buy more or less items than those who pay by credit card?
谁用现金支付的客户有可能购买更多或更少的项目比那些用信用卡支付的人?
• •Are customers who are ≤40 years old likely to spend more or less than those who are >40 years old?
≤40岁的客户是谁可能花费多于或少于那些是40岁吗
• •Are customers who are ≤40 years old likely to buy more or less items than those who are >40 years old?
≤40岁的客户是谁可能购买更多或更少的项目比那些是40岁吗?
• •Are customers who are married likely to spend more or less than those who are single?
已婚客户可能花费多于或少于那些单身客户?
• •Are customers who are married likely to buy more or less items than those who are single?
已婚的客户可能会比那些单身购买更多或更少的项目?
• •Are male customers likely to spend more or less than female customers?
男性顾客可能要花费多于或少于女性客户?
• •Are male customers likely to buy more or less items than female customers?
男性可能比女性客户购买更多或更少的项目客户?
• •What other inferences or conclusions are you able to draw from your results?
什么其他的推论或结论你能够得出结果吗?
• • What recommendations would you make for future research? What kind analyses would you conduct in future phases of research? 你有什么建议,为今后的研究?
在未来阶段的研究中,你将进行什么样的分析?
• •What marketing recommendations would you make to the JMart senior management team?
你会对JMart高级管理团队做什么样的营销建议?
|