Complete Problems 3.3, 3.9, 3.13, 3.25, and 3.41

Complete Problems 3.3, 3.9, 3.13, 3.25, and 3.41 in the textbook.

Submit one Excel file. Put each problem result on a separate sheet in your file.

You are required to show all of your work/formulas to receive credit for the assignments. Failure to show your work/formulas will negatively impact your grade.

3.3) The following set of data is from a sample of n=7:12 7 4 9 0 7 3
a. Compute the mean, median, and mode.
b. Compute the range, variance, standard deviation, and coeffi-cient of variation.
c. Compute the Z scores. Are there any outliers?
d. Describe the shape of the data set.
3.9) The file Sedans contains the overall miles per gallon (MPG) of 2014 midsized sedans:
38 26 30 26 25 27 24 22 27 32 39
26 24 24 23 24 25 31 26 37 22 33

Source: Data extracted from “Which Car Is Right for You,” Consumer Reports, April 2014, pp. 40–41.
a. Compute the mean, median, and mode.
b. Compute the variance, standard deviation, range, coefficient of variation, and Z scores.
c. Are the data skewed? If so, how?
d. Compare the results of (a) through (c) to those of Problem 3.10 (a) through (c) that refer to the miles per gallon of small SUVs.
3.13) Is there a difference in the variation of the yields of differ-ent types of investments? The file CD Rate contains the yields for one-year certificates of deposit (CDs) and five-year CDs for 22 banks in the United States, as of March 12, 2014.

Source: Data extracted from www.Bankrate.com, March 12, 2014.

a. For one-year and five-year CDs, separately compute the vari-ance, standard deviation, range, and coefficient of variation.
b. Based on the results of (a), do one-year CDs or five-year CDs have more variation in the yields offered? Explain.
3.25) The file AccountingPartners contains the number of part-ners in a cohort of rising accounting firms that have been tagged as “firms to watch.” The firms have the following numbers of partners:

17 23 19 23 18 17 23 16 34 10 14 30 14 33 26 17 19 22
20 27 33 25 12 26 13 30 13 13 33 21 17 12 10 14 12

Source: Data extracted from bit.ly/ODuzd3.

a. Compute the first quartile 1Q12, the third quartile 1Q32, and the interquartile range.
b. List the five-number summary.
c. Construct a boxplot and describe its shape.
3.41) Movie companies need to predict the gross receipts of indi-vidual movies once a movie has debuted. The data, shown in the next column and stored in PotterMovies , are the first weekend gross, the U.S. gross, and the worldwide gross (in $ millions) of the eight Harry Potter movies:
a. Compute the covariance between first weekend gross and U.S. gross, first weekend gross and worldwide gross, and U.S. gross and worldwide gross.
b. Compute the coefficient of correlation between first weekend gross and U.S. gross, first weekend gross and worldwide gross, and U.S. gross and worldwide gross.

Title
Sorcerer’s Stone
Chamber of Secrets
Prisoner of Azkaban
Goblet of Fire
Order of Phoenix
Half-Blood Prince
Deathly Hallows Part 1
Deathly Hallows Part 2

Source: Data extracted from www.the-numbers.com/interactive/comp-HarryPotter.php.

c. Which do you think is more valuable in expressing the rela-tionship between first weekend gross, U.S. gross, and world-wide gross—the covariance or the coefficient of correlation? Explain
d. Based on (a) and (b), what conclusions can you reach about the relationship between first weekend gross, U.S. gross, and worldwide gross?