Please help. I\'m so lost 10. Using Excel select the random number generator. Ha

Question

Please help. I'm so lost

10. Using Excel select the random number generator. Have the program select 42 random numbers between 1 and 99. Using Excel make a list of the numbers in column A. Explore the pull-down menu and find a selection that allows you to create a frequency distribution. Remember that this is quantitative data. You will have to determine the interval size and the first lower limit. After creating the distribution ask Excel to draw a histogram, a frequency polygon, and a cumulative frequency polygon. If you have an add-in that enhances Excel use it to answer this question.

Explanation / Answer

Ans

Above question can be awnsered in excel using the following commands

a) RANDBETWEEN(1,99) - will generate a random number between 1 and 99. Drag the list to whatever count one wants. I tried till 99.

b) =INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1) - Where A column contains the above 99 numbers.

This formula will help select a random number for the list of 99 created random numbers.

Drag the list to 42 times for selecting 42 numbers

c) Using Data Analysis Tab, (The same can be added using Excel Add-ins) and from that one can select an option of HISTOGRAM.

Pass to the histogram the input range and the bin range , the same will result in creation of a table, with frequency and cummulative frequency and histograms.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---