Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

Edit the given Python Code (about Probability) so it can also output a Bar Graph. Please see the attached pics to complete it. 
Code that Needs to be Edited:

from collections import Counter
from scipy.stats import binom

# Part A: Find the 7 most common repetitive numbers
number_list = [25, 23, 17, 25, 48, 34, 29, 34, 38, 42, 30, 50, 58, 36, 39, 28, 27, 35, 30, 34, 46, 46, 39, 51, 46, 75,
               66, 20, 45, 28, 35, 41, 43, 56, 37, 38, 50, 52, 33, 44, 37, 72, 47, 20, 80, 52, 38, 44, 39, 49, 50, 56, 
               62, 42, 54, 59, 35, 35, 32, 31, 37, 43, 48, 47, 38, 71, 56, 53, 51, 25, 36, 54, 47, 71, 53, 59, 41, 42, 
               57, 50, 38, 31, 27, 33, 26, 40, 42, 31, 25, 26, 47, 26, 37, 42, 15, 60, 40, 43, 48, 30, 25, 52, 28, 41,
               40, 34, 28, 40, 38, 40, 30, 35, 27, 27, 32, 44, 31, 32, 29, 31, 25, 21, 23, 25, 39, 33, 21, 36, 21, 14, 
               23, 33, 27, 31, 16, 23, 21, 13, 20, 40, 13, 27, 33, 34, 31, 13, 40, 58, 24, 24, 17, 18, 18, 21, 18, 16, 
               24, 15, 18, 33, 21, 13, 24, 21, 29, 31, 26, 18, 23, 22, 21, 32, 33, 24, 30, 30, 21, 23, 29, 23, 25, 18, 
               10, 20, 13, 18, 28, 12, 17, 18, 20, 15, 16, 16, 25, 21, 18, 26, 17, 22, 16, 15, 15, 25, 14, 18, 19, 16,
               14, 20, 28, 13, 28, 39, 40, 29, 25, 27, 26, 18, 17, 20, 25, 25, 22, 19, 14, 21, 22, 18, 10, 29, 24, 21,
               21, 13, 15, 25, 20, 29, 22, 11, 14, 17, 17, 13, 21, 11, 19, 17, 18, 20, 8, 21, 18, 24, 21, 15, 27, 21]

number_count = Counter(number_list)

most_common = number_count.most_common(7)

print("Most Common Numbers in New Testament:")
for num, count in most_common:
    print(f"Number {num} appears {count} times")

# Part B: Find the 7 most uncommon numbers
least_common = number_count.most_common()[:-8:-1]
print("\nLeast Common Numbers in New Testament:")
for num, count in least_common:
    print(f"Number {num} appears {count} times")

# Part C: Use binomial distribution to find the probability of each of the 7 common repetitive numbers
print("\nProbabilities of 7 Most Common Numbers (Using Binomial Distribution):")
for num, count in most_common:
    total_trials = len(number_list)
    successes = count
    probability = binom.pmf(successes, total_trials, successes/total_trials)
    print(f"Probability of seeing {num} appear exactly {count} times: {probability:.4f}")
    
print("\nProbabilities of 7 Most Common Numbers from the New Testament Winning the Powerball:")
    
# The provided "how often" data from the table
how_often_data = {
    1: 4, 2: 4, 3: 3, 4: 7, 5: 8, 6: 4, 7: 3, 8: 4, 9: 6, 10: 3,
    11: 2, 12: 3, 13: 3, 14: 5, 15: 2, 16: 5, 17: 2, 18: 4, 19: 3,
    20: 4, 21: 8, 22: 1, 23: 5, 24: 1, 25: 2, 26: 4
}

# The total count of all occurrences
total_count = sum(how_often_data.values())

# The specific numbers we need to find the probabilities for
requested_numbers = [17, 18, 20, 21, 25, 27, 31]

# Calculate the probabilities
probabilities = {number: how_often_data.get(number, 0) / total_count for number in requested_numbers}

def print_probability(number, probability):
    if number in how_often_data:
        print(f"Probability of Number {number} being a winning number for Powerball: {probability:.4f}")
    else:
        print(f"Probability of Number {number} being a winning number is 0 because it is not a Powerball number.")

for number in requested_numbers:
    print_probability(number, probabilities[number])

 

Question - Based on given Python Code so it can do the Following Task (Will
Probably have to use Matplotlib):
a. Utilizing the code and the output it provides. Create two bar graphs. One
should compare the total numbers within number_list with the frequency of
those individual Numbers. The second graph should compare the Powerball
Numbers (1-26) with the probability of them winning.
** An example of how the bar graphs should look is shown in the other
attached picture (Note that "Number Frequency in the Bible" is referencing
the number list in number_lists
expand button
Transcribed Image Text:Question - Based on given Python Code so it can do the Following Task (Will Probably have to use Matplotlib): a. Utilizing the code and the output it provides. Create two bar graphs. One should compare the total numbers within number_list with the frequency of those individual Numbers. The second graph should compare the Powerball Numbers (1-26) with the probability of them winning. ** An example of how the bar graphs should look is shown in the other attached picture (Note that "Number Frequency in the Bible" is referencing the number list in number_lists
Frequency
16
14
14
12
10
4
2
22
17
77
14
6
3
Number Frequency in the Bible
8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
Numbers
0.37 0.37
0.36
0.35
0.30
0.25
0.20
0.15
0.10
0.05
0.3
0.3
0.37
0.37
0.36
0.33
Winning Powerball Numbers
0.37
0.37
0.37
0.36 0.36 0.36
0.36
0.36 0.36
0.33
0.31
0.31
0.31
0.26
0.2
0.2
0.37
0.00
1
2
3
4
5
6
8
9
10 11 12
13
14 15 16 17 18
19
20
21
22
23
24
25
26
Numbers
expand button
Transcribed Image Text:Frequency 16 14 14 12 10 4 2 22 17 77 14 6 3 Number Frequency in the Bible 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 Numbers 0.37 0.37 0.36 0.35 0.30 0.25 0.20 0.15 0.10 0.05 0.3 0.3 0.37 0.37 0.36 0.33 Winning Powerball Numbers 0.37 0.37 0.37 0.36 0.36 0.36 0.36 0.36 0.36 0.33 0.31 0.31 0.31 0.26 0.2 0.2 0.37 0.00 1 2 3 4 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Numbers
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education