Question 1 – Topic 5 (5.5 marks)
The theoretical maximum download speed on a NBN 50 plan is 50 Mbps. Your friend asks you to estimate the proportion of time that they achieve at least 80%, that is, 40 Mbps or more, of this maximum.
To enable you to answer this useSpeed Test 1 Download(4thcolumn of your data)forall 120observationsand an appropriate statistical inference technique to:
Estimate the population proportion of time that the download speed is at least 40 Mbps.
Hint:Sort data onSpeed Test 1 Downloadto enable you to easily count the number of observations in your sample with a download speed of 40 Mbps or faster.
Question 2 – Topic6 (7.5 marks)
Your friend asks on average does their evening download speed exceed the advertised typical evening download speed of 41 Mbps.
To provide a justified answer to the question usetheeveningdownload speedfromSpeed Test 1 Download(4th column of data),your output from Part A and an appropriate statistical inference techniqueto answer the following question
Is the mean evening download speed greater than 41 Mbps?
Notes:
·The required data for the evening download speeds is in the first rows of your unsorted sample.
·If you have sorted your data onSpeed Test 1 Downloadin Question 1 sort onEvening(3rdcolumn of data). Alternatively, download your data again.
·Same consideration applies to Question 5.
Question 3 Topic 7 (8 marks)
To check the accuracy of the Speed Test 1 your friend repeated the test using a second speed test, Speed Test 2. On average each speed test should give the same download and upload speed.
Your friend asks you to check if the two tests on average give the same download speed.
To provide a justified answer useSpeed Test 1 Download(4thcolumn of data)andSpeed Test 2 Download(6thcolumn of data) forall 120observations in your sample, your output from Part A and an appropriate statistical inference techniqueto answer the following question.
Is there a difference in the average download speed given by the two tests?
Note:
Difference Download Speed(8th column of data) may be used as an alternative toSpeed Test 1 Download(4thcolumn of data)andSpeed Test 2 Download(6thcolumn of data).
Questions 4 and 5 Simple and Multiple Linear Regression (17 marks)
Your friend is interested in the relationship between download and upload speed. In particular they ask you to estimate upload speed from download speed.
To do this you develop a simple linear regression model to estimate upload speed from download speed and a multiple linear regression model to estimate upload speed from download speed and whether it is evening or not. Then you choose and interpret the linear model that best fits your data.
Question 4 Simple Linear Regression Model Topic 8
To explore the relationship between download and upload speed useSpeed Test 1 Download(4th column of data)as the independent variable with
Speed Test 1 Upload(5th column of data)as the dependent variable forall 120observationsin your sample and your output from Part A to develop and then explore a simple linear relationship between the two variables by:
·Calculating the least squares regression line, correlation coefficient and coefficient of determination.
·Interpreting the gradient and vertical intercept of the simple linear regression equation.
·Interpreting the coefficient of determination.
Question 5 Multiple Linear Regression Model Topic 9
To explore whether being evening (7 pm to 11 pm) or not also influences upload speed addEvening(3rdcolumn of data) as a second independent variable, to develop and then explore the relationship between the three variables by:
·Calculating the multiple regression equation and coefficient of determination.
·Interpreting the values of the multiple regression coefficients.
·Interpreting the value of the coefficient of determination. Compare the value with the corresponding value for the simple linear regression model.
Then determine the best model to estimate upload speed by:
·Using appropriate tests to determine which independent variables make a significant contribution to the regression model.
·Then state the simple or multiple regression equation which best fits the data.
Notes:
·You may need to transform or manipulate the given data, before using Excel for the corresponding statistical calculations.
·Use Excel for all 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, where appropriate justify these from Part A output.
·In Question 4 fit a linear model even if from your scatter plot you decide that a non-linear relationship better fits the data or that no apparent relationship exists. However, mention this in your written answer and/or corresponding appendix.
·Comment on why a test or confidence interval has been chosen. Where appropriate include and refer to Part A output.
·Make sure you interpret confidence intervals and write conclusions to hypothesis tests.Question 1 – Topic 5 (5.5 marks)
The theoretical maximum download speed on a NBN 50 plan is 50 Mbps. Your friend asks you to estimate the proportion of time that they achieve at least 80%, that is, 40 Mbps or more, of this maximum.
To enable you to answer this useSpeed Test 1 Download(4thcolumn of your data)forall 120observationsand an appropriate statistical inference technique to:
Estimate the population proportion of time that the download speed is at least 40 Mbps.
Hint:Sort data onSpeed Test 1 Downloadto enable you to easily count the number of observations in your sample with a download speed of 40 Mbps or faster.
Question 2 – Topic6 (7.5 marks)
Your friend asks on average does their evening download speed exceed the advertised typical evening download speed of 41 Mbps.
To provide a justified answer to the question usetheeveningdownload speedfromSpeed Test 1 Download(4th column of data),your output from Part A and an appropriate statistical inference techniqueto answer the following question
Is the mean evening download speed greater than 41 Mbps?
Notes:
·The required data for the evening download speeds is in the first rows of your unsorted sample.
·If you have sorted your data onSpeed Test 1 Downloadin Question 1 sort onEvening(3rdcolumn of data). Alternatively, download your data again.
·Same consideration applies to Question 5.
Question 3 Topic 7 (8 marks)
To check the accuracy of the Speed Test 1 your friend repeated the test using a second speed test, Speed Test 2. On average each speed test should give the same download and upload speed.
Your friend asks you to check if the two tests on average give the same download speed.
To provide a justified answer useSpeed Test 1 Download(4thcolumn of data)andSpeed Test 2 Download(6thcolumn of data) forall 120observations in your sample, your output from Part A and an appropriate statistical inference techniqueto answer the following question.
Is there a difference in the average download speed given by the two tests?
Note:
Difference Download Speed(8th column of data) may be used as an alternative toSpeed Test 1 Download(4thcolumn of data)andSpeed Test 2 Download(6thcolumn of data).
Questions 4 and 5 Simple and Multiple Linear Regression (17 marks)
Your friend is interested in the relationship between download and upload speed. In particular they ask you to estimate upload speed from download speed.
To do this you develop a simple linear regression model to estimate upload speed from download speed and a multiple linear regression model to estimate upload speed from download speed and whether it is evening or not. Then you choose and interpret the linear model that best fits your data.
Question 4 Simple Linear Regression Model Topic 8
To explore the relationship between download and upload speed useSpeed Test 1 Download(4th column of data)as the independent variable with
Speed Test 1 Upload(5th column of data)as the dependent variable forall 120observationsin your sample and your output from Part A to develop and then explore a simple linear relationship between the two variables by:
·Calculating the least squares regression line, correlation coefficient and coefficient of determination.
·Interpreting the gradient and vertical intercept of the simple linear regression equation.
·Interpreting the coefficient of determination.
Question 5 Multiple Linear Regression Model Topic 9
To explore whether being evening (7 pm to 11 pm) or not also influences upload speed addEvening(3rdcolumn of data) as a second independent variable, to develop and then explore the relationship between the three variables by:
·Calculating the multiple regression equation and coefficient of determination.
·Interpreting the values of the multiple regression coefficients.
·Interpreting the value of the coefficient of determination. Compare the value with the corresponding value for the simple linear regression model.
Then determine the best model to estimate upload speed by:
·Using appropriate tests to determine which independent variables make a significant contribution to the regression model.
·Then state the simple or multiple regression equation which best fits the data.
Notes:
·You may need to transform or manipulate the given data, before using Excel for the corresponding statistical calculations.
·Use Excel for all 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, where appropriate justify these from Part A output.
·In Question 4 fit a linear model even if from your scatter plot you decide that a non-linear relationship better fits the data or that no apparent relationship exists. However, mention this in your written answer and/or corresponding appendix.
·Comment on why a test or confidence interval has been chosen. Where appropriate include and refer to Part A output.
·Make sure you interpret confidence intervals and write conclusions to hypothesis tests.
Sample |
Time |
Evening |
Speed Test 1 Download |
Speed Test 1 Upload |
Speed Test 2 Download |
Speed Test 2 Upload |
Difference Download Speed |
Sample |
7:40 pm |
Evening |
39.30 |
16.90 |
42.90 |
16.60 |
-3.60 |
Sample |
7:15 pm |
Evening |
30.80 |
13.80 |
40.00 |
16.10 |
-9.20 |
Sample |
8:35 pm |
Evening |
30.50 |
12.70 |
38.90 |
16.10 |
-8.40 |
Sample |
7:19 pm |
Evening |
42.20 |
11.50 |
33.10 |
11.20 |
9.10 |
Sample |
9:45 pm |
Evening |
21.80 |
11.50 |
33.90 |
11.40 |
-12.10 |
Sample |
10:42 pm |
Evening |
9.06 |
5.57 |
24.10 |
9.60 |
-15.04 |
Sample |
8:15 pm |
Evening |
27.60 |
9.01 |
39.20 |
14.60 |
-11.60 |
Sample |
9:17 pm |
Evening |
18.90 |
9.07 |
38.00 |
16.10 |
-19.10 |
Sample |
8:16 pm |
Evening |
28.70 |
15.10 |
33.10 |
14.80 |
-4.40 |
Sample |
7:42 pm |
Evening |
30.80 |
9.83 |
38.60 |
14.50 |
-7.80 |
Sample |
7:48 pm |
Evening |
27.00 |
15.80 |
23.50 |
16.00 |
3.50 |
Sample |
8:16 pm |
Evening |
25.10 |
10.20 |
39.00 |
13.90 |
-13.90 |
Sample |
7:05 pm |
Evening |
27.70 |
15.50 |
24.60 |
15.30 |
3.10 |
Sample |
8:30 pm |
Evening |
42.60 |
15.10 |
38.60 |
15.30 |
4.00 |
Sample |
9:10 pm |
Evening |
19.60 |
13.20 |
25.20 |
12.00 |
-5.60 |
Sample |
7:52 pm |
Evening |
13.80 |
11.50 |
29.60 |
11.40 |
-15.80 |
Sample |
8:20 pm |
Evening |
17.40 |
8.34 |
7.50 |
3.20 |
9.90 |
Sample |
9:26 pm |
Evening |
13.80 |
6.03 |
26.90 |
11.00 |
-13.10 |
Sample |
7:17 pm |
Evening |
39.60 |
11.80 |
38.20 |
15.70 |
1.40 |
Sample |
8:02 pm |
Evening |
29.40 |
13.30 |
38.20 |
13.60 |
-8.80 |
Sample |
7:45 pm |
Evening |
19.50 |
13.10 |
14.20 |
8.80 |
5.30 |
Sample |
7:50 pm |
Evening |
18.00 |
11.80 |
23.10 |
10.90 |
-5.10 |
Sample |
8:27 pm |
Evening |
16.20 |
12.50 |
25.20 |
12.60 |
-9.00 |
Sample |
8:35 pm |
Evening |
9.54 |
6.36 |
20.00 |
12.90 |
-10.46 |
Sample |
9:14 pm |
Evening |
16.50 |
13.90 |
26.20 |
12.40 |
-9.70 |
Sample |
9:17 pm |
Evening |
13.50 |
9.83 |
22.40 |
11.90 |
-8.90 |
Sample |
9:44 pm |
Evening |
12.50 |
9.36 |
22.90 |
10.20 |
-10.40 |
Sample |
10:02 pm |
Evening |
32.30 |
14.40 |
28.90 |
12.40 |
3.40 |
Sample |
7:06 pm |
Evening |
18.60 |
10.60 |
22.30 |
12.60 |
-3.70 |
Sample |
8:12 pm |
Evening |
13.70 |
7.68 |
22.60 |
12.10 |
-8.90 |
Sample |
9:18 pm |
Evening |
19.90 |
12.10 |
17.40 |
12.50 |
2.50 |
Sample |
7:37 pm |
Evening |
21.50 |
6.73 |
38.40 |
9.10 |
-16.90 |
Sample |
7:42 pm |
Evening |
29.90 |
14.40 |
36.90 |
14.40 |
-7.00 |
Sample |
8:44 pm |
Evening |
41.40 |
14.10 |
36.10 |
10.90 |
5.30 |
Sample |
10:35 pm |
Evening |
38.40 |
12.30 |
42.30 |
11.20 |
-3.90 |
Sample |
7:50 pm |
Evening |
33.60 |
15.30 |
15.00 |
15.30 |
18.60 |
Sample |
7:59 pm |
Evening |
22.20 |
12.90 |
29.30 |
14.50 |
-7.10 |
Sample |
8:35 pm |
Evening |
21.20 |
12.60 |
7.80 |
4.00 |
13.40 |
Sample |
9:15 pm |
Evening |
16.90 |
11.20 |
20.90 |
7.60 |
-4.00 |
Sample |
10:14 pm |
Evening |
11.50 |
8.80 |
9.70 |
3.30 |
1.80 |
Sample |
7:04 pm |
Evening |
43.10 |
15.70 |
36.40 |
15.60 |
6.70 |
Sample |
7:15 pm |
Evening |
43.00 |
15.10 |
40.00 |
15.10 |
3.00 |
Sample |
7:05 pm |
Evening |
22.10 |
11.50 |
23.80 |
15.20 |
-1.70 |
Sample |
9:35 pm |
Evening |
13.30 |
5.38 |
22.20 |
5.70 |
-8.90 |
Sample |
10:10 pm |
Evening |
18.50 |
11.80 |
27.90 |
12.30 |
-9.40 |
Sample |
10:14 pm |
Evening |
11.10 |
11.50 |
10.60 |
11.10 |
0.50 |
Sample |
10:47 pm |
Evening |
7.22 |
9.43 |
11.70 |
10.80 |
-4.48 |
Sample |
8:04 pm |
Evening |
30.20 |
10.60 |
19.70 |
3.90 |
10.50 |
Sample |
8:43 pm |
Evening |
30.20 |
13.40 |
37.50 |
15.40 |
-7.30 |
Sample |
8:48 pm |
Evening |
29.00 |
15.10 |
38.80 |
14.60 |
-9.80 |
Sample |
10:14 pm |
Evening |
21.10 |
14.20 |
11.90 |
11.40 |
9.20 |
Sample |
8:12 pm |
Evening |
42.90 |
15.10 |
38.40 |
13.20 |
4.50 |
Sample |
7:00 am |
Not Evening |
21.40 |
11.50 |
30.50 |
9.00 |
-9.10 |
Sample |
3:43 pm |
Not Evening |
26.60 |
14.60 |
35.70 |
15.50 |
-9.10 |
Sample |
3:49 pm |
Not Evening |
20.30 |
13.50 |
26.80 |
13.60 |
-6.50 |
Sample |
10:10 am |
Not Evening |
30.70 |
14.80 |
34.60 |
16.40 |
-3.90 |
Sample |
11:42 am |
Not Evening |
32.80 |
16.10 |
35.20 |
16.40 |
-2.40 |
Sample |
3:23 pm |
Not Evening |
21.60 |
9.21 |
35.70 |
14.70 |
-14.10 |
Sample |
5:10 pm |
Not Evening |
27.70 |
15.60 |
38.70 |
15.70 |
-11.00 |
Sample |
7:23 am |
Not Evening |
18.00 |
10.60 |
22.20 |
11.50 |
-4.20 |
Sample |
8:02 am |
Not Evening |
8.47 |
10.30 |
27.10 |
12.10 |
-18.63 |
Sample |
8:23 am |
Not Evening |
28.70 |
11.40 |
30.40 |
11.80 |
-1.70 |
Sample |
10:30 am |
Not Evening |
19.10 |
11.30 |
17.70 |
11.60 |
1.40 |
Sample |
12:55 pm |
Not Evening |
21.00 |
11.40 |
27.70 |
9.50 |
-6.70 |
Sample |
3:09 pm |
Not Evening |
28.60 |
11.40 |
30.00 |
11.70 |
-1.40 |
Sample |
6:35 am |
Not Evening |
42.80 |
15.20 |
38.10 |
15.20 |
4.70 |
Sample |
5:55PM |
Not Evening |
42.70 |
15.60 |
38.00 |
15.50 |
4.70 |
Sample |
5:20 am |
Not Evening |
30.70 |
11.60 |
24.80 |
12.00 |
5.90 |
Sample |
6:03 am |
Not Evening |
18.80 |
7.68 |
29.10 |
8.10 |
-10.30 |
Sample |
7:06 am |
Not Evening |
23.40 |
11.50 |
29.70 |
5.70 |
-6.30 |
Sample |
5:44 am |
Not Evening |
16.50 |
10.80 |
27.40 |
13.50 |
-10.90 |
Sample |
6:10 am |
Not Evening |
42.90 |
15.10 |
34.90 |
14.90 |
8.00 |
Sample |
6:53 am |
Not Evening |
21.90 |
10.40 |
34.30 |
14.70 |
-12.40 |
Sample |
6:56 am |
Not Evening |
27.70 |
15.10 |
22.50 |
12.50 |
5.20 |
Sample |
7:41 am |
Not Evening |
21.90 |
11.50 |
36.80 |
13.80 |
-14.90 |
Sample |
8:20 am |
Not Evening |
38.20 |
15.70 |
43.50 |
14.50 |
-5.30 |
Sample |
8:25 am |
Not Evening |
20.20 |
12.60 |
43.40 |
12.80 |
-23.20 |
Sample |
1:50 pm |
Not Evening |
35.80 |
13.10 |
25.70 |
9.70 |
10.10 |
Sample |
5:55 am |
Not Evening |
28.90 |
15.40 |
11.40 |
4.50 |
17.50 |
Sample |
8:03 am |
Not Evening |
28.40 |
10.50 |
39.20 |
15.70 |
-10.80 |
Sample |
8:06 am |
Not Evening |
15.80 |
4.07 |
35.90 |
13.70 |
-20.10 |
Sample |
7:29 am |
Not Evening |
39.80 |
11.50 |
43.40 |
11.60 |
-3.60 |
Sample |
10:50 am |
Not Evening |
19.90 |
11.10 |
31.70 |
11.80 |
-11.80 |
Sample |
12:10 am |
Not Evening |
18.40 |
10.60 |
25.80 |
11.80 |
-7.40 |
Sample |
11:01 am |
Not Evening |
33.70 |
10.40 |
32.50 |
15.20 |
1.20 |
Sample |
5:43 pm |
Not Evening |
25.80 |
11.30 |
18.70 |
13.50 |
7.10 |
Sample |
6:48 am |
Not Evening |
42.50 |
15.40 |
26.00 |
11.10 |
16.50 |
Sample |
8:23 am |
Not Evening |
42.90 |
13.50 |
44.60 |
11.50 |
-1.70 |
Sample |
3:59 PM |
Not Evening |
32.00 |
11.00 |
33.10 |
10.90 |
-1.10 |
Sample |
7:41 am |
Not Evening |
16.90 |
11.40 |
14.40 |
11.30 |
2.50 |
Sample |
10:03 am |
Not Evening |
13.50 |
9.57 |
31.80 |
8.20 |
-18.30 |
Sample |
12:39 pm |
Not Evening |
21.20 |
10.80 |
29.60 |
9.00 |
-8.40 |
Sample |
2:51 pm |
Not Evening |
21.20 |
10.10 |
28.60 |
10.40 |
-7.40 |
Sample |
7:00 am |
Not Evening |
43.20 |
15.00 |
39.80 |
12.50 |
3.40 |
Sample |
12:20 pm |
Not Evening |
43.00 |
14.50 |
44.30 |
14.70 |
-1.30 |
Sample |
12:26 pm |
Not Evening |
32.00 |
15.50 |
44.20 |
11.50 |
-12.20 |
Sample |
3:40 pm |
Not Evening |
29.30 |
15.40 |
42.70 |
15.90 |
-13.40 |
Sample |
3:48 pm |
Not Evening |
32.80 |
16.10 |
42.30 |
13.60 |
-9.50 |
Sample |
10:19 am |
Not Evening |
32.00 |
15.40 |
38.30 |
16.10 |
-6.30 |
Sample |
10:28 am |
Not Evening |
27.90 |
14.70 |
15.20 |
13.10 |
12.70 |
Sample |
2:08 pm |
Not Evening |
35.20 |
11.10 |
25.80 |
5.70 |
9.40 |
Sample |
2:15 pm |
Not Evening |
30.20 |
14.70 |
16.70 |
14.30 |
13.50 |
Sample |
10:16 am |
Not Evening |
36.00 |
8.97 |
37.80 |
14.50 |
-1.80 |
Sample |
5:30 am |
Not Evening |
12.50 |
15.30 |
14.20 |
11.60 |
-1.70 |
Sample |
4:31 am |
Not Evening |
26.60 |
11.50 |
10.30 |
7.10 |
16.30 |
Sample |
7:36 am |
Not Evening |
42.70 |
11.40 |
25.40 |
5.70 |
17.30 |
Sample |
12:00 pm |
Not Evening |
24.70 |
11.30 |
14.90 |
7.90 |
9.80 |
Sample |
4:12 pm |
Not Evening |
18.40 |
11.30 |
20.00 |
11.50 |
-1.60 |
Sample |
7:03 am |
Not Evening |
42.70 |
15.40 |
38.30 |
15.90 |
4.40 |
Sample |
5:37 pm |
Not Evening |
43.10 |
16.40 |
28.40 |
8.60 |
14.70 |
Sample |
8:59 am |
Not Evening |
31.20 |
13.00 |
37.30 |
11.60 |
-6.10 |
Sample |
9:03 am |
Not Evening |
28.50 |
13.90 |
34.80 |
11.50 |
-6.30 |
Sample |
11:00 am |
Not Evening |
36.60 |
13.40 |
35.20 |
12.70 |
1.40 |
Sample |
11:05 am |
Not Evening |
30.90 |
11.80 |
40.50 |
13.00 |
-9.60 |
Sample |
2:12 pm |
Not Evening |
34.40 |
12.50 |
26.80 |
11.30 |
7.60 |
Sample |
2:18 pm |
Not Evening |
11.50 |
13.30 |
28.80 |
13.70 |
-17.30 |
Sample |
12:54 pm |
Not Evening |
32.40 |
14.70 |
43.70 |
14.50 |
-11.30 |
Sample |
1:02 pm |
Not Evening |
14.10 |
9.54 |
31.90 |
14.90 |
-17.80 |
Sample |
1:38 pm |
Not Evening |
41.00 |
11.10 |
25.10 |
12.90 |
15.90 |
Sample |
6:21 pm |
Not Evening |
31.20 |
13.70 |
33.10 |
14.60 |
-1.90 |