Question

plaese use excel and showing answer on excel

The distance between the points Pl and P2 was measured once a month of the entire year together with the temperature Jan FebaAprMayJuJulyAugepOctNDec Set A distance 1 Set B temperature 5.262 8810.0 120 166 22 258 20215.5 126 96 105.52 105.52 105.51 105,53 105.52 105.55 0s.56 105.58 105.59 105.57 105.56 105.56 1 8.8 (Co) Please compute the variances of set A (S2) and set B (S3) 2 1 Please prepare your using Microsoft Excel.

Answer 1

A -A 0.0008 0.0008 0.0014 0.0003 0.0008 0.0000 0.0002 0.0011 0.0018 0.0005 0.0002 0.0002 0.0078 B-B 77.2934 60.7101 26.9534 15.9334 3.2101 6.8034 67.3767 219.2867 38.5434 2.2751 1.9367 19.2867 539.6092 Set B distance 5.2 6.2 8.8 10 12.2 16.6 22.2 28.8 20.2 15.5 12.6 9.6 Set A distance 105.52 105.52 105.51 105.53 105.52 105.55 105.56 105.58 105.59 105.57 105.56 105.56 The 3rd and 4th column is using formulae =(D3-AVERAGE($D$3:$D$ 14)"2 ア 1) psing formulae 2 0.00780.0071 12 -1 539.6092 12 1 49.0554 TA,(Bi-B)"

Using function Set A Set B VAR(D3D14) 0.00071 VAR(E3 E14) 49.0554 Set A Set B VAR.SD3 D14) 0.00071 VAR S(E3E14) 49.0554 Set A Set B -VARA(D3D14) 0.00071 VARA(E3E14) 49.0554 As u can see in excel sheet fomulae in Excel VAR, VAR.S, VARA All 3 formulae are used to calculate Sample variance Variance of Set A (SA2)-0.00071 Variance of Set B (SB2) 49.0554