代写assignment：Statistical Analysis and Decision Making G Assignment

Answer all questions in this assignment

Answers should be written or typed on A4 paper and stapled at the top left hand corner. Each page should be numbered and have your ID number on it.

Do NOT place your answer in a plastic sleeve or folder.

The assignments are to be the individual work of the submitting student. Submitted assignments are not to be group efforts. However this statement is not meant to discourage students from discussing mutual problems that arise in answering the assignment questions. Such discussions should be verbal and not written. All calculations and computer entries should be done individually. If two or more assignments contain the same (or marginally changed) sentences and/or the same numerical errors they will be treated as a single assignment and the total marks awarded divided among the contributing students.

Your assignment should be handed to Dr. Shuang Liu on 16 Dec.

Late assignments, without an acceptable reason, will be penalised at a rate of 10% per day or part of day (including weekends) late. The maximum possible penalty for late assignments is 100% (i.e. a mark of zero). Note that ‘the printers were out of paper’ or other printing issues are not acceptable reasons for a late assignment.

Answer all questions in this assignment.

Question 1 (22 marks)

Canberrans have been concerned with the consumption of water and the factors that affect the water consumption level. In a recent study, researchers wanted to know whether Canberra's daily water consumption (ML) could be predicted by the daily maximum temperature (°C). They investigated data for January, 2011. They used Excel to analyse the results. Some of the Excel output is shown below:

Figure 1: Water Usage against Daily Maximum Temperature in Canberra, January, 2011

Source: The Canberra Times

Figure 2: Excel Output, Regression Analysis of Water Usage against Daily Maximum Temperature in Canberra, January, 2011

a)What are the independent and dependent variables?

The variable whose value depends on the other variable is called the dependent variable. The other variable is referred to as the independent variable.

Water usage = independent variable

Daily Maximum temperature = dependent variable

b)Write down the estimated equation.

Y= -4.76+4.92X

c)For January, 2011, the average water usage was 137.1 ML. On January 10th, the daily maximum temperature was 26.5 °C and the water usage was 111 ML. For January 10th, calculate:

i)the predicted water consumption

Y= -4.76+4.92X = -4.76+ 4.92*26.5 = -4.76 + 130.38 = 125.62 ML

ii)the residual

r = y- y^ = 111ML – 125.62ML = - 14.62ML

iii)the explained deviation from the mean

Explained deviation = y^ - mean y = 125.62ML - 137.1 ML = -11.48 ML(51Due责任编辑：英语论文代写)