Statistical Analysis Subject

 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.

Appendix C.1 Statistical answer for 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?

Appendix C.2 Statistical answer for Question 2 and Question 3 

Assumptions and Variables Defined

Define dependent and independent variables for both simple and multiple linear regression models.

Mention any assumptions required for the simple/multiple linear regression models.

Simple Linear Regression Model

· Develop a simple linear regression model

· Include interpretation of regression and correlation coefficients.

Multiple Linear Regression Model

· Develop a multiple linear regression model with two independent variables

· Include interpretation of multiple regression and correlation coefficients for the multiple regression model

· Determine which independent variables make a significant contribution to the regression model. 

· State and justify the simple or multiple linear model which best fits the data.