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...

• 27

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 2 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 n σ σ x x α/ x x α/ x σ z x LCL σ z x UCL 2 2 64 a. b. n 30 n 60 xbar 507 xbar 507 pop std dev 63 pop std dev 63 confid int 0.9 • • •
{"ft_lang_label":"__label__en","ft_lang_prob":0.670605,"math_prob":0.98043495,"size":569,"snap":"2021-04-2021-17","text_gpt3_token_len":167,"char_repetition_ratio":0.118584074,"word_repetition_ratio":0.0,"special_character_ratio":0.28295255,"punctuation_ratio":0.15306123,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9810952,"pos_list":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20],"im_url_duplicate_count":[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-04-10T11:45:58Z\",\"WARC-Record-ID\":\"<urn:uuid:a422af56-3460-49c1-973e-08605236b79e>\",\"Content-Length\":\"327994\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:897e6973-f747-4d39-b349-5ccc4b2c9361>\",\"WARC-Concurrent-To\":\"<urn:uuid:977193ec-a314-45fc-afd4-01ab8cea223f>\",\"WARC-IP-Address\":\"104.17.93.47\",\"WARC-Target-URI\":\"https://www.coursehero.com/file/59977798/chapter-8-student-data-filesjxlsx/\",\"WARC-Payload-Digest\":\"sha1:WQO4VUGF5A5FWDSHGZKSKIBL5EEQWHGS\",\"WARC-Block-Digest\":\"sha1:IH7LKBPPMI5MCP3CWTP4EO7YVY3PC3LT\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-17/CC-MAIN-2021-17_segments_1618038056869.3_warc_CC-MAIN-20210410105831-20210410135831-00258.warc.gz\"}"}