1. How do you do summarize the numerical data using descriptive statistics measures, find proportions for categorical variables, examine correlations, and use PivotTables as appropriate to compare average values?
2. 
   
3. Compute confidence intervals for means and proportions, and  Analyze the sampling errors, possibly suggesting larger sample sizes to obtain more precise estimates. All on Excel?

Answer rating: 100% (QA)

Solution Take a look at what I did with one data set in one Pivot Table and The next screenshot shows each column with line items expressed as percentages of the column total I used the Show Values As ... View the full answer