Make frequency distributions for each question. (Remember frequency distributions are frequency tables). Follow the rules for creating a grouped...

Make frequency distributions for each question. (Remember frequency distributions are frequency tables). Follow the rules for creating a grouped frequency distribution. You will have 3 frequency distributions. Place them on your Excel Spreadsheet. Also make a contingency table on the opinion question using the answers and ge

Make graphs for each frequency distribution using Excel graphs. Specifically make a pie chart and Pareto chart for the categorical data set. Make a relative frequency polygon and regular histogram for the continuous data set. Make only a frequency histogram for the discrete data set. 

Find confidence intervals for M using Excel. You found x-bar for each quantitative data set, so find the 92% confidence intervals about the mean. Use the instructions of previous Excel Assignments to find the confidence intervals. You found the percentages of each category choose one category and find the 96% confidence interval for the true proportion (here you can use the calculator and place answer on excel).

Person