Ch%203%20in%20Excel

Ch%203%20in%20Excel - 42 42 1st Quartile 42 42 2nd Quartile...

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

View Full Document Right Arrow Icon
46 54 42 46 32 Mean 44 Median 46 Mode 46
Background image of page 1

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

View Full DocumentRight Arrow Icon
Order No. Dawson Clark 1 9 8 2 10 7 3 9 10 4 11 10 5 9 13 6 10 12 7 11 10 8 9 9 9 9 15 10 10 10 [units] Mean 9.7 10.4 Days Sample Variance 0.677778 5.6 Days2 Sample Std Dev 0.823273 2.366432 Days Manual computation of sample variance - Dawson Order No. Xi Xi - X bar (Xi - X bar)^2 1 9 -0.7 0.49 2 10 0.3 0.09 3 9 -0.7 0.49 4 11 1.3 1.69 5 9 -0.7 0.49 6 10 0.3 0.09 7 11 1.3 1.69 8 9 -0.7 0.49 9 9 -0.7 0.49 10 10 0.3 0.09 Sum 6.1 x bar 9.7 s2 0.677778
Background image of page 2
Order No. Dawson Clark Class Freq 1 9 8 8 0 2 10 7 9 5 3 9 10 10 3 4 11 10 11 2 5 9 13 12 0 6 10 12 7 11 10 8 9 9 9 9 15 10 10 10 [units] Mean 9.7 10.4 Days Sample Variance 0.677778 5.6 Days2 Sample Std Dev 0.823273 2.366432 Days Coef. Of Variation 8.5% 22.8% "8.5% of the mean is the standard deviation" "the standard deviation is 8.5% of the mean" 8 9 10 11 12 0 1 2 3 4 5 6 Freq Axis Title Axis Title
Background image of page 3

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

View Full DocumentRight Arrow Icon
46 54 42 46 32 Manual Excel 85th Percentile 54 49.2 25th percentile
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 42 42 1st Quartile 42 42 2nd Quartile 46 46 Median 46 46 always the same 50th Percentile 46 46 Week No. # commercials Sales (1000s) 1 2 50 2 5 57 3 1 41 4 3 54 5 4 54 6 1 38 7 5 63 8 3 48 9 4 59 10 2 46 Scatter Diagram x y 2 50 5 57 1 41 3 54 4 54 1 38 5 63 3 48 4 59 2 46 "the more commercials, the greater the sales" "# of commercials and sales are positively related" "there is a positive linear relationship between commercials and sales" Correlation coefficient 0.930491 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 20 40 60 80 Commercials vs Sales # Commercials Sales (1000s)...
View Full Document

This note was uploaded on 01/23/2012 for the course ECON 2300 taught by Professor Dodonova during the Spring '08 term at Kennesaw.

Page1 / 5

Ch%203%20in%20Excel - 42 42 1st Quartile 42 42 2nd Quartile...

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

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