tugas excel

6
tinggi mhs Interval Kelas limit bawah kel limit atas kelas 152 150-154 150 154 153 155-159 155 159 153 160-164 160 164 154 165-169 165 169 155 170-174 170 174 156 156 156 Bin Frequency Cumulative % 156 154 4 4.00% 156 159 18 22.00% 157 164 40 62.00% 157 169 28 90.00% 157 174 10 100.00% 157 100.00% 158 158 158 149.95 0 158 154.95 4 158 159.95 23 159 164.95 63 159 169.95 91 159 174.95 100 160 160 160 152 161 161 Mean 163.545454545455 161 Standard Error 0.48567878812496 161 Median 164 161 Mode 164 161 Standard Deviat 4.83244292653504 162 Sample Variance 23.3525046382185 162 Kurtosis -0.428123912575 162 Skewness -0.0370029885388 162 Range 21 162 Minimum 153 162 Maximum 174 162 Sum 16191 162 Count 99 162 Largest(1) 174 163 Smallest(1) 153 163 Confidence Leve 0.9638137238565 163 163 163 163 163

Upload: fadyah-yulita

Post on 13-Nov-2015

219 views

Category:

Documents


0 download

DESCRIPTION

statistika

TRANSCRIPT

Sheet1tinggi mhsInterval Kelaslimit bawah kelaslimit atas kelasbatas bawah kelasbatas atas kelasfrek kelasTanda Kelas frek relatifprosentasi pengamatan152150-154150154149.95154.0541520.044153155-159155159154.95159.05181570.1818153160-164160164159.95164.05401620.440154165-169165169164.95169.05281670.2828155170-174170174169.95174.05101720.110156156156BinFrequencyCumulative %BinFrequencyCumulative %15615444.00%1644040.00%1561591822.00%1692868.00%1571644062.00%1591886.00%1571692890.00%1741096.00%15717410100.00%1544100.00%157100.00%100.00%158158158149.950158154.954158159.9523159164.9563159169.9591159174.95100160160160152161161Mean163.5454545455161Standard Error0.4856787881161Median164161Mode164161Standard Deviation4.8324429265162Sample Variance23.3525046382162Kurtosis-0.4281239126162Skewness-0.0370029885162Range21162Minimum153162Maximum174162Sum16191162Count99162Largest(1)174163Smallest(1)153163Confidence Level(95,0%)0.9638137239163163163163163163163163164164164164164164164164164164164164165165165165165166166166167167167167167167167167168168168168168168169169169169169169170170170171171172173173174174

Sheet2

Sheet3