I have already sent this, and after an hour of waiting, I still have yet to rece

Question

I have already sent this, and after an hour of waiting, I still have yet to receive a response.   Can someone please assist me in setting this up in excel?

100 tiand 200 times So youw wwrsets Yo et the dsa you do not have to roll adie, e EXCEL with the command number between 1 and EXCE to do this parr ALSe For each data set 1 Prepare a frequency distribution table. (Ch 2) Calculate relative frequency and percentage. (Ch 2) 3. Draw a bar graph for the frequency distribution (Ch 2) Drawa pie chart for the percentage distribution. (Ch 2) 5 Calculate cumulative frequency, cumulative relative frequency and cumulative percentage. 6 Calculate sample mean, mode, sample variance and sample standard deviation. (Ch 3) 7 Calculate the three Quartiles and IQR. (Ch 3) 8 Prepare a Box-and Whisker plot. (Ch 3) 9. Calculate P(I), P(2), P(3), P(4), P(5) and P(6) using relative frequencies. (Ch 4) 10. When you roll a die, if Event A is getting an Even number and Event 8 is getting an Odd number, find P(A) and P(B) using relative frequencies. Compare these probabilities with classical probability. (Ch 4) Partsi sopoints lh daa't have te yse EXCEL. But everything needs to be typed in a word

Explanation / Answer

As the data is not known only steps can be given .

1. frequency distribution table

2. relative frequency :

type = current frequency /total number of frequency

percentage:

type = current relative frequency * 100

3. Bar graph:

5. Cumulative frequency:

first you have to find cumulative frequencies.

6.

Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Largest(1) Smallest(1) Confidence Level(95.0%)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.