Wednesday, 11 March 2020

How do you find the midpoints for a range of numbers in the topic of statistics?


How do you find the midpoints for a range of numbers in the topic of statistics? 

A quick quora question, that might be useful to others. 

If you are using excel, you can:
  • sort the data, find the middle value (do a count of the list, divide by 2, to get the midpoint or nearest closest point, depending on whether the count of the list is even or odd).
  • use the excel median function, which does the same thing (if the count of the list is even, it will interpolate between the two numbers closest to the middle).
With other stats packages, you should be able to do similar procedures.

The other two major "measures of central tendency" are mean (add up numbers and divide by the count of the numbers) and mode (find the most common number in the dataset, perhaps via a pivot table or an SQL query). 

There are some other more obscure measures, such as geometric mean, but they aren't seen much in day to day practice.


 

-------------------------------------------------



After doing your stats work, try reading a travel book, which you can buy on Amazon for 99 cents (or read for free if you have Amazon unlimited).


On the Road with Bronco Billy

What follows is an account of a ten day journey through western North America during a working trip, delivering lumber from Edmonton Alberta to Dallas Texas, and returning with oilfield equipment. The writer had the opportunity to accompany a friend who is a professional truck driver, which he eagerly accepted. He works as a statistician for the University of Alberta, and is therefore is generally confined to desk, chair, and computer. The chance to see the world from the cab of a truck, and be immersed in the truck driving culture was intriguing. In early May 1997 they hit the road.

Some time has passed since this journal was written and many things have changed since the late 1990’s. That renders the journey as not just a geographical one, but also a historical account, which I think only increases its interest.

We were fortunate to have an eventful trip - a mechanical breakdown, a near miss from a tornado, and a large-scale flood were among these events. But even without these turns of fate, the drama of the landscape, the close-up view of the trucking lifestyle, and the opportunity to observe the cultural habits of a wide swath of western North America would have been sufficient to fill up an interesting journal.

The travelogue is about 20,000 words, about 60 to 90 minutes of reading, at typical reading speeds.

 



No comments:

Post a Comment