Question

In: Statistics and Probability

PLEASE PROVIDE A SPREADSHEET FOR EACH PART FOR PERSONAL REFERENCE Part 1: Using Excel’s Randbetween(0,9) function,...

PLEASE PROVIDE A SPREADSHEET FOR EACH PART FOR PERSONAL REFERENCE

Part 1:

Using Excel’s Randbetween(0,9) function, generate 200 samples of five random numbers between 0 and 9, calculate the mean of each sample. Show me the list of the 200 means. Typically, they should look like: 4.8, 3.6, 4.4, 6.0, etc.

Part 2:

Using Excel, calculate the overall mean of the 200 sample means (the average of the averages). This should be around 4.5.

Part 3:  

Using Excel, calculate the standard error of the mean (SEM) (i.e. the standard deviation of the 200 sample means). We established in the previous simulation that the population average is 4.5 and the standard deviation of the population is 2.87.

Since the SEM= σ= σ/√n. The SEM therefore is 1.28. Thus, the standard deviation of the 200 sample means should be approximately 1.28.

Part 4:

Using Excel, make the histogram of the 200 sample means (sampling distribution of the mean) (use interval size 1, i.e., 0-1, 1-2, 2-3, …8-9). According to the Central Limit Theorem a bell shaped curve should appear. Show me this graph.

Part 5:

Discuss the intuitive logic of the Central Limit Theorem. Discuss the implications of part 4 in this context. (My videos might help here.)

Solutions

Expert Solution

First 20 samples of the total 200 samples generated:

Mean=4.457, SD=1.282


Related Solutions

Part 1: Using Excel’s Randbetween(0,9) function, generate 200 samples of five random numbers between 0 and...
Part 1: Using Excel’s Randbetween(0,9) function, generate 200 samples of five random numbers between 0 and 9, calculate the mean of each sample. Show me the list of the 200 means. Typically, they should look like: 4.8, 3.6, 4.4, 6.0, etc. Part 2: Using Excel, calculate the overall mean of the 200 sample means (the average of the averages). This should be around 4.5. Part 3:    Using Excel, calculate the standard error of the mean (SEM)  (i.e. the standard deviation of...
This is a two-part homework question. Please provide at least one reference between 2013-2018 to support...
This is a two-part homework question. Please provide at least one reference between 2013-2018 to support your response. Thank you. Explain underpricing and some possible reasons for its use. Additionally, assess the implications of stock underpricing on an organization’s IPO.
Part 2: Problem Solving - Journal Using the data in the Option 1 Spreadsheet (linked at...
Part 2: Problem Solving - Journal Using the data in the Option 1 Spreadsheet (linked at the bottom of the page), perform the accounting required for the acquisition of Little, Inc. by Big, Inc. Within the worksheet, you are to: Select an accounting method (either cost or equity) and explain why you selected this method Perform the required journal entries Complete the consolidation worksheet Prepare the consolidated balance sheet in good form Complete all work on the spreadsheet attached to...
Three studies done on obesity please provide reference
Three studies done on obesity please provide reference
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$  26,500 Units started during April ......................................................................................................................................100,000 Units...
Explain the difference in retrospective and prospective studies. Please provide a reference.​
Explain the difference in retrospective and prospective studies. Please provide a reference.​
Part #1 Benzodiazepines (BZDs) are used to treat several disorders. Please refer to an additional reference...
Part #1 Benzodiazepines (BZDs) are used to treat several disorders. Please refer to an additional reference (other than your text) and explain how BZDs are used in the management of each of the following disorders and appropriate patient teaching (in a paragraph in your own words) as your FIRST name indicates: T Please respond to one of the other groups. Remember to enrich the post with additional information. Anesthesia Please refer to a reference (other than your text) and answer...
Part #1 Benzodiazepines (BZDs) are used to treat several disorders. Please refer to an additional reference...
Part #1 Benzodiazepines (BZDs) are used to treat several disorders. Please refer to an additional reference (other than your text) and explain how BZDs are used in the management of each of the following disorders and appropriate patient teaching (in a paragraph in your own words) as your FIRST name indicates: Please respond to one of the other groups. Remember to enrich the post with additional information. First Names A - F    Anxiety First Names G - O   Seizures First...
1. Provide an example of an inertial frame of reference and a non-inertial frame of reference....
1. Provide an example of an inertial frame of reference and a non-inertial frame of reference. Explain the difference. 2. Using the Michelson-Morley experiment as an example, explain why classical mechanics was unable to explain natural phenomena. 3. Using at least one of Einstein's "thought-experiments", explain how special relativity addresses how it is possible for observers in two different inertial reference frames to “disagree” about time and distance intervals. 4. Describe how special relativity explains the conditions under which classical...
1. Provide an example of an inertial frame of reference and a non-inertial frame of reference....
1. Provide an example of an inertial frame of reference and a non-inertial frame of reference. Explain the difference. 2. Using the Michelson-Morley experiment as an example, explain why classical mechanics was unable to explain natural phenomena. 3. Using at least one of Einstein's "thought-experiments", explain how special relativity addresses how it is possible for observers in two different inertial reference frames to “disagree” about time and distance intervals. 4. Describe how special relativity explains the conditions under which classical...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT