# Excel assignment _Two questions each on should be in separated excel file.

Two questions each on should be in separated excel file.

Q1

Use Excel file of Example 1 and find the result for following statistical terms for the data in columns H, I, K, L and M:

1. Mean, Median, Mode, Midrange, Variance, Standard deviation

2. Give a short description or explanation about each result

Q2

Consider the experiment of drawing two cards without replacement from a deck consisting of only the Ace through 10 of a single suit (e.g. only hearts).

a.Describe the outcomes of this experiment. List the elements of the sample space.

b.Define the event Ai to be the set of outcomes for which the sum of values of the cards is I (with an Ace = 1). List the outcomes associated with Ai for i=3 to 19.

c.What is the probability of obtaining a sum of the two cards equaling from 3 to 19?

d.Now let event B the event “total card value is odd).” Find P(B) and P(Bc)

e.What is the probability that the sum of two cards will be more than 14)

(You can use Excel If you want to use it as a tool to organize your answer sheet.)  