1.2 Data Management Software Questions (pp22)

1.2 Data Management Software Questions (pp22) - Sheet1 1.2...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 1 a), b), c), d) Student Marks Dentist Appointment times (mins) 30 30 43 32 56 38 56 40 65 40 72 41 74 45 76 45 80 45 81 60 88 92 99 Mean:70.15 Mean:41.6 Median:74 Median:40.5 Mode:56 Mode:45 2 a,b,c,d,e,f,g,h,i,j,k. (On Sheet 2) a) sum of the numbers stored in cells A1 to A9 EQ=SUM(A1:A9) b) largest number stored in cells F3 to K3 EQ=MAX(F2:K3) c)The smallest number in the block from A1 to K4 EQ=MIN(A1:K4) d)the sum of cells A2, B5, C7, and D9 EQ=SUM(A2+B5+C7+D9) e)the mean, median, and mode of the numbers stored in the cells F5 to M5 EQ=MEDIAN(F5:M5) EQ=AVERAGE(F5:M5) EQ=MODE(F5:M5) f)the square root of the number in cell A3 EQ=SQRT(A3) g)the cube of the number in cell B6 EQ=POWER(B6;3) h)the number in cell D2 rounded off to four decimal places EQ=ROUND(D2:4) I)the number of cells between cells D3 and M9 that contain data EQ=COUNT(D3:M9) j)the product of the values in cells A1, B3, and C5 to C10 EQ=PRODUCT(A1;B3;C5:C10) k)the value of pi EQ=PI() 4 Branch Brand A Brand B
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

1.2 Data Management Software Questions (pp22) - Sheet1 1.2...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online