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

  1. 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

please show the work on excel I need help with questions #1,2please 1,2 thank youMake 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

\f\f\f\f

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!