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 Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. All Rights Reserved Terms and Conditions |