{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel stats HW

# Excel stats HW - 1.333064 d CV x 1.073147 This number...

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

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

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: 1.333064 d) CV x 1.073147 This number means the time to failure will fluctuate by around 1hr per sample The larger the CV, then the higher chance of change in time to failure in samples The lower the CV, the time to fail will not change as much and the data will be more consitent 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 - 1.333064 d CV x 1.073147 This number...

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

View Full Document
Ask a homework question - tutors are online