Respondent_ID 3964-QJWTRG-NPN AnnualSalary Random_number_formula |Random_number_assigned Sample20_Mean Sample20_Median Sample20_Mode Sample20_Range_Max & Min Sample20_Range Sample20_SD $77,500.00 $172,500.00 $56,896.00...

Transcribed Image Text:

Respondent_ID 3964-QJWTRG-NPN AnnualSalary Random_number_formula |Random_number_assigned Sample20_Mean Sample20_Median Sample20_Mode Sample20_Range_Max & Min Sample20_Range Sample20_SD $77,500.00 $172,500.00 $56,896.00 0.76331759 0.325259392 0.023490411 $93,625.00 $71,250.00 $57,500.00 $210,000.00 $37,500.00 0648-AIPJSP-UVM $37,500.00 0.040228089 5195-TLUDJE-HVO 4459-VLPQUH-30L 8158-SMTQFB-CNO 7432-QKQFJJ-K72 $87,500.00 0.688851447 0.045528243 $50,000.00 0.784681651 0.046724568 $57,500.00 0.248298309 0.046930876 Notes: $192,500.00 0.844305456 0.085425605 9124-DZALHM-S61 $40,000.00 3512-MUWBGY-52X $210,000.00 5621-QSZPSF-NF2 $117,500.00 0.48648611 0.997774665 0.086122788 0.110094362 0.111777114 1) Sampling Method: Used =Rand() to generate random numbers and then sorted them by smallest to largest. Using the first 20 on the list. 2) The Sample: 20 3) Compute: Mean, Median, Mode, Range, and SD 0.114619251 4) Compare the sample's value of Mean and Median to the Text's (Population: 100) 8241-PWPONH-620 $47,500.00 0.85631314 8795-FYOXCT-P09 $182,500.00 0.233012095 0.115473637 0.120249301 5) Percentage Error or Difference: 2.5% 1705-NMIQNO-IC4 $157,500.00 0.308621906 0.135763426 19205-PAZEXY-90Q $42,500.00 0.170140452 0.155406533 T 4225-PZZDIY-IBH $57,500.00 0.022522634 0.161694529 2228-KOLOPU-FY3 $57,500.00 0.454541413 0.163387122 3853-NVDCOJ-TIN $55,000.00 0.768433601 0.192670332 10765-UXAFYM-PDR 9937-SFPLRK-H9Y $87,500.00 0.126338911 0.195345362 $70,000.00 0.716617511 0.19823879 6441-FJUWZQ-7G8 $72,500.00 0.196957215 0.200129385 2041-PNMGHX-TXJ $172,500.00 0.936271768 0.211378715 Respondent_ID 3964-QJWTRG-NPN AnnualSalary Random_number_formula |Random_number_assigned Sample20_Mean Sample20_Median Sample20_Mode Sample20_Range_Max & Min Sample20_Range Sample20_SD $77,500.00 $172,500.00 $56,896.00 0.76331759 0.325259392 0.023490411 $93,625.00 $71,250.00 $57,500.00 $210,000.00 $37,500.00 0648-AIPJSP-UVM $37,500.00 0.040228089 5195-TLUDJE-HVO 4459-VLPQUH-30L 8158-SMTQFB-CNO 7432-QKQFJJ-K72 $87,500.00 0.688851447 0.045528243 $50,000.00 0.784681651 0.046724568 $57,500.00 0.248298309 0.046930876 Notes: $192,500.00 0.844305456 0.085425605 9124-DZALHM-S61 $40,000.00 3512-MUWBGY-52X $210,000.00 5621-QSZPSF-NF2 $117,500.00 0.48648611 0.997774665 0.086122788 0.110094362 0.111777114 1) Sampling Method: Used =Rand() to generate random numbers and then sorted them by smallest to largest. Using the first 20 on the list. 2) The Sample: 20 3) Compute: Mean, Median, Mode, Range, and SD 0.114619251 4) Compare the sample's value of Mean and Median to the Text's (Population: 100) 8241-PWPONH-620 $47,500.00 0.85631314 8795-FYOXCT-P09 $182,500.00 0.233012095 0.115473637 0.120249301 5) Percentage Error or Difference: 2.5% 1705-NMIQNO-IC4 $157,500.00 0.308621906 0.135763426 19205-PAZEXY-90Q $42,500.00 0.170140452 0.155406533 T 4225-PZZDIY-IBH $57,500.00 0.022522634 0.161694529 2228-KOLOPU-FY3 $57,500.00 0.454541413 0.163387122 3853-NVDCOJ-TIN $55,000.00 0.768433601 0.192670332 10765-UXAFYM-PDR 9937-SFPLRK-H9Y $87,500.00 0.126338911 0.195345362 $70,000.00 0.716617511 0.19823879 6441-FJUWZQ-7G8 $72,500.00 0.196957215 0.200129385 2041-PNMGHX-TXJ $172,500.00 0.936271768 0.211378715