Question

we wil be using Excel to simulate the number of lefthanded people in a particular sample left handed people make up about 10% ofthe pc Please note there are five parts to this question First, generate a random sample of 30 data points (1-10). To easily determine how many lefties are in the sample, you can use the command between 1 and 10, where 1 represents a left handed person ard 2-10 represents a r tha ded person. This should result in about 10% of urs ple b ngleft handed iftrange, 1). The range will be something like a1 a30, if you created your sample in column a. This will count how many number 1s there are. You can determine the number of right handed people by subtracting this number from 30 Create a pie graph in Excel to show the proportion of left-handed s right-handed people are in your sample, and save it as an image file Attach the pie graph using the insert image option, and note what percentage of your sample was actually left handed ditInset- Formats-
and generate a random sample of 1 50 data points ( 1-1 Oi Create a pie graph in Excel to show the proportion of left.handed vs right.handed people are in your sample, and save it as an image file. Atach the pie graph using the insert tmage option, and note what percentage of your sample was actually left-handed Edit . Insert . Formats . B 1 x, x 스. 즈. () E王玉ー.IE.蘯蘯ee2尘 13-Σ. Σ ~
Next generate a rare m 돼rple of 280 data points(1-10 Opatra-gah n Erd to show theproportin of left hinded v·ngthanded people are in your sample and save it as an inge fle Attachthe piegraph using the insert Image option and note what percentage off your sample was actually left-handed E İ-.E. 1薀@ea2銮田. Σ. Σ ~
Then generate a random sample of 1500 data points (1-10) Create a pie graph in Excel to show the proportion of left-handed vs, right handed option, and note what percentage of your sample was actually left-handed people are in your sample,and save it as an image file. Attach the ple graph using the Insert image Edit. Insert . Formats , B / y x, x A,盖. O in as much detail as possible, explain what youve noticed in this exercise. You should state what popu aton proportion of 10%? Make sure to address what you noticed as the sample size ncreased You will be graded on the completeness ofyour answer. Remember, you can record audio of your explanation if yourd prefer that over typing You should attach that audio in the entry box below of people were left-handed in each sample How did this compare to the Edit . Insert. Formats . B 1 u x, x Α.Χ. E -.1-. @dP 2 w m. Σ. Σ ~
0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
we wil be using Excel to simulate the number of lefthanded people in a particular sample...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • We will be using Excel to simulate the number of left-handed people in a particular sample....

    We will be using Excel to simulate the number of left-handed people in a particular sample. Left-handed people make up about 10% of the population. We will randomly pick numbers between 1 and 10, where 1 represents a left-handed person and 2 - 10 represents a right-handed person. This should result in about 10% of our sample being left-handed. Please note there are five parts to this question. 1. Create a pie graph in Excel to show the proportion of...

  • Next. generate a random sample of 280 data points (1-10) Create a pie graph in Excel...

    Next. generate a random sample of 280 data points (1-10) Create a pie graph in Excel to show the proportion of left-handed vs. right handed people are in your sample and save it as an image file Attach the pie graph using the insert image option and note what percentage of your sample was actualily left-handed. Insert. Formats. Blux,x'A.즈.o

  • We will be using Excel to simulate a normal distribution with a mean of 500 and...

    We will be using Excel to simulate a normal distribution with a mean of 500 and a standard deviation of 9. Please note there are five parts to this question. First, generate a random sample of 50 data points. 1. Create a histogram where the first bin starts at 475.25 and the width of each bin is 4.5. You can have your last bin be 520.25. Save that histogram as an image file and attach it here using the Insert...

  • use Excel to simulate a normal distribution with a mean of 700 and a standard deviation...

    use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5. generate a random sample of 150 data points in excel. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. Save that histogram as an image file and attach it here using the Insert Image option.

  • e a sample of 10 data points. Create a histogram where the first bin starts at...

    e a sample of 10 data points. Create a histogram where the first bin starts at 222.5 and the width of each bin is 5, You can have your last bin be 2725. Save that histogram as an image file and attach it here using the Insert Image option f this option doesn't work for adding the images you may have to drag the image directy from your Explorer window into the answer image option. Some students have reported this...

  • Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation...

    Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5. First, generate a random sample of 50 data points. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. Save that histogram as an image file and attach it here.

  • generate a random sample of 130 data points. Create a histogram where the first bin starts...

    generate a random sample of 130 data points. Create a histogram where the first bin starts at 222.5 and the width of each bin is 5. You can have your last bin be 272.5 Save that histogram as an image file and attach it here using the Insert Image option

  • Next, generate a random sample of 300 data points, Createa that histogram as an image file...

    Next, generate a random sample of 300 data points, Createa that histogram as an image file and attach it here using the insert image option where the first bin starts at 222.5 and the width of each bin is S. You can have your last bin be 272.5 Save 스,브

  • It has been claimed that, on average, right-handed people have a left foot that is larger...

    It has been claimed that, on average, right-handed people have a left foot that is larger than the right foot. Here we test this claim on a sample of 10 right-handed adults. The table below gives the left and right foot measurements in millimeters (mm). Test the claim at the 0.05 significance level. You may assume the sample of differences comes from a normally distributed population. Person Left Foot (x) Right Foot (y) 1 272 272 2 269 267 3...

  • Foot-Length: It has been claimed that, on average, right-handed people have a left foot that is...

    Foot-Length: It has been claimed that, on average, right-handed people have a left foot that is larger than the right foot. Here we test this claim on a sample of 10 right-handed adults. The table below gives the left and right foot measurements in millimeters (mm). Test the claim at the 0.01 significance level. You may assume the sample of differences comes from a normally distributed population. Person Left Foot (x) Right Foot (y) difference (d = x − y)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT