THE SOUTHERN CROSS UNIVERSITY

SOUTHERN CROSS UNIVERSITY
School 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 B
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 B
Sample Number (last digit of your student ID
number)
5
Confidence Level 95%
Level of Significance 5
Value: 25%
2

Marking and Feedback Sheet Part B
Cover sheet or sample incorrect
Format incorrect, including name
Statistical Tasks
Statistical Inference Question 1
Assumptions & other required steps
Calculation (Excel output)
Conclusion
Statistical Inference Question 2
Assumptions & other required steps
Calculation (Excel output)
Decision and onclusion
Statistical Inference Question 3
Assumptions & other required steps
Calculation (Excel output)
Decision and conclusion
Regression and Correlation
Assumptions and random variables defined
Simple Linear Model Question 4
Excel Output and Equation
Interpretation of regression coefficients & coefficient of determination
Multiple Linear Model Question 5
Excel Output and Equation
Interpretation of regression coefficients & coefficient of determination
Statistical Inference
Choice of technique and other required steps
Decision and conclusion
Best model
Total Statistical Tasks
Written Answer (Components of a report)
Question 1
Question 2
Question 3
Questions 4 & 5
Introduction and discussion of best model
Structure, grammar, spelling and revised Part A content
Total Report
Comments
3

Dear Friend,
Confidence interval for proportion must be calculated for estimating
the population proportion of time when download speed is at least 80% of
the maximum speed, that is, 40 Mbps. Here, for calculating the population
proportion, the total number of population data will need to be
considered, which is n = 120.
The variables, Internet speed data and time, are random variables.
Random variable is the variable that takes the numerical outcomes of a
random event as possible values. The types of random variables are
continuous and discrete, and here, internet speed is the continuous
variable and Evening is the discrete variable.
Estimation of the population proportion of time that the download
speed is at least 40 Mbps
The confidence interval should be calculated for estimating the
population proportion of the time to achieve at least 80% of the maximum
speed, which is 40 Mbps or more.
Confidence Interval for proportion
Data
Sample Size 120
Count of Successes 17
Confidence Level 95%
Intermediate Calculations
Sample Proportion
0.1416
7
Z Value 1.9600
Standard Error of the
Proportion
0.0318
3
Margin of Error 0.0624
Confidence Interval
Interval Lower Limit 7.93%
Interval Upper Limit 20.41%
Therefore, the estimation of the population proportion of time for
download speed 40 Mbps ranges from 8% to 21%.
Average evening download speed
4