Project #13291 - STATS EXCEL

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
Report DMCA
TutorRating
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..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy