Lab 2.2| Using Excel for Simple Random And Stratified... titudes and behavior re

Question

Lab 2.2| Using Excel for Simple Random And Stratified... titudes and behavior regarding credit. After some preliminary investigation and discussions, ey decide to use three age categories: 18-30, 31-62, and 63-80. It was assumed that no one in e population is younger than 18 or older than 80. How might TesBury proceed to create a ratified sample using Excel? 1. Start Excel and open the file "SamplingWithExcel". Select the "StratifiedSampling worksheet. 2. As you can see from the worksheet, we have a list of 1000 customers (numbered in ascending order) and the ages of these customers. We also know that there are three strata based on age. Our first task is to find out which age stratum each customer is in. To do this, we will assign number 1 if the customer is aged between 18 and 30, number 2 if those customers are aged between 31 and 62, and 3 if they are between 63 and 80. We could do this manually but you can imagine how tedious and time consuming this can be for 1000 entries. We can do this with one formula. How? Follow the instructions below. 3. Select cell C11. We must use the IF Logical function here. The logic is as follows: If it is true that cell B11 is less than or equal to 30, then number 1 should appear in C11; if it is true that cell B11 is less than or equal to 62, then number 2 should appear in C11, otherwise, number 3 should appear in cell C11. Enter the formula lF(B11 D6,1,IF(B11 D7,2,3)) in cell C11 and then copy it down column C. Did you notice that the results are not as expected? Why? Hint: RELATIVE or ABSOLUTE references.

Explanation / Answer

You got incorrect answers because you haven't used absolute reference here . Use this formula -

IF(B11<=$D$6,1,IF(B11<=$D$7,2,3))

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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