Excel Project

(Datasets can be pulled from https://qwiexplorer.ces.census.gov/static/explore.html#x=0&g=0 ) Project requirements: Utilizing your quantitative reasoning questions and selected dataset, begin the final step of the project by converting your data to a table. Utilize the PowerPivot functionality and conduct the appropriate analysis required to answer your question. Below are sample steps: 1. Analyze your dataset and provide an analysis that provides the mean, mead, mode, and standard deviation for the selected data. 2. Analyze your dataset and provide an analysis that provides charts reflecting trends, and patterns. 3. Analyze your dataset and provide an analysis that provides logical tests - i.e. True/False, Good/Bad, and Applying Codes to data - such as Engineering = 1, Technology = 2. 4. Analyze your dataset and provide an analysis that performs a Lookup function. You should utilize data analyzed from steps 1 - 3. Create appropriate tables and graphs to display the data analysis. I have created the following questions to make it easier for the freelancer 1. Should U.S. expect earnings increase or decrease in the next decade (2017-2027)? 2. What are three top states with highest earnings? 3. What are the three top states with lowest earnings? 4. By what percent the earnings increased or decreased over 10 years? 5. Between 2018 and 2017, who has earned more, a 50 years old manager or 30 years old computer programmer? 6. What education level in Michigan is leading and what percentage does that level compares to the State's earnings? I don't understand PowerPivot and I can't tell you what you need to do about it, you know better :) In the tables please include mean, median, stdev, vlookup, conditional formatting, logical operators if, true/false, MAX, MIN, percentage, line trending, bar chart or column chart