Produce a graph of the Sydney temperature time series. - 95104

Solution Posted by
Solution Detail
Price: $50.00
Request Description
Question 3 (10 marks) Your employer is a medium size IT company that produces smartphones and tablets. Your sales director approaches you with concerns about possible declining sales in the face of stiff competition from other larger producers such as Apple and Samsung who launched new products at the beginning of the year. Recent sales figures for the last 26 weeks are shown in the file QA Assignment 2.xls. You have been asked to provide statistical evidence concerning the claim that recent weekly sales have declined following the launch of your competitor’s new devices. Prior to the beginning of the year, it was accepted that your company had mean weekly sales of $135,000 with a known standard deviation of $ 24,000. a) Specify the most appropriate choice of null and alternative hypotheses to test whether there has been a decline in mean weekly sales. [2 marks] b) Provide the formula for the test statistic and compute its value. [2 marks] c) What is the critical value of the test using a significance level of 2.5 per cent? [1 mark] d) What is your statistical decision regarding the pair of hypotheses? [1 mark] e) What is your conclusion (in non-statistical language) about mean weekly sales?[1 mark] f) Repeat parts (c), (d) and (e) using a significance level of 1 per cent. [3 marks] c) What is the critical value of the test using a significance level of 1 per cent? [1 mark] d) What is your statistical decision regarding the pair of hypotheses? [1 mark] e) What is your conclusion (in non-statistical language) about mean weekly sales?[1 mark] Question 4 (38 marks) PART A In this question, we will be using information about attendances at Australian Rules Football (AFL) matches held at the Melbourne Cricket Ground (MCG). The data is in the Excel file (QA2-1 Xls.) [Data obtained from: Smyth, GK (2011). Australasian Data and Story Library (OzDASL). http://www.statsci.org/data.] We are interested in analysing the relationship between MCG match attendance and the combined membership of the two clubs playing in that match. Produce a scatter plot of MCG attendance (dependent variable) against combined club membership (independent variable) and comment on the apparent relationship between these variables. [3 marks] Calculate the correlation coefficient between MCG attendance andcombined club membership and interpret the result.[2 marks] Use Excel (or other software) to estimate the linear regression model: Write out the estimated regression equation. [2 marks] Interpret the both the estimated intercept and estimated slope. [2 marks] Is combined club membership a statistically significant predictor of match attendance at the MCG? Use a significance level of 5%. [2 marks] Comment on the goodness of fit of the estimated model. [2 marks] Predict the attendance at a match between Adelaide (25,000 members) and Western Bulldogs (16,500 members).[2 marks] How do you think the above model could be improved in order to get a better prediction of the attendance at an AFL match held at the MCG? [2 marks] PART B Measurements of the mean maximum annual temperature for Sydney over the period 1859-2012 are contained in the Excel file: QA Assignment 2.xls. [Data sourced from the Australian Bureau of Meteorology] Produce a graph of the Sydney temperature time series. Describe the relationship between temperature and time. [3 marks] Use Excel to produce a simple linear trend regression model of Sydney temperatures. Write out the estimated regression equation. [2 marks] Interpret the estimated slope. [2 marks] Is there a statistically significant trend in Sydney temperatures? Explain why or why not? [2 marks] Comment on the model’s goodness of fit. [2 marks] Use your estimated model to forecast the mean annual Sydney temperature for 2015. [2 marks] Use your estimated model to forecast the mean annual Sydney temperature for 2030. [2 marks] Which of the above two forecasts do you expect to be more reliable?  Explain why. [3 marks] Does your analysis in this question prove that man-made environmental change is causing global warming? [3 marks]
Solution Description
<
Attachments
Your_employer_is_a_medium_size_IT_company_that_produces_smartphones_and_tablets.xlsx
Your_employer_i...