My Math Forum > Math Statistics using Excel

 Math General Math Forum - For general math related discussion and news

 September 1st, 2018, 06:04 PM #1 Newbie   Joined: Sep 2018 From: United States Posts: 1 Thanks: 0 Statistics using Excel I have been working on a project and it's been several years since I've taken statistics and I've never really used excel for this sort of stuff so I am uncertain if my process is correct. I'm hoping someone will be able to provide some guidance. I am working on something with tornado data and I am looking to determine if a certain period (could be a month, year, or season) is above-average or below-average, and if so, how much above or below. To do this I was going to create standard deviations. In Excel, I have tornado data for all March's from 1950-1965. I used the average function to give me an average and then I used the STDEV.P function to yield some standardized number. (I'm hoping the STDEV.P function was the correct choice to choose). Anyways...so the average doesn't get skewed by any major outliers I want to see if there are any outliers so they don't get used to find the average and standardized number. So this is what I was doing. Using the QUARTILE.INC function I found the value for Q1 and then Q3. From here I did Q3 - Q1 to get the IQR. I multiplied the IQR by 1.5. To find the lower quartile I did Q1 - ((1.5)(IQR)) and to find the upper quartile I did Q3 + ((1.5)(IQR)) What I think I am confused with is don't you need to find the median or something and the data has to be in sequential order? As for getting the standard deviation what I did was take a value, subtracted it from the average, and then divided by the standardized number. For example... The March 1950-1965 average is 40.38 and the standardized number is 25.0471. March of 1966 had 12 tornadoes...so 12 -40.38 = -28.38 -----> divided by 25.0471 = -1.13 so compared to the 1950-1965 average, March of 1966 was -1.13 standard deviations below average. Is this process/method correct?

 Tags excel, statistics

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post rfhitter Algebra 3 September 8th, 2017 03:22 PM ytong Calculus 0 May 16th, 2012 07:49 AM Wim331 Calculus 1 April 11th, 2012 07:22 AM ElMarsh Advanced Statistics 2 October 23rd, 2009 05:10 PM lucatoni08 Algebra 2 May 7th, 2009 09:21 AM

 Contact - Home - Forums - Cryptocurrency Forum - Top