My Math Forum  

Go Back   My Math Forum > Math Forums > Math

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

LinkBack Thread Tools Display Modes
September 1st, 2018, 06:04 PM   #1
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). 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 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?
numbers555 is offline  

  My Math Forum > Math Forums > Math

excel, statistics

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Help rfhitter Algebra 3 September 8th, 2017 03:22 PM
excel calculation ytong Calculus 0 May 16th, 2012 07:49 AM
Integral in excel Wim331 Calculus 1 April 11th, 2012 07:22 AM
best introduction to statistics book? not applied statistics ElMarsh Advanced Statistics 2 October 23rd, 2009 05:10 PM
Excel -exponential lucatoni08 Algebra 2 May 7th, 2009 09:21 AM

Copyright © 2018 My Math Forum. All rights reserved.