Statistical Analysis Subject
umairchill5
MAT10251CoversheetsPartCSession32018.docx
SOUTHERN CROSS UNIVERSITYSchool of Business and Tourism MAT10251 Statistical Analysis |
PROJECT COVER SHEET
Please complete all of the following details and then make these sheets the first pages of your project – do not send it as a separate document.
Your project must be submitted as a Word document.
PART C
|
Student Name: |
|
|
Student ID No.: |
|
|
Tutor’s name: |
|
|
Due date: |
|
|
Date submitted: |
|
Declaration:
I have read and understand the Rules Relating to Awards ( Rule 3 Section 18 – Academic Integrity ) as contained in the SCU Policy Library. I understand the penalties that apply for academic misconduct and agree to be bound by these rules.
The work I am submitting electronically is entirely my own work.
.
|
Signed: (please type your name) |
|
|
Date: |
|
|
|
STUDENT NAME:
STUDENT ID NUMBER: |
MAT10251 – Statistical Analysis
Project Part C
Complete the summary table below.
|
Sample Number (last digit of your student ID number) |
|
|
Fuel (Independent Variable Questions 2 and 3) First letter family name A to M – Unleaded 91 First letter family name N to Z – Diesel |
|
|
Level of Significance |
|
Value: 20%
|
|
|
PLEASE ENSURE YOU KEEP A COPY OF YOUR PROJECT
|
Marking and Feedback Sheet
Comments
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.
5
Sheet1
| Max Marks | Mark | |
| Cover sheet or sample incorrect | -2 | |
| Incorrect format, including file name | -2 | |
| Statistical Inference Question 1 | ||
| Choice of technique, assumptions & other required steps | 5 | |
| Calculation (Excel output) | 3 | |
| Decision and conclusion | 2 | |
| Regression and Correlation | ||
| Assumptions and random variables defined | 2 | |
| Simple Linear Model Question 2 | ||
| Scatter plot | 3 | |
| Equation and coefficients | 2 | |
| Interpretation of regression & correlation coefficients | 2 | |
| Multiple Linear Model Question 3 | ||
| Equation, Coefficients and p-values | 4 | |
| Interpretation of regression & correlation coefficients | 3 | |
| Statistical Inference | ||
| Choice of technique and other required steps | 2 | |
| Decision and conclusion | 2 | |
| Best model | 1 | |
| Total Statistical Calculations | 31 | 0.0 |
| Written Answer | ||
| Question 1 | ||
| Introduction, discussion and results | 2 | |
| Question 2 & 3 | ||
| Introduction | 1 | |
| Interpretation of scatter plot | 2 | |
| Introduction and discussion of best model | 2 | |
| Structure, grammar and spelling | 2 | |
| Total Written Answer | 9 | 0.0 |
| Total Part C | 40 | 0.0 |
Max
Marks
Mark
Cover sheet or sample incorrect-2
Incorrect format, including file name-2
Statistical Inference Question 1
Choice of technique, assumptions & other required steps5
Calculation (Excel output)3
Decision and conclusion2
Regression and Correlation
Assumptions and random variables defined2
Simple Linear Model Question 2
Scatter plot3
Equation and coefficients2
Interpretation of regression & correlation coefficients 2
Multiple Linear Model Question 3
Equation, Coefficients and p-values4
Interpretation of regression & correlation coefficients3
Statistical Inference
Choice of technique and other required steps2
Decision and conclusion2
Best model1
Total Statistical Calculations310.0
Written Answer
Question 1
Introduction, discussion and results2
Question 2 & 3
Introduction1
Interpretation of scatter plot2
Introduction and discussion of best model2
Structure, grammar and spelling2
Total Written Answer90.0
Total Part C400.0
