Course Hero Logo

blackstephanieH9.xlsx - Selecting a Random Sample 1. ABC...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 9 out of 24 pages.

Selecting a Random Sa1.ABC Accounting Firm wants to take a ranto select 5 to interview in depth aboutto customers.a. Use Excel to select a sample of 5 clients1.Spangles11. Dillon's2. McDonalds12. Dillard's3. Sweet Basil13. Sear's4. Chinatown14.J. C. Penne5. Kobe15. YMCA6. Attitudes16. Tabot's7. Dream Big Dance Stud17. Footlocker8. KS Dance Academy18. Claire's9. Taco Bell19. Village Pizza10. Papa John's20. Nail Auto Se
b. Indicate which sampling method you useRandBetween(low, high), Sampling Tool,
example, if you use RandBetween, fill inNO CREDIT if your output does not matc2. It is usual in telephone surveys to use rathe last four digits of a telephone numbeexchange (the first three digits).Obtain 3 randomfour-digit telephone nu
b. Indicate which sampling method you use
example, if you use RandBetween, fill inNO CREDIT if your output does not matc
amplendom sample of its 30 clientst ways to improve its services from this list.21. Rave22. Icing23. Bath and Body Works24. Abercrombie's25. Dairy Queen26. Taco Tico27. Hallmark Cards28. Von Maur29. Candyopolis30. Phillips 66
ed: Rand() with Data Sort,, etc.(2 pts.)Be VERY specific!For
n the numbers for the low and high!ch your method.andom digit dialing equipment that selectser at randomafter being given theed: Rand() with Data Sort,n the numbers for the low and high!ch your method.umbers., etc.(2 pts.)Be VERY specific!For
Selecting a Random Sample1.ABC Accounting Firm wants to take a random sample of its 30 clientsto select 5 to interview in depth about ways to improve its serviceto customers.a.Use Excel to select a sample of 5 clients from this list.1.Spangles11. Dillon's21. Rave2. McDonalds12. Dillard's22. Icing3. Sweet Basil13. Sear's23. Bath and Body Works4. Chinatown14.J. C. Penney24. Abercrombie's5. Kobe15. YMCA25. Dairy Queen6. Attitudes16. Tabot's26. Taco Tico7. Dream Big Dance Studio17. Footlocker27. Hallmark Cards8. KS Dance Academy18. Claire's28. Von Maur9. Taco Bell19. Village Pizza29. Candyopolis10. Papa John's20. Nail Auto Service30. Phillips 66170.00356520367712416. Tabot's70.0232345104753146. Attitudes240.03566350822058223. Bath and B120.08223813006581211. Dillon's130.08628745200350312. Dillard's260.116217659742423160.144015879470494200.17294846824157523270.23687549800175421210.316416893847982140.37804922531980416290.3851332420167872730.44494275047011819220.4486308289451771650.45146987376172526
20.46256423217834890.48427050710983280.4944335273320880.499193486621228140.579344737918182190.64737400806798100.667364042960961180.711215381459423110.780283118973911250.790160651376173150.84068462410590610.846299190327361300.85137005493277760.902862615604477230.98344928949859b.Indicate which sampling method you used: Rand() with Data Sort,example, if you use RandBetween, fill in the numbers for the low and high!NO CREDIT if your output does not match your method.Rand() with Data Sort2.It is usual in telephone surveys to use random digit dialing equipment that selectsthe last four digits of a telephone number at randomafter being given theexchange (the first three digits).

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 24 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
N/A
Tags
Randomness, Telephone number, Telephone numbering plan

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture