澳洲Assignment范文：有关数据分析的书面作业
02-02, 2013
ECMT1010 Written Assignment 书面essay 金融
Due Friday June 8, 2012, 4:30pm
Instructions介绍
In order to complete this assignment, you will need the following data sets: 为了完成这个essay，你需要以下数据集：
1.Fiji farm survey.xls
2.Australian retail turnover.xls
3.Dairy.xls
4.Top 1000.xls
5.Queensland tourism.xls
6.ARIA.xls
This assignment must be done alone and is worth 10% of your final mark.
You will be marked on the correctness of your answers as well as presentation.
Late assignments will be penalised 20% of full marks per day.
The assignment must be submitted both electronically and by hard- copy. The hard-copy version is to be submitted into the assignment boxes on level 2 of the Merewether Building. The electronic version must be submitted via the University Learning Management System (see 3 minute online tutorial for further details).
You should familiarise yourself with the University’s policies regarding academic
honesty and plagiarism and understand the following declaration:
By submitting an assignment through the University Learning Management System, 通过使用大学学习管理系统提交一份essay，获得以下技能
1.I certify that: I have read and understood the University of Sydney Academic Dishonesty and Plagiarism Policy;
2.I understand that failure to comply with the above can lead to the University commencing proceedings a gainst me for potential student misconduct under Chapter 8 of the University of Sydney By-Law 1999 (as amended);
3.This Work is substantially my own, and to the extent that any part of this Work is not my own, I have indicated that it is not my own by ackno wledging the source of that part or those parts of the Work.
4.I declare that this assignment is original and has not been submitted for
assessment elsewhere, and acknowledge that the assessor of this assignment may, for the purpose of assessing this assign ment: a) Reproduce this assignment and provide a copy to another member of Faculty; and/or b) Communicate a copy of this assignment to a plagiarism checking service (which may then retain a copy of the assignment on its database for the purpose of future p lagiarism checking).
Information on plagiarism is available online at :
Assignment Questionsessay要求
1.(Chapter 2, Analysing the Data Sets Problem 2) （第2章，分析数据集问题2）
For the Fiji farm survey data set, produce a histogram for the variable ‘Education’. Interpret you results and explain any grouping in the histogram。对于斐济农场的调查数据集，制作一个关于变量“教育”的直方图。解释你的结果并且解释直方图中的任何分组。
Using the Australian retail turnover data set, produce a scatter plot of the turnovers for food retailing and department stores. 使用澳洲零售营业额的数据集，制作一个食品零售和百货商场的营业额的散点图。Comment on your findings.
3.(Chapter 2, Analysing the Data Sets Problem 4)
For the Dairy data set, produce a Pareto chart for the state-wide production of milk in 2007 –08. 对于乳制品的数据集，制作一个2007年-08年全州牛奶产量的帕累托图。
4.(Chapter 3, Analysing the Data Sets Problem 1)
Access the Top 1000 data set.
a.Calculate the descriptive statistics for net profit, total revenue, and number of employees.
b.What conclusions can you reach from the comparison of net profit and revenue distributions? Calculate the coefficient of variation for each distribution and comment on the variability of the two distributions.
c.Calculate the descriptive statistics for return on funds and return on revenue. Comment on the distribution.
5.(Chapter 4, Analysing the Data Sets Problem 2) In the Fiji farm survey data set: 在斐济农场的调查数据集中
a. What is the probability that a randomly selected farmer has a cane output of 300 tonnes? 随机选择一个农夫，其有一个300吨的甘蔗产量的概率是多少？
b.What is the probability that a randomly selected farmer has cultivated an area of 10 acres?
c.What is the probability that a randomly selected farmer is a part-time farmer and has a cane output of 300 tonnes?
d.What is the probability that a randomly selected farmer is a part -time farmer and over 55 years of age?
e.What is the probability that a randomly selected farmer is neither a part-time farmer nor over 55 years of age?
6.(Chapter 5, Analysing the Data Sets Problem 1)
Use the Queensland tourism data set. What is the probability that a randomly selected Queensland hotel room was occupied in September 2003? 使用昆士兰旅游数据集。一个随机选择的昆士兰酒店的客房在2003年9月被使用的概率是多少？ Use this as the value of p a binomial experiment and assume it is the current rate of occupancy. If you were to randomly select 10 hotel rooms in Queensland, what is the probability that no more than five are occupied? If you were to randomly select 20 hotel rooms in Queensland, wh at is the probability that no more than 10 are occupied?
7.(Chapter 6, Analysing the Data Sets Problem 2)
Use the Fiji farm survey data set; noting that the cultivated area variable is nearly normally distributed. 用斐济农场的调查数据集;显示耕地面积变量是近正态分布的。 What is the probability that the area of a cultivated sugar cane farm selected at random is less than ten acres? #p#分页标题#e#
8.(Chapter 7, Analysing the Data Sets Problem 2) http://ukthesis.org/kjzy/
Refer to the data for room occupancy rates for licensed hotels in the Queensland tourism data set. The room occupancy rate for the December quarter 2007 was 71.8%. Assume that this figure is typical for occupancy rates for this time of the year. If you randomly selected 50 licensed hotels, what is the probability that you will get a room occupancy rate for the December quarter 2007 that is less than 60%? What is the probability that you will get a room occupancy rate for the December quarte r 2007 of between 80% and 90%?
9.(Chapter 8, Analysing the Data Sets Problem 1 )
Using the Fiji farm survey data set, construct a 95% confidence interval for the population mean cane output per farmer. 用斐济农场的调查数据集，为人均平甘蔗产量构建一个95％的置信区间的。Also construct a 95% confidence interval for population mean cane output per acre. Comment on the results.
10.(Chapter 9 , Analysing the Data Sets Problem 4)
Using the Top 1000 data set, test whether the mean return on revenue is less than 20%. Assume σ is unknown, then repeat the test assuming σ = 22. Use α = 5%. What do you conclude?
11.(Chapter 10, Analysing the Data Sets Problem 1)
Using the Fiji farm survey data set, test whether the mean output per farmer is the same for land owned and land not owned. Use a level of significance 5%.
12.(Chapter 13 , Analysing the Data Sets Problem 1)
Develop a regression model from the ARIA data set to predict sales of CD albums from the sales of CD singles.根据ARIA数据集建立一个回归模型来根据单曲CD的销售预测CD专辑的销售。Discuss the model and its strength on the basis of indicators presented in this chapter. Does it s eem logical that unit sales of CD albums could be predicted by CD singles sales?
Due Friday June 8, 2012, 4:30pm
Instructions介绍
In order to complete this assignment, you will need the following data sets: 为了完成这个essay，你需要以下数据集：
1.Fiji farm survey.xls
2.Australian retail turnover.xls
3.Dairy.xls
4.Top 1000.xls
5.Queensland tourism.xls
6.ARIA.xls
This assignment must be done alone and is worth 10% of your final mark.
You will be marked on the correctness of your answers as well as presentation.
Late assignments will be penalised 20% of full marks per day.
The assignment must be submitted both electronically and by hard- copy. The hard-copy version is to be submitted into the assignment boxes on level 2 of the Merewether Building. The electronic version must be submitted via the University Learning Management System (see 3 minute online tutorial for further details).
You should familiarise yourself with the University’s policies regarding academic
honesty and plagiarism and understand the following declaration:
By submitting an assignment through the University Learning Management System, 通过使用大学学习管理系统提交一份essay，获得以下技能
1.I certify that: I have read and understood the University of Sydney Academic Dishonesty and Plagiarism Policy;
2.I understand that failure to comply with the above can lead to the University commencing proceedings a gainst me for potential student misconduct under Chapter 8 of the University of Sydney By-Law 1999 (as amended);
3.This Work is substantially my own, and to the extent that any part of this Work is not my own, I have indicated that it is not my own by ackno wledging the source of that part or those parts of the Work.
4.I declare that this assignment is original and has not been submitted for
assessment elsewhere, and acknowledge that the assessor of this assignment may, for the purpose of assessing this assign ment: a) Reproduce this assignment and provide a copy to another member of Faculty; and/or b) Communicate a copy of this assignment to a plagiarism checking service (which may then retain a copy of the assignment on its database for the purpose of future p lagiarism checking).
Information on plagiarism is available online at :
Assignment Questionsessay要求
1.(Chapter 2, Analysing the Data Sets Problem 2) （第2章，分析数据集问题2）
For the Fiji farm survey data set, produce a histogram for the variable ‘Education’. Interpret you results and explain any grouping in the histogram。对于斐济农场的调查数据集，制作一个关于变量“教育”的直方图。解释你的结果并且解释直方图中的任何分组。
Using the Australian retail turnover data set, produce a scatter plot of the turnovers for food retailing and department stores. 使用澳洲零售营业额的数据集，制作一个食品零售和百货商场的营业额的散点图。Comment on your findings.
3.(Chapter 2, Analysing the Data Sets Problem 4)
For the Dairy data set, produce a Pareto chart for the state-wide production of milk in 2007 –08. 对于乳制品的数据集，制作一个2007年-08年全州牛奶产量的帕累托图。
4.(Chapter 3, Analysing the Data Sets Problem 1)
Access the Top 1000 data set.
a.Calculate the descriptive statistics for net profit, total revenue, and number of employees.
b.What conclusions can you reach from the comparison of net profit and revenue distributions? Calculate the coefficient of variation for each distribution and comment on the variability of the two distributions.
c.Calculate the descriptive statistics for return on funds and return on revenue. Comment on the distribution.
5.(Chapter 4, Analysing the Data Sets Problem 2) In the Fiji farm survey data set: 在斐济农场的调查数据集中
a. What is the probability that a randomly selected farmer has a cane output of 300 tonnes? 随机选择一个农夫，其有一个300吨的甘蔗产量的概率是多少？
b.What is the probability that a randomly selected farmer has cultivated an area of 10 acres?
c.What is the probability that a randomly selected farmer is a part-time farmer and has a cane output of 300 tonnes?
d.What is the probability that a randomly selected farmer is a part -time farmer and over 55 years of age?
e.What is the probability that a randomly selected farmer is neither a part-time farmer nor over 55 years of age?
6.(Chapter 5, Analysing the Data Sets Problem 1)
Use the Queensland tourism data set. What is the probability that a randomly selected Queensland hotel room was occupied in September 2003? 使用昆士兰旅游数据集。一个随机选择的昆士兰酒店的客房在2003年9月被使用的概率是多少？ Use this as the value of p a binomial experiment and assume it is the current rate of occupancy. If you were to randomly select 10 hotel rooms in Queensland, what is the probability that no more than five are occupied? If you were to randomly select 20 hotel rooms in Queensland, wh at is the probability that no more than 10 are occupied?
7.(Chapter 6, Analysing the Data Sets Problem 2)
Use the Fiji farm survey data set; noting that the cultivated area variable is nearly normally distributed. 用斐济农场的调查数据集;显示耕地面积变量是近正态分布的。 What is the probability that the area of a cultivated sugar cane farm selected at random is less than ten acres? #p#分页标题#e#
8.(Chapter 7, Analysing the Data Sets Problem 2) http://ukthesis.org/kjzy/
Refer to the data for room occupancy rates for licensed hotels in the Queensland tourism data set. The room occupancy rate for the December quarter 2007 was 71.8%. Assume that this figure is typical for occupancy rates for this time of the year. If you randomly selected 50 licensed hotels, what is the probability that you will get a room occupancy rate for the December quarter 2007 that is less than 60%? What is the probability that you will get a room occupancy rate for the December quarte r 2007 of between 80% and 90%?
9.(Chapter 8, Analysing the Data Sets Problem 1 )
Using the Fiji farm survey data set, construct a 95% confidence interval for the population mean cane output per farmer. 用斐济农场的调查数据集，为人均平甘蔗产量构建一个95％的置信区间的。Also construct a 95% confidence interval for population mean cane output per acre. Comment on the results.
10.(Chapter 9 , Analysing the Data Sets Problem 4)
Using the Top 1000 data set, test whether the mean return on revenue is less than 20%. Assume σ is unknown, then repeat the test assuming σ = 22. Use α = 5%. What do you conclude?
11.(Chapter 10, Analysing the Data Sets Problem 1)
Using the Fiji farm survey data set, test whether the mean output per farmer is the same for land owned and land not owned. Use a level of significance 5%.
12.(Chapter 13 , Analysing the Data Sets Problem 1)
Develop a regression model from the ARIA data set to predict sales of CD albums from the sales of CD singles.根据ARIA数据集建立一个回归模型来根据单曲CD的销售预测CD专辑的销售。Discuss the model and its strength on the basis of indicators presented in this chapter. Does it s eem logical that unit sales of CD albums could be predicted by CD singles sales?
Get expert help on all your writing
立即预定