Question 1 (20 marks = 2 + 2 + 3 + 3 + 2 + 2 + 2 + 4) Five years ago it was established that the mean time to travel between from a particular suburb to city is 30 minutes. You want to test whether the mean time has changed. To investigate this hypothesis you plan to take a sample of 20 travel times.
a. Specify the null and alternative hypotheses.
b. What is the test statistic that will be used to test the null hypothesis? What is its distribution when the null hypothesis is true?
c. Assuming a 2% significance level, what is the decision rule for rejecting null hypothesis?
d. The file TravelTimes.xls contains 10 different samples each of size 20, labelled 0, 1, 2,…,9. Choose the sample that corresponds to the last digit of your student number. Find (i) the sample mean, (ii) the sample standard deviation, and (iii) the value of the test statistic specified in part (b).
e. What is your test decision and conclusion about the travel time?
f. What is the p-value of the test?
g. Suppose the current mean travel time (population) is µ = 34 minutes. Did the test lead you to the correct decision? If not, did it make a type I or a type II error? h. The 10 different samples in the file TravelTimes.xls can be treated as one big sample of size n = 200. Assuming a 1% significance level, what is the decision rule for rejecting null hypothesis? What is your conclusion?
Question 2 -
Excel files ExchangeRates-Monthly–7-1969to12-2009.xls and ExchangeRates-Monthly–1-2010to8- 2015.xls contain monthly data on the Australian dollar (AU$) exchange rates against major currencies for the period July, 1969 to August, 2015. (source: Reserve Bank of Australia,
(a) Use Excel to draw a line graph of the exchange rate between United States dollar (US$)/AU$. What does this graph reveal? Describe how the exchange rate has changed. (Hint: consider periods (i) from 1969 to 1973/74, (ii) from 1973/74 to 1985, (iii)1985 to 2011 and (iv) 2011 to present.) (b) Calculate monthly change in the exchange rate (Let be the exchange rate in month t. calculate change in exchange rate as ). Draw a line graph for the monthly change in exchange rate. What does this graph reveal? (c) Find Maximum and minimum of monthly change in exchange rate. (d) Create 19 bins for drawing a histogram for the monthly changes in exchange rate. Make the class limits for the first bin -0.22 to -0.20 and those for the last bin 0.14 to 0.16. Use Excel to create the histogram. Describe the histogram. Is it positively skewed? Negatively skewed? Symmetric?
(e) Find the mean and standard deviation of monthly change in exchange rate. Report your answers correct to 5 decimal places.
(f) What proportion of observations lies within 2 standard deviations of the mean (Hint: you may use excel countif function)? Is this proportion consistent with what you would expect from the normal distribution (Hint: Empirical rule)?
Question 3 -
An event organiser would like to predict the number of ‘portaloo’ lavatories required for outdoor entertainment events based on the volume of food to be consumed at the event. The organiser has collected the data given in GB513Assignment-Q3.xls. a. Plot a scatter diagram for this data. Describe (briefly) the relationship between the volume of food consumed and number of portaloos.
b. Assuming a linear relationship, calculate the regression equation for this data. Please show your calculations or insert your summary output from Excel.
c. Interpret the estimated Y intercept, b(0) , and the estimated slope, b1 .
d. Perform residual analyses and determine whether the sample data meet the regression assumptions of equal variance (homoscedasticity) and normality.
e. Is the amount of food consumed a statistically significant predictor of portaloos? Please explain your answer.
f. Comment on the goodness of fit of this model.
g. Predict the number of lavatories required if the volume of food to be consumed is 800 kg.
Note : the last digit of my student is 9.( as mentioned in the question 1 ) .
(((sir , I am attaching files as mentioned in the questions above )))
(((questions require use of microsoft excel for making charts and graphs .)))
GET ANSWERS / LIVE CHAT