[Solved] 2 Using Excel Model Variable Xi Probabilities Listed Table Make 1000 Trials Make Plot 4 F Q37215556

2) Using EXCEL model the variable Xi with the probabilities listed in the table below. Make 1000 trials and make a plot with the 4 frequencies; make sure that they are equal with expected probabilities within errors. Xi P(Xi) 15% 13% 27% 45% 2 4 Show transcribed image text 2) Using EXCEL model the variable Xi with the probabilities listed in the table below. Make 1000 trials and make a plot with the 4 frequencies; make sure that they are equal with expected probabilities within errors. Xi P(Xi) 15% 13% 27% 45% 2 4

Expert Answer

---

Answer to 2) Using EXCEL model the variable Xi with the probabilities listed in the table below. Make 1000 trials and make a plot … . . .