Part 1 - With four steps done
Step 1 - Put the following formula to generate a random number and find the minimum values.
Step 2 : To create the histogram. Create bins for the dice
values.
Step 3 : Go to data, click on the data analysis and select
histogram.
Step 4 : Update the values as shown.
Step 5 : The frequency distribution table will be
generated.
Step 6 : Using these result we create the following table and plot
the graph. Using insert -> graphs -> bar graph.
Done as per instruction in the question
a.
b.
c.
The blue line represent the theorotical probability.
Accordingly the closet and the most different is marked
2. Let's now use Excel to simulate rolling two 6-sided dice and finding the minimum of...
Using the previous tutorial, address the following: Imagine an experiment where three dice are tossed and the number on each die is recorded under Die1, Die2, and Die3. Answer the following questions about the sum of the three numbers recorded from: Die1+Die2+Die3. (Discussions allowed) Hint: Simulate this experiment 1000 times. (Use the same procedure as in the above tutorial, but for the Number of Variables, instead of 1 put 3, since we are rolling 3 dice not one). Next, create...
not
precalc- stat
#2. Use the Minitab to simulate 10,000 rolls of two dice. Find the number of times that the sum of the two dice is exactly 7. Based on that result, use the relative frequency approach to estimate the probability of getting a 7 when two dice are rolled. Compare this probability to the true probability and also compare this probability to your estimated probability in #1 when you rolled the dice 1000 times. What do you think...
2 Use Excel to find the following confidence intervals 110points total The feollowing data show the namber of paid vacation days for a random sample of 20 employees from PSU A1 a) Find the 95% confidence interval fr the average number of vacation days. (2 points for output. I point fr ower limit, I point for upper limit Copy the data below your name in cell A3 in Excel. Select the tab labeled Duta, then select Data Analysis If your...
2. (25 points) Sekora International Casino (SIC) is launching a new game making use of fair 6-sided dice . In phase 1, roll two 6-sided dice and compute the difference between the rolls. Call this difference . In phase 2, roll r dice, and add up the total of the rolls. This is the payout in dollars of the game. (with the numbers 1-6 on the sides). The game proceeds in two phases as follows: (a) (5 points) In the...
Excel Lab 2: Regression and Goal Seek In this lab, you will use Excel to determine the equation of the model which best fits a set of ordered pairs obtained from data sets. You will enter data, graph the data, find the equation for the regression model, and then use that equation to make predictions for the dependent variable. You will use the goal seek to make predictions for the independent variable. Then you will consider how accurate your predictions...
C+
HelloVisualWorld, pages 121-125 (in the 3-6 Deciding Which
Interface to Use Section)
We were unable to transcribe this imageCHAPTER 3 Using Guy Objects and the Visual Studio IDE Using Gul Objects (continued) Forn click the Form, its Properties window appears in the lower right portion of the screen, and you can see that the Text property for the Form IS set to Forml. Take a moment to scroll through the list in the Properties Window, examining the values of...
C or C++ Project Overview Wild, Wild, West! Dice Game The Wild, Wild, West! is an elimination dice game. It can be played by any number of players, but it is ideal to have three or more players. Wild, Wild, West! Requires the use of two dice. At the start of the game, each player receives a paper that will track the number of lives that player has. Each player starts the game with 6 lives. In the first round,...
You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions.Instructions:For the purpose of grading the project you are required to perform the following tasks:StepInstructionsPoints Possible1Open e10c2MovieRentals.xlsx and save the workbook with the name e10c2MovieRentals_LastFirst.02Import the movie data from the delimited file e10c2Movies.txt and rename the new worksheet Inventory.Hint: On the Data tab,...
Section 1 Tube [FeSCN^+] M Absorbance 1 0.0005 0.016 2 0.0011 0.0422 3 0.00367 0.0917 4 0.00727 0.224 5 0.00965 0.267 6 0.0137 0.398 Part B unknown sol. 0.175 SCENARIO: Five standard solutions containing different known concentrations of an iron (II) thiocyanate (FeSCN+ ) complex are analyzed using spectrophotometry, a technique which measures the quantity of light absorbed by the solution as a function of the concentration of the analyte in solution (in this case, FeSCN+ ). The results of...