Question

Done 412+-+HW+1 (2 of 2) 2. Collect your data from three coins of your choice, and show that all are approximately fair via simple graphs. 3. Use the above coins to simulate a random sample of size 50 (e.g., BHHHFB..) for the population described in Problem 1, and a. b. c. d. Sketch your data collection method, and provide justifications; Document the data via an Excel file; Provide point estimates from the simulated data for all three parameters; Compare and comment.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

The coin toss for the 3 coins are simulated as given below in the excel.

0011100100110000110 1110100001110000101 0 1 2 3 4 5 6 7 8 9 0 1 2 34 5 6789

The formula to create this is given below

1 Coin 1 Coin L Coin 3 IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) 3 IF(RANDBETWEEN(1,100)>49,1,0) IF(RANDBETWEEN(1,100) 49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100)>49,1,0) 5 =IF(RANDBETWEEN(1,100):49,1,0) -IF(RANDBETWEEN(1,100549,1,0) -IF(RANDBETWEEN(1,100)>49,1,0) 6 HIF(RANDBETWEEN(1,100)>49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) 7 =IF(RANDBETWEEN(1,100)>49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) 8 EIF(RANDBETWEEN(1,100)>49,1,0) EIF(RANDBETWEEN(1,100) 49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) 9 =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) 10-IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100)>49,1,0) 11=IF(RANDBETWEEN(1,100)>49,1,0) -r(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100)>49,1,0) 12:IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) -IF(RANDBETWEEN(1,100)>49,1,0) 13 IF(RANDBETWEEN(1,100)>49,1,0) EIF(RANDBETWEEN(1,100)>49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) 14 =IF(RANDBETWEEN( 1,100)>49,1,0) -IF(RANDBETWEEN(1,100):49,1,0) :IF(RANDBETWEEN(1,100)>49,1,0) 15 EF(RANDBETWEEN(1,100)>49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) 16 =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100)>49,1,0) 17 =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) =IF(RANDBETWEEN(1,100)>49,1,0) 18 F(RANDBETWEEN(1,100)>49,1,0) IF(RANDBETWEEN(1,100) 49,1,0) IF(RANDBETWEEN(1,100)>49,1,0) 19 =IF(RANDBETWEEN(1,100)>49,1,0) =IF(RANDBETWEEN(1,100)>49,1,0) =IF(RANDBETWEEN(1,100)>49,1,0) 201=IF(RANDBETWEEN(1,100)>49,1,0) =IF(RANDBETWEEN(1,100):49,1,0) =FIRANDBETWEEN(1,100)>49,1,0) 21

Distribution of head and tail

Head(1)Tail (0) 9 10 Coin 1 Coin 2 Coin 3

Head(1) COUNTIF(SA$2:SA$20,1) COUNTIF(ŞA$2:SA$20,0) =COUNTIF($BS2SB$20,1) =COUNTIE(SB$2:$BS20,0) -COUNTIF(SB$2:$B$20,1)COUNTIF($B$2:$B$20,0) Tail (0) Coin 1 Coin 2 Coin 3

Coin 1 Coin 3 Coin 3 Head(1) 47% Tail (0) 42% Tail (0) 42% Tail (0) 53% Head(1) Head(1) 58% 58

