business statistics and excel

40_points.docx

Home >Business & Finance homework help >Management homework help >business statistics and excel

(40 Points): From an data source of your choice collect a data set with the following characteristics and save it into an excel spreadsheet. (Data sources you might want to use:

http://www.data.gov/

http://www.census.gov/main/www/access.html

http://www.bls.gov/

http://www.piton.org//index.cfm?fuseaction=Home.Sitemap

http://www.thinkwithgoogle.com/insights/

1. Explain the purpose of your project 2. Data on at least 10 variables with at least 40 rows 3. “Clean” the data set, and identify missing data. Detail how you cleansed the data in your report.

(60 points): Using the data set from part 1 of your project create the following items in Excel and organize them into a Managerial report or presentation (Max: 2 pages).

1. Histograms for data on five variables. Include descriptive statistics with each histogram.

· Remember, the histograms should not show bars

· They should show bars based on bins you find based on the data.

2. Time series charts for variable (If you have a time element with your data set.

· Use the right kind of graph for a time series.

3. Scatterplots that show two variables plotted together and a detailed explanation of the correlation (Plot variable 1 vs variable 2, variable 1 is x, variable 2 is y).

· Include a trend line or curve of best fit (with equation and R2 value) that best fits each plot.

· Include descriptive statistics for each variable.

· Ensure each graphic is self-explanatory (Titles? Labeled axes?)

· Include brief observations for every graph/chart

Deliverables: One Excel file including all your data and analysis. One Word or (power-point) file of 2 pages.