Hey guys!
I'm working on a project for a class, and I'm running into a few problems.
The assignment asks to take at least 50 random samples of size 100, out of a lot of 100,000 numbers. I was to take the sample variance and sample mean of each, which I have done. I have 51 different sheets of sample data(named Sample 1, Sample 2,....., Sample 51), with the mean in cell C1 and variance in C2. I am to make a histogram (I'll be using the Data Analysis add-in) of the sample mean and variance.
I was wondering how I can select that same cell in all 51 sheets and make a histogram of it. Or, if possible, a quick and simple way to copy the data from each cell into a list on a new worksheet.
I figured this out....Another part of the project asks that I make a confidence interval for a user selectable value of alpha. I linked the word "confidence interval" to the wiki page so you can read a little bit about it. The confidence interval uses the Cumulative Normal Distribution table. How can I make a sort of a lookup table in Excel? The table works in that it finds a value in the chart, takes the Y axis and attaches it to the X axis. (For example, if the user wanted a 95% CI (alpha = .05, look for alpha/2, which is .025), the output would be -1.96, which I would be able to use in a formula).
Any help would be appreciated.
Thanks.
Bookmarks