1. Given below are the ages of the United States presidents when they were inaugurated.

57 61 57 57 58 57 61 54 68 51 49 64 50 48 65 52 56 46 54 49 51

47 55 55 54 42 51 56 55 51 54 51 60 62 43 55 56 61 52 69 64 46

54 47

a).Using this data construct a frequency table with 6 classes.

b). Using the information in the frequency table construct a histogram.

(Use EXCEL)

c). Why is a histogram appropriate in this case.

Bonus: Who was the youngest President to be inaugurated? the oldest?

2. Use EXCEL or a TI calculator to simulate the rolling of an honest die 96

times. Record the result on each roll of the die. Present the results of this experiment using a frequency bar graph. If you decided to construct the resultant bar graph on a theoretical basis rather than the empirical results of the experiment, what type of distribution would you expect?

3. The information presented in the following table compares the average price of gold in US dollars to the United States Nation Debt in billions of dollars for the past decade. (Use EXCEL)

Year |
Average Price of an ounce of Gold in US Dollars |
United States Nation Debt in Billions of Dollars |

2002 |
$ 343 |
$ 6,228 |

2003 |
$ 417 |
$ 6,783 |

2004 |
$ 436 |
$ 7,379 |

2005 |
$ 513 |
$ 7,933 |

2006 |
$ 636 |
$ 8,507 |

2007 |
$ 837 |
$ 9,008 |

2008 |
$ 870 |
$ 10,025 |

2009 |
$ 1,088 |
$ 11,910 |

2010 |
$ 1,420 |
$ 13,562 |

2011 |
$ 1,531 |
$ 14,790 |

2012 |
$ 1,664 |
$ 16,066 |

a). Prepare a scatter plot for the data presented in the table. In preparing the scatter plot make certain the each axis is appropriately titled. The National Debt values should be on the x-axis and the price of gold on the y-axis. The dates are for clarity do not include them on the scatter plot.

b). Does the scatter plot indicate that a linear correlation exists between the average price of an ounce of gold and the United States National Debt? If you answered yes is the linear correlation positive or negative. Is the linear correlation weak, moderate or strong?

c). Display the trend line on the graph. Use the equation of the trend line to predict the average price of gold in 2013 if the United States National Debt were to rise to 20 trillion dollars as forecasted in 2013.

d). Display the value to find the correlation coefficient. What is the correlation coefficient and does it support the conclusions you made in part 4b.

4. Consider the following data from the automobile industry. All cars produced on a particular day were inspected for defects. The 145 defects found were categorized into 5 categories as follows:

Body |
70 |

Accessories |
50 |

Electrical |
10 |

Transmission |
10 |

Engine |
5 |

Construct a Pareto bar chart for the data. Why would a Pareto Chart be appropriate here.

5. In the table below, *The National Education Association Almanac for Higher Education *gives the following average distribution of professional time allocations for college professors.

Activity |
% of time devoted to activity |

Teaching |
51% |

Research |
16% |

Professional Growth |
5% |

Community Service |
11% |

Service to the College |
11% |

Outside Consulting |
6% |

Prepare a pie chart for the data above. Why is a pie chart appropriate?

Subject | Mathematics |

Due By (Pacific Time) | 04/27/2014 11:30 pm |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |