![]() ![]() ![]() In the Excel workbook that accompanies this page (link at the bottom of the page) you will find a large amount of data: the temperature recorded somewhere on earth every month from 1907 to 1972. The way they work is different and the answers they give are initially different although with a little bit of effort we can make them the same! The page will also demonstrate that the frequency function can be used either as an array function or as an ordinary non array function. The purpose of this page is to demonstrate both the frequency functions and the COUNTIFS() function in this context. The Frequency and COUNTIFS() functions are both very convenient ways of preparing frequency distributions that we can use to draw a histogram.
0 Comments
Leave a Reply. |