how do I find a random sample on excel? Subscribe Choose one of the following tw

Question

how do I find a random sample on excel?

Subscribe Choose one of the following two prompts to respond to. In your two follow up posts, respond at least once to each prompt option. Use the discussion board as a place to ask questions, speculate about answers, and share insights. Be sure to embed and cite your references for any supporting images. Option 1: Using the data set provided, select random samples of 5, 10, 20, and 50. Using Excel, construct a histogram for each sample. Share your histograms. Central Limit Them). In response to your peers, discuss how the sample size impacts the shape of your distribution. Option 2:

Explanation / Answer

On excel, use the randbetween function to get the values.

Let the serial numbers of values be 1,2....1000 etc.

Use =RANDBETWEEN(1,1000) to get the first value of the sample. Simply past this value on 100 rows to get a sample of size 100

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.