# Project #8934 - STATISTICS EXCEL

To begin, open and save the Spreadsheet Assignment to your computer. Copy the HWAS data (also found in that Data Table folder) into the spreadsheet, preferably in a blank sheet.

The first problem in an exercise in examining and cleaning bad data from a data set. The Bad Data set is in the Bad.Data tab in the spreadsheet. There are hints shown below and in the bad data page on cleaning data.

Hint: Examine the data before you begin your analysis.  Raw data is often "messy."  You may find values that don't make sense or that are obviously entered in the wrong format.  For instance, height data should be in inches, which means that values outside the range 50 to 80 would be very unusual for adults.  If you see the value 5 in the height column, the person probably entered 5 feet.  A few people may have entered height in centimeters.  Sometimes people just make an error, too.  We had someone 222 years old, at one point!  You may use some judgment in "cleaning" the data.  If it is obvious that height was entered in feet, you may convert to inches.  You might just delete the 222 year old's entry since it isn't really possible to identify the error clearly.  Google can help with converting metric measurements.  Try entering "convert 165 cm to inches" in the search box.

For Problems 2 and 3 in the spreadsheet, you will use the clean data which you copied in from the HWAS data table. All questions must be answered using the spreadsheet. Be sure to let the spreadsheet do the math; do not do calculations on your calculator and enter the results into Excel. You may include comments/conclusions on the worksheet. Credit will be given for use of built in spreadsheet tools and for presentation (formatting, etc.) which reinforce the message contained in the numbers.

 Subject Mathematics Due By (Pacific Time) 07/14/2013 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews