[solved]-Problem 2 Recall Spreadsheet Example Two Dice Class Design Experiment Tossing Two Fair Dic Q39705757

Problem 2 Recall the spreadsheet example of two dice in class. Design an experiment of tossing two (fair) dice simultaneously. • Set number of trials to 100. • Colum B (trial number from 1 to 100), Column C (face of Die #1), Colum D (face of Die #2), Colum E(Sum of #1 and #2), • Provide all possible outcome numbers of Sum in Column G. • Provide the theoretical probabilities in Column H per each row corresponding to the outcome number of Sum. • Provide the relative frequencies in Column I per each row corresponding to the outcome number of Sum. Hit F9 key to observe. • What is the theoretical) probability of Sum equal to 7, and an observed relative frequency? What’s the difference between these two? Show transcribed image text Problem 2 Recall the spreadsheet example of two dice in class. Design an experiment of tossing two (fair) dice simultaneously. • Set number of trials to 100. • Colum B (trial number from 1 to 100), Column C (face of Die #1), Colum D (face of Die #2), Colum E(Sum of #1 and #2), • Provide all possible outcome numbers of Sum in Column G. • Provide the theoretical probabilities in Column H per each row corresponding to the outcome number of Sum. • Provide the relative frequencies in Column I per each row corresponding to the outcome number of Sum. Hit F9 key to observe. • What is the theoretical) probability of Sum equal to 7, and an observed relative frequency? What’s the difference between these two?

Expert Answer

---

Answer to Problem 2 Recall the spreadsheet example of two dice in class. Design an experiment of tossing two (fair) dice simultane… . . .