Search All of the Math Forum:
Views expressed in these public forums are not endorsed by
Drexel University or The Math Forum.



Re: Forwarded to the list (fwd)
Posted:
Aug 29, 1996 8:45 PM


I tried what Paul suggested and I don't think it does what Bill wants, but I could be misinterpreting what he wants. My interpretation is that he has data like this
x f
1 24 2 14 3 12 4 0 5 1
representing 50 numbers (all integers between 1 and 5 inclusive) and he wants ONE mean for all 50 numbers. I do not get ONE mean from the TABLE command. I can do this with a macro I wrote. See end of message. I'd be curious if this is what Bill wanted and if the results below are what Paul is getting by his method for this data.
 Forwarded message from Paul James 
I think what you are looking for is in the table command under stats. 1. go to  tables 2. cross tabulation 3. in Classification variables enter c1 4. trun on Frequencies are in box and enter c2 5 go to summaries, pick what you want (very limited and not all seem to work) 6. in associated variables enter c1 and you are off to the races
>> >>I'm using Minitab for my Statistics classes, and I was trying to do something >>last night and got stuck. I have a list of data in column C1 and their >>corresponding frequencies in column C2. I want to do descriptive statistics >>on it, and I can't figure out how to tell Minitab that the frequencies are in >>C2. All it will do is give me the statistics on C1, without using their >>frequencies. I know that I'm probably being pretty thick headed and there is >>something obvious that I'm missing, but I don't know what to do. I've read >>the books and manuals that I have, and they don't seem to help. I'd also >>like to make a normal probability chart of the data, and it isn't doing that >>either. If it makes a difference, I'm using the student edition. >> >>Can anyone tell me what I'm doing wrong? You'll have my eternal gratitude. >> >>Bill Roloff
 End of forwarded message from Paul James 
MTB > set c1 DATA> 1 2 3 4 5 DATA> end MTB > set c2 DATA> 23 14 12 0 1 DATA> end MTB > execute 'stats1a/macros/vargroup' Executing from file: stats1a/macros/vargroup.MTB This macro computes the mean, variance, and standard deviation of grouped data. The data values must be stored in c1 and their frequencies in c2. The results of all intermediate steps are printed out to aid students in learning to do these computations by hand. The macro will destroy any data stored in c2c4, k1k7, and any name given to c1.  ROW x f xf resids. res.sq. res.sq.f 1 1 23 23 0.84 0.7056 16.2288 2 2 14 28 0.16 0.0256 0.3584 3 3 12 36 1.16 1.3456 16.1472 4 4 0 0 2.16 4.6656 0.0000 5 5 1 5 3.16 9.9856 9.9856  MTB > print k1 The total = K1 92.0000 MTB > print k2 number of observations = K2 50.0000 MTB > print k3 mean = K3 1.84000 MTB > print k4 The sum of the squared residuals = K4 42.7200 MTB > print k5 degrees of freedom = K5 49.0000 MTB > print k6 variance = K6 0.871837
MTB > print k7 standard deviation = K7 0.933722 MTB > end

_   Robert W. Hayden   Department of Mathematics /  Plymouth State College   Plymouth, New Hampshire 03264 USA  *  Rural Route 1, Box 10 /  Ashland, NH 032179702  ) (603) 9689914 (home) L_____/ hayden@oz.plymouth.edu fax (603) 5352943 (work)