Add a comment
Know the answer?
Add Answer to:
Done 412+-+HW+1 (2 of 2) 2. Collect your data from three coins of your choice, and...
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
  • 2. Collect your data from three coins of your choice, and show that all are approximately...

    2. Collect your data from three coins of your choice, and show that all are approximately fair via simple graphs. population described in Problem 1, and a. b. Sketch your data collection method, and provide justifications; Document the data via an Excel file; or ll lre r d. Compare and comment. 4. (Bonus -25 points) Repeat Problem 3 with a real data set collected by you from a population of your choice.

  • 1. Submit your el 2. The assignment can be done individually or in small groups (2-3...

    1. Submit your el 2. The assignment can be done individually or in small groups (2-3 students). 3. The names o assignment electronically through iLearn by the due date: Friday, August 3. fall members of a group must be clearly stated in the work submitted for grading. Only one submission per group, please! 4. The answers to quest tions 1 11 below, including the graphs, must be clearly stated in a single word or pdffile separate from your code or...

  • (1) Using your textbook, name three different methods for collecting kinematic data. Complete the table below:...

    (1) Using your textbook, name three different methods for collecting kinematic data. Complete the table below: Data Collection Method How the method Advantage of works Disadvantage of method method 3 (2) For the graphs of (i) plantar flex/ext, (ii) knee flex/ext, (iii hip flex/ext, and (iv) hip ab/adduction below, provide the following information: 30 Dors a. Describe the motion of the segment. b. When during the gait cycle is it happening? (At what stages of the cycle?) 70 c. Why...

  • 1 2. O 3/9 points Previous Answers lowskylntroStat1 8.HW.121. Ask Your Teacher 10 My Notes blacks...

    1 2. O 3/9 points Previous Answers lowskylntroStat1 8.HW.121. Ask Your Teacher 10 My Notes blacks newspaper. Of the 1,709 randomly selected adults, 315 identified themselves as Latinos, 323 identified themselves article regarding interracial dating and marriage recently appeared in 254 identified themselves as Asians, and 779 identified themselves as whites. Among Asians, 79% would welcome a white person into their families, 71% would welcome a Latino, and 66% would welcome a black person. normally distributed. (In general, you must...

  • I need someone to help answer table 1 only mass, volume, y density and table 2...

    I need someone to help answer table 1 only mass, volume, y density and table 2 with a graph each table. please read the procesures, thank you Experiment 2 Graphing and Measurements Graphs summarize numerical data efficiently and are usually casier to understand and interpret than columns of numbers. In this experiment, you will collect data and construct a graph that makes an effective visual presentation. Materials: Equipment metric ruler Chemical a kit with 5 pieces Procedure: Part I: Measurements...

  • Impulse and Momentum Name: Date: TA's Name: Learning Objectives: 1. Understanding force ys time curves for...

    Impulse and Momentum Name: Date: TA's Name: Learning Objectives: 1. Understanding force ys time curves for a collision. 2. Calculating impulse using force vs. time curves. 3. Understanding the relationship between impulse and momentum. 4. Applying conservation of momentum for inelastic collisions. Apparatus: Aluminum track, track legs, two smart carts, two cart stops, and small black rectangular cart masses. Part A: Collision of a moving cart with a fixed cart cart 1 Cart stop stationary cart cart stop Consider the...

  • Here is the data analysis project, please I need an excellent project, it is due 4 hours! Statist...

    here is the data analysis project, please I need an excellent project, it is due 4 hours! Statistics course. GENERAL DESCRIPTION For the data analysis project, you address some questions that interest you with the statistical methodology we learn in MAT 235.   You choose the question; you decide how to collect data; you do the analyses. The questions can address almost any topic (although I have veto power), including topics in economics, psychology, sociology, natural science, medicine, public policy, sports,...

  • gretl: model 1 File Edit Tests Save Graphs Analysis LaTeX Question 5 In your first year...

    gretl: model 1 File Edit Tests Save Graphs Analysis LaTeX Question 5 In your first year microeconomics course you learned about differentiated products. As an econometrics student differentiated products are interesting because they are prime candidates for hedonic price modelling. As mentioned in class, a hedonic price model is a regression model that relates the price of a differentiated product (a residential house in this case) to its characteristics. For this assignment you will construct a simple hedonic model for...

  • Experiment Sd 2. Use the data in Table 1 to calculate the percent change in amplitude...

    Experiment Sd 2. Use the data in Table 1 to calculate the percent change in amplitude (Am ) activity that occurs between the 0-20 sand 60-80 intervals. Do the same for What accounts for the difference in the percent change observed in grip streng the two time intervals? change in amplitude (AmV) in electrical intervals. Do the same for grip strength. age observed in grip strength and Am V for 3. Compare mean grip strengths and Am V for the...

  • A priority queue is a collection of items each having a priority. A priority queue supports three...

    A priority queue is a collection of items each having a priority. A priority queue supports three fundamental operations. You can ask a priority queue whether it is empty. You can insert an item into the priority queue with a given priority. You can remove the item from the priority queue that has the smallest priority. For example, suppose that you start with an empty priority queue and imagine performing the following steps. Insert item "one" with priority 10. Insert...

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
Active Questions
ADVERTISEMENT