1.2 Data Management Software Questions (pp22)

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

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

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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This document was uploaded on 09/14/2011.

### 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
Ask a homework question - tutors are online