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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
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

This note was uploaded on 02/11/2012 for the course STAT 100 taught by Professor Brent during the Spring '11 term at University of Minnesota Duluth.

Page1 / 3

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

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

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