MAT10251 : Statistical Analysis Project - Oz-Fuel-Watch - Self-Marking Assignemnt Help

Internal Code : 1AAFAF

Statistical Analysis Project  Assignemnt Help

TASK1 Oz-Fuel-Watch has asked you to provide information on the price of either Unleaded 91 or Diesel on the day and in the state specified by your sample. In particular, information on the minimum and maximum price and the average price. Also required is an estimated price range for your given fuel. Note:

• If your family name begins with A to M analyse Unleaded 91 prices.

If your family name begins with N to Z analyse Diesel prices Complete the following tasks 1) Download and save your data. 2) Download the Project Part A cover sheets, name and save this file as “Family Name_First Name_Part_A_Campus”. 3) Enter your Sample Number and Fuel on page 2 of the Part A coversheets. 4) Statistical Tasks Using Unleaded 91 (third column of your data) or Diesel (fourth column of your data) explore the price of your fuel by using Excel to

• Construct a frequency histogram or polygon

Calculate descriptive statistics TASK2 When directed to do so during Week 5 complete the following tasks 1) Open your saved copy of your submission for Part A. 2) Replace the Part A coversheets (three pages) with the Part B coversheets (first four pages). 3) Rename and save this file as “Family Name_First Name_Part_B_Campus”. 4) Use the solution template and marking guide provided to mark your submission for Part A. Enter recommended marks on the self-marking sheet for Part A, page 3 of the file in 3) above. 5) Write a short reflection/feedback on your submission and marking of Part A. In particular:

• consider the good aspects of your submission, what did you do well
• identify where you made mistakes, and how you would avoid them in the future
• consider what you learnt from submitting and self-marking Part A.

This is to be entered in the space at the bottom of the self-marking sheet for Part A. 6) Save file. To be submitted with Part B – due Sunday 13 January 2019. TASK3 Statistical Inference Tasks The following statistical tasks should appear as appendices to your written answer. This should include all necessary steps and appropriate Excel output. These appendices should come after your written answer within your single Word document for Part B. Statistical Inference Choose a level of confidence for the confidence interval in Question 1 and a level of significance for the hypothesis test in Question 2.  Enter these values on page 2 of the Part B coversheets along with the sample number and fuel from Part A.  Question 1 and 2 Situation Previous research undertaken by Oz-Fuel-Watch shows that motorists consider a fuel to be expensive if its price is $1.50 per litre or more. That is, at least $1.50. Question 1 Oz-Fuel-Watch has asked you whether motorists would consider the average price of your fuel expensive on the day and in the state specified by your sample. To enable you to answer this question use Unleaded 91 (third column of your data) or Diesel (fourth column of your data) and an appropriate statistical inference technique to: Estimate the population mean price of your fuel, Unleaded 91 or Diesel, on the day and in the state specified by your sample. Question 2 Past research shows that even when the average price is less than $1.50 per litre, motorists perceive fuel prices to be expensive when the price of a fuel is at least $1.50 at more than 25% of petrol stations in a state. Oz-Fuel-Watch wishes to know if, using this criteria, the price of your fuel, Unleaded 91 or Diesel, was expensive on the day, and in the state, specified by your sample. To enable you to provide this information use Unleaded 91 (third column of your data) or Diesel (fourth column of your data) and an appropriate statistical inference technique to answer the following question On the specified day was the price of your fuel at least $1.50 per litre at more than 25% of petrol stations in the state specified by your sample? Notes:

• You may need to transform or manipulate your sample data, before using Excel for the required statistical calculations.
• Use Excel for statistical calculations. You do not need to repeat any Excel calculations by hand. However, make sure that you define your random variables and include any steps not given by Excel. For example, in a hypothesis test include the null and alternative hypotheses, along with the decision to reject or not reject the null hypothesis.
• Mention any assumptions you need to make.
• Comment on why the test or confidence interval has been chosen
• Make sure you interpret confidence intervalsand write a conclusion to hypothesis tests.

TASK 4 Components of a report For each question, present the results of your calculations, with your interpretation and conclusion as components of a longer report on fuel prices. Use the instructions given on page five of the Part B coversheets. This should be a one to three pages and 200 to 400 words. It should be submitted as a Word file with Excel output included. Make sure you:

• Introduce each question and put it in context.
• Answer the question in non-statistical language
• Present the results of your intervals or tests without unnecessary statistical jargon
• Include conclusions which answer the given questions.

The above question has been solved by our Statistical Analysis Project experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.