{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel stats HW 2

# Excel stats HW 2 - b ∑x = 164.23 Standard deviation...

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

Christian Yimgnia Math 1150 - Elementary Statistics: Computer Assignment 2 Problem 16: Stocks and Bonds a) ∑x 103 x^2 y y^2 ∑x^2 4607 x 121 10 100 ∑y 90 11 0 -2 4 ∑y^2 2258 0 1296 29 841 36 441 14 196 b) sample mean x 10.3 21 961 22 484 variance x 394.0111 31 529 18 324 standard deviation x 19.84971 23 576 14 196 24 121 -2 4 sample mean y 9 -11 121 -3 9 variance y 160.8889 -11 441 -10 100 standard deviation y 12.6842 -21 c) Chebyshev's for x -29.39943 to 49.99943 1.927157 d) x Chebyshev's for y 1.409355 -16.3684 to 34.3684 y A lower CV is better so it can reduce the risk of the overall investment Problem 17: Epoxy 3.34 1.81 1.52 1.6 0.54 1.54 2.17 0.19 1.8 1.8 0.08 0.63 1.55 4.69 1.52 0.12 0.56 0.02 0.08 2.05 0.6 0.03 0.07 7.89 1.03 0.72 0.09 0.65 1.58 1.18 0.92 0.18 0.4 1.64 0.8 1.05 0.34 0.24 0.03 1.33 1.43 1.51 1.51 0.23 1.29 3.03 1.45 1.45 0.72 1.11 4.67 c) Mean 1.244898 a) range 61 variance 1.813709

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.

Unformatted text preview: b) ∑x = 164.23 Standard deviation 1.34674 ∑x^2 = 1.081808 d) CV x to failure will fluctuate by around 1hr per sample gher chance of change in time to failure in samples l not change as much and the data will be more consitent Christian Yimgnia Problem 19: Ducks and Geese x mallard ducks y canade goose 56 ∑x =245 24 ∑y= 224 85 ∑x^2 = 14655 53 ∑y^2= 12070 52 60 13 69 39 18 245 224 b) x mean 49 x variance 687.5 x stdev 26.2202212 c) y mean 44.8 y variance 508.7 y stdev 22.55437873 d) CV x 0.535106555 CV y 0.503445954 The average success percentage for canada goose will tend to be lower than the one for mallard ducks nest Problem 22...
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

Excel stats HW 2 - b ∑x = 164.23 Standard deviation...

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

View Full Document
Ask a homework question - tutors are online