See attached datafile.
Please show step-by-step including the formulas used in Excel.
3.11 The file Sedans contains the overall miles per gallon (MPG) of 2009 sedans priced under $20,000.
27 31 30 28 27 24 29 32
32 27 26 26 25 26 25 24
a. Compute the mean, medium, and mode.
b. Compute the variance, standard deviation, range, coeffifient of variation, and Z scores.
c. Are the data skewed? If so, how?
d. Compare the results of (a) through © to those of Problem 3.12(a) through © that refer to the miles per gallons of SUVs priced under $30,000.
3.19 General Electric (GE) is one of the world’s largest companies; it develops, manufactures, and markets a wide range of products, including medical diagnostic imaging devices, jet engines, lighting products, and chemicals. Through its affiliate, NBC Universal, GE produces and delivers network television and motion pictures. In 2007, GE’s stock price rose 2.67%, but in 2008, the price dropped 53.94%.
a. Compute the geometric mean rate of increase for the two-year period 2007-2008. (Hint: Denote an increase of 2.67% as R1 = 0.0267.)
b. If you purchased $1,000 of GE stock at the start of 2007, what was its value at the end of 2008?
c. Compare the results of (b) to that of Problem 3.20(b)
3.31 The file contains the yield for a money market account, a one year certificate of deposit(CD) and a five year CD for 23 banks in the Metropolitan NY area, as of May 28, 2009. For each type of account:
a. Compute the first quartile(Q1,) the third quartile (Q3), and the enter quartile range.
b. List the five number summary.
c. Construct a boxplot and describe it shape.
2.65 College football players trying out for the NFL are given the Wonderlic standardized intelligence test. The file Wonderlic contains the average Wonderlic scores of football players trying out for the NFL and the graduation rate S. Walker, “The NFL’s Smartest Team,” The Wall Street Jaournal, September 30, 2005, pp. W1, W10).
a. Construct a scatter plotwith average Wonderlic score on the X axis and graduation rate on the Y axis.
b. What conclusions can you reach about the relationship between the average Wonderlic score and graduation rate?
The expert examines 2009 Sedans, general electric and money market yields.