chapter 8 student data files,j.xlsx - we know pop std dev we don't know pop std deviation sample mean z\u03b1\/2 excel function to calculate zscore

chapter 8 student data files,j.xlsx - we know pop std dev...

This preview shows page 1 - 7 out of 27 pages.

we know pop std dev we don't know pop std deviation sample mean excel function to calculate zscore =norm.s.inv standard normal distribution norm.s.inv at alpha over 2 z α/2
Image of page 1
2
Image of page 2
Image of page 3
n samle size 35 xbar sample mean 247.8 pop std dev 39 confidence int 0.9 level of signifigance alpha 0.1 alpha/2 0.05 calculate std error 6.592203 1.644854 set to positive margin of error 10.84321 upper confidence interval 258.643209 lower confidence interval 236.95679068 we are 90% confident that the population mean of a lexury hotel cost per night is between $236.96 and $258.6 [email protected]/2 n σ σ x x α/ x x α/ x σ z x LCL σ z x UCL 2 2
Image of page 4
64
Image of page 5
a. b. n 30 n 60 xbar 507 xbar 507 pop std dev 63 pop std dev 63 confid int 0.9
Image of page 6
Image of page 7

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture