18 Jan Generating random values based on a predefined probability distribution
-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 
Related TagsAcademic APA Assignment Business Capstone College Conclusion Course Day Discussion Double Spaced Essay English Finance General Graduate History Information Justify Literature Management Market Masters Math Minimum MLA Nursing Organizational Outline Pages Paper Presentation Questions Questionnaire Reference Response Response School Subject Slides Sources Student Support Times New Roman Title Topics Word Write Writing |