Make the following: a. frequency distribution b. pareto chart c. probability distribution d. pie graph for...

Make the following:

a. frequency distribution

b. pareto chart

c. probability distribution

d. pie graph

for the following set of numbers :

Prophecy - 15 out of 50

Advice - 7 out of 50

Wisdom - 17 out of 50

Compliments - 4 out of 50

Misc. - 7 out of 50

Solutions

Expert Solution

SolutionA:

in excel select the data .

go to insert >pivot chart and pivot table

solutionB

select the data and then go to insert>histogram>paretochart

solutionc:

Solutiond:

milcah answered 9 months ago

Next > < Previous

Related Solutions

Make a Frequency Distribution Chart, Histogram and Box and Whiskers Plot for the following set of...

Make a Frequency Distribution Chart, Histogram and Box and Whiskers Plot for the following set of Data 50, 10, 25, 20, 20, 20, 50,100, 30, 15

Consider the following probability distribution of returns estimated for Projects B, C and D. Construct an...

Consider the following probability distribution of returns estimated for Projects B, C and D. Construct an equal-weighted (50/50) portfolio of Investments B and D. State Probability B C D Very poor 0.1 25% -25% 15% Poor 0.2 15% -5% 10% Average 0.4 10% 15% 0% Good 0.2 0% 35% 25% Very good 0.1 -10% 55% 35% The expected rate of return of the portfolio is 10.25. What is the standard deviation?

Suppose the alphabet is S = {A B C D} and the known probability distribution is...

Suppose the alphabet is S = {A B C D} and the known probability distribution is PA = 0.3, PB = 0.1, PC = 0.5, and PD = 0.1. Decode the Huffman coding result {11000010101110100} to the original string based on the probability distribution mentioned above. The codeword for symbol “D” is {111}. Please writing down all the details of calculation.

Consider the following probability distribution for stocks C and D: State Probability Return on Stock C...

Consider the following probability distribution for stocks C and D: State Probability Return on Stock C Return on Stock D 1 0.30 7 % – 9 % 2 0.50 11 % 14 % 3 0.20 – 16 % 26 % If you invest 25% of your money in C and 75% in D, what would be your portfolio's expected rate of return and standard deviation? Select one: a. 9.891%; 8.70% b. 9.945%; 11.12% c. 8.225%; 8.70% d. 10.275%; 11.12%

Make a Frequency Distribution Chart for the following set of Data 50, 10, 25, 20, 20,...

Make a Frequency Distribution Chart for the following set of Data 50, 10, 25, 20, 20, 20, 50,100, 30, 15

a) Make a frequency distribution table.Make a frequency distribution table with 6 classes on the following...

a) Make a frequency distribution table.Make a frequency distribution table with 6 classes on the following test scores of 25 students in my class. Include the following columns in the table: Classes, Frequency, Class Mark, Class Boundaries, Relative Frequency and Relative % (make sure you find the class width) 45, 67, 87, 96, 76, 56, 45, 56, 67, 77, 88, 92, 34, 37, 46, 86, 90, 96, 49, 50, 60, 70, 85, 70, 99 b) Use the test scores in...

5) CHART - Create a 3-D pie chart showing the breakdown of total Hours Worked into...

5) CHART - Create a 3-D pie chart showing the breakdown of total Hours Worked into total Overtime Hours and the NonOvertime hours located at the bottom of the database listing, row 37 columns E, F, G. The pie chart should show the values, the legend should indicate Overtime Hours and NonOvertime, and the chart title should be Total Daily Hours. Place this chart so that it will fill cells K1:R16. (Hint: When selecting the data for this chart remember...

what are the pros and con of frequency table, bar graph, histogram, pie graph, steam leaf...

what are the pros and con of frequency table, bar graph, histogram, pie graph, steam leaf display, dot plot, pictogram, frequency polygon, box plot, pareto graph

1.Are there circumstances in which a pie chart cannot be drawn, but a bar graph could...

1.Are there circumstances in which a pie chart cannot be drawn, but a bar graph could be drawn? If so, what are these circumstances and give examples. 2. when is a pie chart or bar chart preferred over the other one?

(1) identify the appropriate graph you would use , Bar graph or pie chart ...etc (2)...

(1) identify the appropriate graph you would use , Bar graph or pie chart ...etc (2) state whether the data are qualitative or quantitative (3) If qualitative-identify as ordinal or nominal, if quantitative-identify as ratio or interval NARIOS: a) She wants to understand the distribution of the current stock price to earnings ratio for the companies in the Sow BOB Industrial Average. b) Jessica wants to investigate the distribution of the heights of the 50 students currently taking mgmt 215...

Subjects