Statistical Analysis Subject Assignment | Homework Help Websites
the information is provided in the Ma10251 coversheet and Statistical Analysis project 3 students 2018.docx in these document attached below. 
i want the report to be done with use of peper calculation and mathematical working not just theory report you can see the feedback in Elahi_umair Project b file which is very bad . all the files are attached below
Written Answer Part C
Delete the italic text and add your content.
Each answer below should:
· Introduce and put the question in context
· Include appropriate Excel output.
· Present the results of your Excel output and tests without unnecessary statistical jargon
C.1 Price Comparison Capital City versus Elsewhere in State
100 to 200 words and 1 to 2 pages
Use your answer to Question 1:
On the specified day was the mean price of your fuel less in the capital city than elsewhere in the state specified by your sample?
to decide if on the day specified by your sample the average price of your fuel was less in the capital city than elsewhere in the state specified by your sample.
C.2 Relationship between Unleaded 91 and Diesel
200 to 500 words and 2 to 4 pages
Use the simple and multiple linear regression models developed in Questions 2 and 3 to provide, and justify, a linear model to predict the price of your dependent fuel.
· Mention/explain choice of independent and dependent variables.
· Include your scatter plot and discuss any apparent relationship between Unleaded 91 and Diesel prices. Comment on the strength, shape and sign of the relationship.
· Include and justify the simple or multiple linear regression model which best fits the data.
· Discuss and interpret the values of the regression and correlation coefficients of the best model.
· Present the results without unnecessary statistical jargon.
Appendices Part C
Delete the italic text and add your content.
This section should include appropriate graphs, Excel output and any necessary steps for the required statistical tasks.
Tests should show full statistical working including
· Random variable/s defined
· Any required assumptions mentioned
· Excel output
· Hypotheses and decision for tests
· Conclusion for any hypothesis test.
