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 A_i 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 A_i 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(B_c)

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.)