hw4 - Sample Data Sample Data Tools > Data 5 Then...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Sample Data Sample Data Tools > Data 5 Then highlig 2 Mean 7.3000 <----- xba 7 Standard Error 1.0333 <----- do 8 Median 7.5000 <----- Q2 12 Mode 5.0000 <----- val 11 Standard Deviation 3.2677 <----- s = 9 Sample Variance 10.6778 <----- s^2 4 Kurtosis-1.0836 <----- do 5 Skewness-0.1185 <----- do 10 Range 10.0000 <----- ran Minimum 2.0000 <----- min Maximum 12.0000 <----- max Sum 73.0000 <----- sum Count 10.0000 <----- n Q1 5.0000 <----- Q1 Q3 9.7500 <----- Q3 a Analysis > Descriptive Statistics > Input Range: a:a, Labels in First Row: check, Output Range: d1, Summary Statistics ght column E, Format > Cells > Number > Decimal Places: 4, OK ar = sumxi/n not need to know position = (2n+2)/4 = (n+1)/2 = 8th position. Therefore, Q2 = the value in the 8th position when the data is put in as lue that appears the most = sqrt[s^2] 2 = {1/(n-1)}*{sumxi^2-(1/n)*(sumxi)^2} not need to know not need to know nge = max - min nimum value ximum value mxi = x1 + x2+ + xn position = (n+3)/4 = 4.5th position. Therefore, Q1 = the value in the 4.5th position when the data is put in ascending position = (3n+1)/4 = 11.5th position. Therefore, Q3 = the value in the 11.5th position when the data is put in ascend : check cending order = 45. order = 36+(.5)*(37-36) = 36.5. ing order = 49+(.5)*(50-49) = 49.5. Cars Kids Count of Cars Kids 1 1 Cars 1 2 3 4 5 1 2 1 1 1 2 2 2 1 3 2 4 2 1 3 3 1 3 3 2 2 1 4 Grand Total 5 5 5 5 5 1 4 1 5 1 5 1 6 1 6 2 1 2 1 2 1 2 1 2 2 2 2 2 3 2 4 2 4 2 4 2 5 2 5 2 5 2 6 2 6 3 2 3 2 3 3 3 3 3 6 Data > PivotTable and PivotChart Report > Next, Range: a:b, 6 Grand Total Then click a down arrow in the table and uncheck (blank) 2 10 2 15 1 5 5 30 Next, Existing Worksheet: e1, Layout: Drag Cars to Row, Kids to Column, and Cars to Data (if you do not see Count of Ca ars in Data, double click, select Count of Cars, then OK), OK, Finish Binomial n 15 <----- This piece of information must be entered by the user. p 0.4000 <----- This piece of information must be entered by the user. xi P(X<=xi) <----- xi value (column 1), cumulative probability (column 2) 0.0005 <----- P(X<=0) = P(0) where P(0)=[nC0]*[p^0]*[(1-p)^(n-0)] 1 0.0052 <----- P(X<=1) = P(0)+P(1) 2 0.0271 <----- P(X<=2) = P(0)+P(1)+P(2) 3 0.0905 4 0.2173 5 0.4032 6 0.6098 7 0.7869 8 0.9050 9 0.9662 10 0.9907 11 0.9981 12 0.9997 13 1.0000 <----- P(X<=13) = P(0)+P(1)++P(13) 14 1.0000 <----- P(X<=14) = P(0)+P(1)++P(14) 15 1.0000 <----- P(X<=15) = P(0)+P(1)++P(15) 16 Err:502 <----- A probability value of #NUM! means the xi is beyond n. 17 Err:502 18 Err:502 19 Err:502 20 Err:502 21 Err:502 22 Err:502 23 Err:502 24 Err:502 25 Err:502 26 Err:502 27 Err:502 28 Err:502 29 Err:502 30 Err:502 Normal mu 6312 sigma 2029 xi P(X<=xi) 3280.00 0.0675 4850.00 0.2356 7500.00 0.7209 6720.00 0.5797 11930.00 0.9972 2140.00 0.0199 P(X<=xi) xi 0.3200 5363.0391 0.9400 9466.6356 0.1100 3823.3744 Age Population Standard Deviation 5.0000 20 15 Sample Size 10 19 Sample Mean 18.0000 17 18 Confidence Interval 16 Confidence Coefficient...
View Full Document

This note was uploaded on 04/14/2008 for the course DISC 3331 taught by Professor Smith during the Spring '08 term at University of Houston.

Page1 / 60

hw4 - Sample Data Sample Data Tools > Data 5 Then...

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

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