澳洲Assignment范文：有關(guān)數(shù)據(jù)分析的書面作業(yè)
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: 為了完成這個(gè)essay，你需要以下數(shù)據(jù)集：
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, 通過(guò)使用大學(xué)學(xué)習(xí)管理系統(tǒng)提交一份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章，分析數(shù)據(jù)集問(wèn)題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。對(duì)于斐濟(jì)農(nóng)場(chǎng)的調(diào)查數(shù)據(jù)集，制作一個(gè)關(guān)于變量“教育”的直方圖。解釋你的結(jié)果并且解釋直方圖中的任何分組。
Using the Australian retail turnover data set, produce a scatter plot of the turnovers for food retailing and department stores. 使用澳洲零售營(yíng)業(yè)額的數(shù)據(jù)集，制作一個(gè)食品零售和百貨商場(chǎng)的營(yíng)業(yè)額的散點(diǎn)圖。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. 對(duì)于乳制品的數(shù)據(jù)集，制作一個(gè)2007年-08年全州牛奶產(chǎn)量的帕累托圖。
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: 在斐濟(jì)農(nóng)場(chǎng)的調(diào)查數(shù)據(jù)集中
a. What is the probability that a randomly selected farmer has a cane output of 300 tonnes? 隨機(jī)選擇一個(gè)農(nóng)夫，其有一個(gè)300噸的甘蔗產(chǎn)量的概率是多少？
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? 使用昆士蘭旅游數(shù)據(jù)集。一個(gè)隨機(jī)選擇的昆士蘭酒店的客房在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. 用斐濟(jì)農(nóng)場(chǎng)的調(diào)查數(shù)據(jù)集;顯示耕地面積變量是近正態(tài)分布的。 What is the probability that the area of a cultivated sugar cane farm selected at random is less than ten acres? #p#分頁(yè)標(biāo)題#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. 用斐濟(jì)農(nóng)場(chǎng)的調(diào)查數(shù)據(jù)集，為人均平甘蔗產(chǎn)量構(gòu)建一個(gè)95％的置信區(qū)間的。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.根據(jù)ARIA數(shù)據(jù)集建立一個(gè)回歸模型來(lái)根據(jù)單曲CD的銷售預(yù)測(cè)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: 為了完成這個(gè)essay，你需要以下數(shù)據(jù)集：
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, 通過(guò)使用大學(xué)學(xué)習(xí)管理系統(tǒng)提交一份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章，分析數(shù)據(jù)集問(wèn)題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。對(duì)于斐濟(jì)農(nóng)場(chǎng)的調(diào)查數(shù)據(jù)集，制作一個(gè)關(guān)于變量“教育”的直方圖。解釋你的結(jié)果并且解釋直方圖中的任何分組。
Using the Australian retail turnover data set, produce a scatter plot of the turnovers for food retailing and department stores. 使用澳洲零售營(yíng)業(yè)額的數(shù)據(jù)集，制作一個(gè)食品零售和百貨商場(chǎng)的營(yíng)業(yè)額的散點(diǎn)圖。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. 對(duì)于乳制品的數(shù)據(jù)集，制作一個(gè)2007年-08年全州牛奶產(chǎn)量的帕累托圖。
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: 在斐濟(jì)農(nóng)場(chǎng)的調(diào)查數(shù)據(jù)集中
a. What is the probability that a randomly selected farmer has a cane output of 300 tonnes? 隨機(jī)選擇一個(gè)農(nóng)夫，其有一個(gè)300噸的甘蔗產(chǎn)量的概率是多少？
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? 使用昆士蘭旅游數(shù)據(jù)集。一個(gè)隨機(jī)選擇的昆士蘭酒店的客房在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. 用斐濟(jì)農(nóng)場(chǎng)的調(diào)查數(shù)據(jù)集;顯示耕地面積變量是近正態(tài)分布的。 What is the probability that the area of a cultivated sugar cane farm selected at random is less than ten acres? #p#分頁(yè)標(biāo)題#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. 用斐濟(jì)農(nóng)場(chǎng)的調(diào)查數(shù)據(jù)集，為人均平甘蔗產(chǎn)量構(gòu)建一個(gè)95％的置信區(qū)間的。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.根據(jù)ARIA數(shù)據(jù)集建立一個(gè)回歸模型來(lái)根據(jù)單曲CD的銷售預(yù)測(cè)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
立即預(yù)定