AQ077-3-2-PSMOD Sample Practical Test - Marking Scheme Page 1 of 3

Module Code and Title : AQ077-3-2-PSMOD | PROBABILITY AND STATISTICAL MODELLING Total Marks
Intake Code :
Assessment
Duration
: PRACTICAL TEST
: 1.5 hours
/ 50
Instruction:
1. Read ALL of the information carefully before you begin answering.
2. Use the Excel built-in function recommended in completing all tasks. If you are unable to complete the task using the function, you may use an alternative method but this will result in the loss of some of the marks for
the part. All your answers must be shown in the spreadsheet.
3. The spreadsheet should be constructed using the Excel built-in functions such that, should any of the values in these cells be changed, then all calculations will update automatically. In awarding marks consideration will
be given to the efficiency of any formulae constructed.
4. You MUST save your work in the same file at least every five minutes.
5. All your answer must be presented within the colored row.
6. You are required to download the excel file and follow the following steps upon submission:
(i) Save your file according to your TP number followed by name.
(i.e. TP000007 Muhammad Fadhirul Anuar Mohd Azami)
(ii) Upload you answers (Excel file) in the Assignment feature in the Ms Teams.
(iii) Once the file successfully uploaded. Click on the “Turn in” to submit.
(iv) You will be notified by Ms Teams once its submitted.

QUESTION 1 (25 marks)

(a) The following data provides the frequency distribution of the gas consumption.

Gas Consumption Frequency ( fi ) Mid point (x) fx fx^2

10 – 19 1 14.5 14.5 210.25
20 – 29 0 24.5 0 0
30 – 39 1 34.5 34.5 1190.25
40 – 49 4 44.5 178 7921

381.5 20791.75
50 – 59 7 54.5

1032 66564
60 – 69 16 64.5
70 – 79 19 74.5 1415.5 105454.75
80 – 89 20 84.5 1690 142805
90 – 99 17 94.5 1606.5 151814.25
100 – 109 11 104.5 1149.5 120122.75
110 – 119 3 114.5 343.5 39330.75
120 – 129 1 124.5 124.5 15500.25
100 7970 671705

(i) Calculate the mean.

=G18/E18 = 79.7

(ii) Calculate the standard deviation.

=SQRT((H18/E18)-(G18/E18)^2) = 19.1

(Hint: Use the following formulae to find the mean and standard deviation)

 fx  fx  fx 
2
2

x   
f f 
  f 

(iii) Construct the histogram.

25

20
10 – 19 1
Frequency

15 20 – 29 0
30 – 39 1
10 40 – 49 4
50 – 59 7
5
60 – 69 16
70 – 79 19
0
10 – 19 20 – 29 30 – 39 40 – 49 50 – 59 60 – 69 70 – 79 80 – 89 90 – 99 100 – 110 – 120 – 80 – 89 20
109 119 129 90 – 99 17
Gas Consumption 100 – 109 11
110 – 119 3
120 – 129 1

(iv) Construct an ogive.

Upper bound Cf
9.5 0
Orgive
19.5 1
120
29.5 1
100 39.5 2
49.5 6
80 59.5 13
69.5 29
60
79.5 48
40 89.5 68
99.5 85
20 109.5 96
AQ077-3-2-PSMOD Sample Practical Test - Marking Scheme Page 2 of 3

20

119.5 99
0
9.5 19.5 29.5 39.5 49.5 59.5 69.5 79.5 89.5 99.5 109.5 119.5 129.5 129.5 100

(b) The following scores represent the final examination marks for an elementary statistics course.

23 60 79 32 57 74 52 70 82 36
80 77 81 95 41 65 92 85 55 76
52 10 64 75 78 25 80 98 81 67
41 71 83 54 64 72 88 62 74 43
60 78 89 76 84 48 84 90 15 79
34 67 17 82 69 74 63 80 85 61

Find the numerical values for the minimum, maximum, mean, mode, median, standard deviation and variance on the marks. The built-in Excel functions for the measures are MIN, MAX,
AVERAGE, MODE, MEDIAN, STDEV and VAR respectively.

Minimum 10 =MIN(C76:L81) (a1)

Maximum 98 =MAX(C76:L81) (a1)
Mean 65.48333333 =AVERAGE(C76:L81) (a1)
Mode 74 =MODE(C76:L81) (a1)
Median 71.5 =MEDIAN(C76:L81) (a1)
Standard Deviation 21.13354765 =STDEV(C76:L81) (a1)
Variance 446.6268362 =VAR(C76:L81) (a1)

QUESTION 2 (25 marks)

Interest rates (x) provide an excellent leading indicator for predicting housing starts (y). As interest rates decline, housing starts increase, and vice versa. Suppose the data given in the
accompanying table represent the prevailing interest rates on first mortgages and the recorded building permits in a certain region over a 12-year span.

Year Interest rates (%) Building permits x^2 y^2 xy

1985 6.5 2165 42.25 4687225 14072.5
1986 6.0 2984 36.00 8904256 17904
1987 6.5 2780 42.25 7728400 18070
1988 7.5 1940 56.25 3763600 14550
1989 8.5 1750 72.25 3062500 14875
1990 9.5 1535 90.25 2356225 14582.5
1991 10.0 962 100.00 925444 9620
1992 9.0 1310 81.00 1716100 11790
1993 7.5 2050 56.25 4202500 15375
1994 9.0 1695 81.00 2873025 15255
1995 11.5 856 132.25 732736 9844
1996 15.0 510 225.00 260100 7650
106.5 20537 1014.75 41212111 163588

(a) Find the following values:

(i)  x2 106.5 =D114 (a1)
(ii) x 1014.75 =F114 (a1)
(iii)  y 20537 =E114 (a1)
(iv)  y2 41212111 =G114 (a1)
(v)  xy 163588 =H114 (a1)
(vi) n 12 =count(C102:C113) (a1)

(b) If the regression line of y on x is y  a  bx, find the values of a and b. Give your answers correct to two decimal places.

y = 4094.40 + -268.50 x

(c) Plot a scatter diagram of the building permits, y against interest rates, x .

Building permits
3500

3000

2500

2000

1500

1000

500

0
0.0 2.0 4.0 6.0 8.0 10.0 12.0 14.0 16.0

(d) Draw this regression line on your scatter diagram.

(e) Interpret the slope, b coefficient.

b= -268.5049 indicate that when the interest rate is increased by 1 unit (1000 lbs), building permint will decrease by 268.5049 miles per gallon.

(f) Find the product moment correlation coefficient and coefficient of determination for the data and comment on the results.
AQ077-3-2-PSMOD Sample Practical Test - Marking Scheme Page 3 of 3

Find the product moment correlation coefficient and coefficient of determination for the data and comment on the results.

r = -0.9094, indicates a strong positive linear relationship between building permits and interest rate.

r- square = 0.8269 implies that, of the sample variability in Building permits is explained by its linear dependence on the interest rate.

(g) Would you consider a regression model to be a reasonable choice for this data? Explain your answer.

Yes, as scatterplot shows linear pattern