Morgan State University Basic Statistical Parameters Worksheet

• Use the data to Excel, generate graphs, calculate basic statistical parameters (average, max, min, max of maxs, min of mins, average of maxs, average of mins, total count, etc.), add regression and r² information to your graphs.
• Make sure the statistical analyses are down properly and provided in the report.
• Create one graph for max. temp and one for min. temp for all of the data
• Create one graph for every months i.e., all January months on one graph, all February months one another graph, etc.
• At the end you should have total of 15 graphs, 1 per each month of the report period, 1 for all of the data and twelve monthly base graphs (beginning of the January of the first year to the end of the December of the last year), 1 histogram for the monthly maximums and 1 histogram for the monthly minimums.
• Make sure your graphs are presentable. Format them in a way that you can present them

(The attached document named “Example Semester Project 2-For Sharing-1” gives an example of the statistical analyses)