1. Use excel file XR02017 (which shows stock portfolios for 80 clients of an investment advisor) in the excel fles folder and create a frequency distribution table (you can choose the bins yourself) and a histogram by using data analysis toolpak or the other software program - 10 pts. (5 for histogram, 5 for freq. dist table)

2. Use excel file XR03068 and plot a scatter diagram showing the relationship between weight and time required to sprint 40 yards. What type of a relationship is this? (Direct or Inverse? POsitive vs Negative? ) How do you know? Calculate the coefficient of correlation by using excel and write it on your graph - 10 pts

3. USe Excel file XR02071 which shows the purchases of an air compressor manufacturer from two different suppliers (MechSup= 1 or 2) and electrical motor components from three different suppliers (ElectSup= 1,2 or 3)Disregard any additional columns in the file.

Construct a cross tabulation table that uses MechSup in the rows and ElectSup in the columns and that only counts the number of parts that fall under each category (not sum) - 5 pts

I WILL SEND YOU THE FILES

Subject | Mathematics |

Due By (Pacific Time) | 09/25/2013 11:00 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.. |