Show your work!

If unable to show work on excel, copy and paste work into a table

1. Given the following set of data (it is a population):

14, 22, 12, 19, 99, 12, 27, 16, 26, 19, 12, 39, 44, 12, 18, 28, 12, 27, 15, 16

Write out the excel formula for a. through h. Provide detailed explanations for i. through l:

a. Mean

b. Median

c. Mode

d. Range

e. Variance of the population

f. Standard deviation of the population

g. The 30^thpercentile

h. The IQR (interquartile range)

i. Discuss whether or not an outlier exists in the data. Support your answer with mathematical evidence.

j. The probability of drawing a number higher than 15 if one number was drawn at random from the list

k. The probability of drawing a number higher than 15, not putting it back, and then drawing a second number higher than 15 from the list

l. The probability of drawing a number higher than 15 GIVEN THAT an even number was drawn.

For the following question If unable to show work on excel, copy and paste work into a table

2. Explain the step-by-step process of how to generate and insert a scatter diagram with a trendline in EXCEL for the following data set:

Book	Pages (x variable)	Price (y variable)
A	237	$7.00
B	410	$8.25
C	255	$7.49
D	321	$7.99
E	222	$7.25
F	233	$7.35
G	186	$5.55
H	508	$9.99

Then provide detailed explanations for each of the following questions:

a. Show the equation of the trendline on the scatter diagram along with the coefficient of correlation (r squared).

b. Using Pearson's Product Moment Correlation Coefficient, discuss the strength (strong, weak...) and type (positive, negative) of the relationship between pages and price. Make sure you have stated the value of r.

c. According to the trendline, how much should a book that has 560 pages cost?

d. According to the trendline, how many pages should a book that cost 9 dollars have?

e. Discuss how confident you are in the answers to c and d, and use statistical concepts learned in this class to justify your answer.

3. Conduct a full hypothesis test using the p value method for the scenario below. Make sure all the steps are there and are explained in detail:

"A sample of 349 account balances of a credit company showed a mean customer balance of $7,082, but the marketing manager claimed that the mean balance for the population was $7,229. The marketing manager said the population standard deviation was $162. Use the p-value approach to conduct a full hypothesis test (all steps) that can be used to determine whether the mean of all account balances is significantly different from $7,229. Let= .05."

4. Weekly demand at a grocery store for a brand of breakfast cereal is normally distributed with a mean of 893 boxes and standard deviation of 18 boxes.

Sketch and insert the z graph with appropriate labels and shading and then determine the probability that the weekly demand of the following 3 questions:

a. 900 boxes or less.

b. More than 880 boxes.

c. Between 860 and 915 boxes.

5. In order to determine the average weight of carry-on luggage by passengers in airplanes, a sample of 152 pieces of carry-on luggage was collected and weighed. The average weight was 37.9 pounds. Assume that we know the standard deviation of the population to be 9 pounds. Determine a 90% confidence interval estimate for the mean weight of the carry-on luggage.