• Raw data has been imported an Excel spreadsheet (included). Analyse the data, showing what you feel are important aspects of each data set. The finished product will include the converted data's Excel spreadsheet (with formulas) as well as a brief explanation that notes strong and weak points.

• Include graphs explaining your findings.

• The Shortwave Radio dataset lends itself more to functions like "count", etc. The radio dataset can/should be converted to numerics for several questions; i.e. if there are three possible answers to a question, they can be converted into 1,2,3 for numeric usages. Use the statistical tools in Excel ranging from summations to averages to min/max levels. We can also use varied statistical tools inherent to Excel. These are under the "data" tab and are listed under "data analysis"; however these are for numeric data. Please don’t use extremely complicated formulas as this is an introductory class.

• So, we need to convert many of the columns into numbers; or at least get counts of the varied data items in each column. If we know how many of each of the data points are for each column, then we have moved that columns’ text data to a numeric one!

Consider putting the "transformed" data on another sheet for easier review and decision making.

Price: $4.91

Solution: The downloadable solution consists of 3 pages, 191 words and 2 charts.
Deliverable: Word Document