澳洲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?
如果您有論文代寫需求，可以通過下面的方式聯系我們
點擊聯系客服