Project 1 is due at the beginning of class. Use the “Project 1 data” data set. You may use Excel to help you with the statistical analysis. The dataset records the median household income by state (including DC) for the year 2014.
data mining
Description
Project 1 is due at the beginning of class. Use the “Project 1 data” data set. You may use Excel to help you with the statistical analysis. The dataset records the median household income by state (including DC) for the year 2014. Create a report describing the data and answering the required questions. The report will be structured as follows: Section 1 Data. Provide the following information: Mean Median Standard Deviation Largest value Smallest value First Quartile Third Quartile Interquartile range Number of classes for frequency distribution Class width for frequency distribution Frequency Distribution table Histogram of the frequency distribution Section 2 Report. A written report as follows: First paragraph: written summary description of the data which should include key characteristics including observations about the shape of the data. If you had to make any assumptions or decisions to perform your analysis, document and explain them. Second paragraph: Using the data and analysis above, select an income to be used in calculations as U.S. household income. Explain why you chose the number you chose. Describe two limitations of the use of a single number to represent U.S. household income. Generally, the report will be graded for clarity (how easy it is to understand you), completeness (no significant gaps in the information provided) and correctness (the values and descriptions are correct). The report will also be graded on adherence to the reporting standard.
