Question: please show the work on excel I need help with questions #1,2 please 1,2 thank you Make graphs for each frequency distribution using Excel graphs.
please show the work on excel
I need help with questions #1,2 please 1,2 thank you
- Make graphs for each frequency distribution using Excel graphs. Specifically
a.) Make a pie chart on the categorical data set
b.) Make pareto chart for the categorical data set.
c.) Make a frequency histogram for the continuous frequency distribution
d.) Make a relative frequency polygon for the continuous frequency distribution.
e.) Make only a frequency histogram for the discrete frequency distribution.
NOTE: There is no graph for the contingency table.
2.Find confidence intervals for using Excel.
a.) find the 98% confidence interval about the discrete mean.
b.) find the 98% confidence interval about the continuous mean.
c.) find the 98% confidence interval about the discrete standard deviation.
d.) find the 98% confidence interval about the continuous standard deviation.
this is the data for both questions use please




\f\f\f\f
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
