# excel 4 questions w/ document

5.1. Lauren drinks a variety of soft drinks. Over the past month, she has had 15 diet colas, 4 cans of lemonade, and 6 cans of root beer in no particular order or pattern.Given this history, what is the probability that her next drink will be a diet cola? Lemonade? Root beer?What definition of probability did you use to answer this question?5.3 Three coins are dropped on a table.List all possible outcomes in the sample space.Find the probability associated with each outcome.5.8 Students in the new MBA class at a state university has the following specialization profile:Finance67Marketing45Operations and Supply Chain Management51Information Systems18Find the probability that a student is either a finance or marketing major. Are the events finance specialization and marketing specialization mutually exclusive? If so, what assumption must be made?5.11 Row 26 of the Excel file Census Education Data gives the number of employed persons having a specific educational level.Find the probability that an employed person has attained each of the educational levels listed in the data.Suppose that A is the event has at least an Associates Degree and B is the event is at least a high school graduate. Find the probabilities of these events. Are they mutually exclusive? Why or why not? Find the probability P(A or B).
week_five_suppliment.xlsx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
excel 4 questions w/ document
Just from \$13/Page

Soft Drinks
diet colas
cans of root beer
TOTAL
(a)
diet colas
cans of root beer
(b)
Coins
Outcome
1
2
3
4
5
6
7
8
Sample Space
Probability
MBA Students
Finance
Marketing
Operations and Supply Chain
Information Systems
Total
P(finance or marketing)
Census Education Data
Not a High
Associate’
School
High School Some College
s
No Degree
Degree
Total Persons
Age
29,620,292 12,915,825
Bachelor’s
Degree
29,620,292
58,207,318
28,242,604
25-34
35-44
45-54
55-64
65-74
75 and older
4,683,126
5,335,440
4,427,540
4,562,275
5,165,297
5,399,420
12,553,926
15,117,080
10,932,618
8,301,115
6,505,772
4,717,388
7,792,092
8,136,546
6,062,324
3,338,250
2,466,474
1,847,170
3,423,798
4,134,966
2,894,930
1,157,260
768,539
454,688
8,382,402
8,136,546
5,960,150
2,893,150
1,787,300
1,150,929
Male
Female
14,168,672
15,361,785
26,607,448
31,621,920
14,086,296
15,541,455
5,683,944
7,186,800
14,086,296
14,193,930
White
Black
Other
23,647,714
4,650,240
1,279,740
49,181,442
6,975,360
1,977,780
24,953,416 11,171,006
3,700,816 1,201,312
1,047,060
550,676
24,373,104
1,995,728
1,915,732
4,120,320
15,516,160
1,847,880
1,188,090
5,145,683
2,968,680
7,777,104
36,382,720
2,368,024
1,667,010
4,670,488
7,003,040
4,789,872
18,084,352
1,184,012
842,715
1,765,010
3,806,000
1,828,392
8,346,624
465,392
336,165
556,657
1,674,640
5,124,648
19,154,432
670,712
405,240
977,544
2,340,690
11,668,755
1,057,310
16,858,244
36,228,706
1,783,636
20,040,098
20,448,104
809,072
8,205,834
9,890,659
317,193
2,623,634
22,115,069
455,103
5,582,200
Gender
Race
Marital Status
Never Married
Married, spouse present
Married, spouse absent
Separated
Widowed
Divorced
Civilian Labor Force
Employed
Unemployed
Not in Labor Force
PROBABILITIES
Degree
Not a High High School
13,604,669
a)
2,439,948
3,556,960
3,848,554
2,047,460
1,179,618
625,196
b)
7,743,344
5,929,110
11,751,318
852,544
992,768
2,137,416
9,523,712
301,136
165,780
475,195
1,217,920
10,890,838
170,089
2,511,990
Some
College
No Degree
Associate’s
Degree
TIES
Bachelor’s
Degree
Degree

attachment

Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

### Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors: