Question

In: Statistics and Probability

Excel Homework: We are going to start working on sample statistics—that is, on measures we can...

Excel Homework:

We are going to start working on sample statistics—that is, on measures we can sue to describe a sample. The two that we will learn about today are histograms, and 5 number summaries (which can be represented using box-plots).

1. You are designing a game, and considering having players roll a six-sided die and a 20-sided die, and add the values of each die. To get a picture of what happens when someone rolls dice like that, you decide to collect a sample of size 30, and see what it looks like.

**I understand you would use “=randbetween(1,6)” in excel for the six sided die but this problem is also asking to do it with a 20 sided die as well and add the values but I don’t know how**

Solutions

Expert Solution

randbetween(a,b) gives random integer between a and b inclusive

now

for 6-sided, we use =randbetween(1,6)

for 20-sided die, we can use =randbetween(1,20)

x1 x2 sum
5 13 18
6 14 20
4 17 21
1 20 21
4 11 15
6 14 20
4 11 15
6 3 9
4 2 6
2 1 3
6 19 25
5 3 8
1 18 19
3 18 21
4 5 9
2 8 10
6 16 22
6 7 13
4 1 5
4 18 22
5 19 24
4 8 12
1 10 11
3 20 23
3 3 6
2 1 3
2 5 7
3 20 23
5 5 10
6 16 22


Related Solutions

We are now going to use Excel to test a hypothesis based on one given sample....
We are now going to use Excel to test a hypothesis based on one given sample. We would like to know if the average cholesterol level of patients in intensive care is equal to 200 and for that reason we collect cholesterol level of 20 random people from various intensive care units. Cholesterol level 154,168,134,201,208,220,225,228,201,207,168,211,203,254,268,198,298,135,154,189 We put our data in column A. In Cells A3-A22 we type our data and in cell A1 we type Cholesterol. First let’s input the...
For Homework 4, we are going to present the user with a series of menus, accept...
For Homework 4, we are going to present the user with a series of menus, accept as input the action they wish to take, and act appropriately. You must practice basic input validation to ensure that the menu option they chose is valid. Create “CPS132 Homework 4” project in Eclipse Create “Homework4.py” file Download "Homework4_incomplete.py" Paste the text into "Homeworkpy" Make sure to fill in the appropriate information in the header including your name, username, due date, Homework #4, and...
For this homework we are going to walk you through creating a class. Lets look at...
For this homework we are going to walk you through creating a class. Lets look at a pizza restaurant and create a class for this. We will call our class pizza. The goal for every class is to include everything that has to happen for that class in 1 place. So whenever we create a class we need to think of what the nouns or variables will be for that class and then what the actions or methods will be...
Complete the following table using the Excel functions like we did for homework: Hint: There is...
Complete the following table using the Excel functions like we did for homework: Hint: There is no function for calculating coupon payments. (Assume semi-annual coupon payments and the bond's par value is $1,000.) Bond Coupon Rate Yield to Maturity Periods to Maturity Annual Coupon Payment Current Bond Value Discount or Premium A 3.0% 5.0% 10 B 4.5% 4.0% 10 C 3.5% 6.0% 10 D 5.0% 5.0% 10 E 11.0% 10.0% 10
Sample statistics, such as the sample mean or the sample proportion, can be used to estimate...
Sample statistics, such as the sample mean or the sample proportion, can be used to estimate a population parameter (such as the population mean or the population proportion). For example, you can estimate the true mean weight of all newborn babies in the entire world by collecting a sample and using that sample to generate a 95% confidence interval. Because the sample is typically a relatively small portion of the entire population, errors will have to be considered. Using a...
What does it mean to say that we are going to use a sample to draw...
What does it mean to say that we are going to use a sample to draw an inference about a population? Why is a random sample so important for this process? If we wanted a random sample of students in the cafeteria, why couldn’t we just choose the students who order Diet Pepsi with their lunch? Comment on the statement, “A random sample is like a miniature population, whereas samples that are not random are likely to be biased.” Why...
can we prove the alternative hypothesis using statistics
can we prove the alternative hypothesis using statistics
Thought on working with Data. What can we used data. How can we work with it....
Thought on working with Data. What can we used data. How can we work with it. I need a paragraph
(Please show excel working tab) Question 1 (25 marks) Design an Excel financial model that can...
(Please show excel working tab) Question 1 Design an Excel financial model that can help to answer the following parts (part 1 - 3). 5 marks will be allocated for the presentation and clarity of your model (e.g., if there are clear headings, clear arrangement for input cells, appropriate use of colors, have some degree of flexibility, generate warning messages for wrong user inputs, etc.). Part 1 Suppose you receive $100 at the end of each year for the next...
Working for a family business can be a great way to start a career. What you...
Working for a family business can be a great way to start a career. What you might lack in pay and benefits, you gain in responsibility and creativity. Would you ever consider working for a family based business? Perhaps you already have some experience in this arena. Tell us why you would or would notwant to work for a family based business. 26 please not exceed 150 words
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT