Generating random values based on a predefined probability distribution
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →-Charts need to be APA format
– no plagiarism
-attached are specific instructions ( PLEASE FOLLOW THEM)
– link below helps measuring and identify ( its on directions document as well)
https://mwcc.edu/wp-content/uploads/2020/09/Likert-Scale-Response-Options_MWCC.pdf?fbclid=IwAR2w6mdNXrYNmhLFYIu11CD97yUOUeqWMPrCNf1SxyaNSQItShIBnvmPPdo
Generate Values
| Generating random values based on a predefined probability distribution | |||||||||
| Probability Distribution table | |||||||||
| Random Variable | Probability | Cummulative Probability | |||||||
| 1 | 0.35 | 0.35 | 4 | Random Variable | Frequency | ||||
| 2 | 0.12 | 0.47 | 3 | 1 | 6 | ||||
| 3 | 0.33 | 0.8 | 1 | 2 | 2 | ||||
| 4 | 0.15 | 0.95 | 1 | 3 | 4 | ||||
| 5 | 0.05 | 1 | 4 | 4 | 4 | ||||
| 3 | 5 | 2 | |||||||
| 2 | |||||||||
| 2 | |||||||||
| 4 | |||||||||
| 1 | |||||||||
| 1 | |||||||||
| 3 | |||||||||
| 5 | |||||||||
| 1 | |||||||||
| 3 | |||||||||
| 1 | |||||||||
| 5 | |||||||||
| 4 |
2) Drag fill handle to generate as many values as needed 3) Copy and Paste VALUES in another location to stop the numbers from changing
4) Generate a Frequency Table for use to generate create charts
1) Create probability distirbution table
Binomial
| Question1 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 1 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 1 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 1 | ||||||||||||||||||||
| 1 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 1 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 1 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 1 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 0 | ||||||||||||||||||||
| 1 | ||||||||||||||||||||
| 0 |
For Windows: 1) Select Data menu 2) Data Analysis 3) Random Number Generator
4) Fill in the Random Generator Window
Output
Output relects the response option selected (Either 0 or 1) with 1 being the favorable response to the survey question, for each of the 30 administrations, with the probability of success = .28 and the survey response conditions satisfy the binomial probability usage criteria.
image1.png
,
Project Part 1: Examining Probabilities
Directions: Respond to the prompts below. Follow the ‘Do Not’ and ‘Do’ instructions.
|
DO NOT : · Upload your Excel workbook to Moodle · Copy and paste your dataset into this document · Upload your work as a Word document in Moodle |
DO · Paste or type your responses directly into this document · Save your completed work as a PDF file Get a plagiarism-free answer to this questionSend us your instructions and we’ll match you with the best writer in your subject.
Your pal for every paper is one click awayJoin 12,000+ students getting original, on-time papers with free Turnitin reports. All Rights Reserved Terms and Conditions |