Homework Questions Statistics in Pivot Tables
Homework Questions Statistics in Pivot Tables
Homework Questions Statistics in Pivot Tables
Group Member: 2
Report Format: MS word/MS PowerPoint (can be converted into PDF if required)
1. The Excel file Freshman College Data shows data for four years at large urban university. Use
Pivot tables to examine differences in high school GPA performance and first year retention
among different colleges at this university. What can you conclude? Please use graphs to
support your conclusions.
Measure of Association
1. The Excel file Beverage Sales lists a sample of week day sales at a convenience store along
with the daily high temperature. Compute the correlation between temperature and sales.
What can you conclude? Please use a scatter diagram to support your conclusions.
Outliers
1. In the Excel file Weddings, find the mean, median and standard deviation of the wedding
costs. What would you tell a newly engaged couple about what cost to expect? Consider the
effect of possible outliers in the data.