In this lab, we used Excel to perform some basic statistical functions with population data like: Standard Statistics, Histograms, and Graphing of statistics. Deliverables include posting one histogram or scatterplot graph created during this lab to the blog.
Student Learning Outcomes:
- Demonstrate the basic concepts of statistical software and analysis.
- Calculate standard statistics such as: mean, median, mode, variance, and standard deviation
- Diagram the distribution and skewness of data utilizing histograms
- Determine linear and polynomial trendlines for data arrays.
STUDENT SPOTLIGHT AWARDS
The following student has been chosen for her exceptional work on the Statistical Foundation assignment:
What we like: We liked that ALL of Ms. Markin's values were correct. The level of detail she exhibited with her graphs and process summary were also superb!
"This is one of the histogram from the Cartography week 2 lab. In this version Excel set the default bin size of 19.25. The results are very similar to the histogram I created with a bin of 20".
"When calculating the polynomial trendlines Excel returned two of the equations with numbers in scientific notation. This caused me some confusion. When I calculated the populations for 2050 the numbers came out strange, one ended up being negative. It turns out that by keeping the scientific notation Excel was rounding the numbers. I changed the formula on the chart to number format to get the correct numbers and used those in my calculations. They returned much more reasonable population estimates".