Description: Attached are all the information needed to complete the assingment - Please label all graphs and axis

Â

1. [10 points] (a) Use Excel to make a frequency distribution and a bar chart for the Question 2 (Q2), which are the tweens' ratings of the quality of food at the resort, using the data in the file Tween_Survey.xlsx. Attach a copy of the Excel output to this assignment.

2. [20 points] Use the Excel file SAT_Scores.xls in this problem. (a) For the year 2001, make a histogram of the average Math SAT score data using upper class limits (bins) of 500, 525, 550, 575, 600, 625. Attach the histogram to this assignment. (b) How many states had average Math SAT scores of 550 or less? (c) What percent of states had average Math SAT scores 575 and 625? (d) In complete sentence, describe the average Math SAT data.

Subject | Mathematics |

Due By (Pacific Time) | 02/20/2015 8am |

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