Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic Statistics - which function?
Hi,
I have two data sets each measuring windspeed at different, nearby, locations. Meaurements were taken at varying intervals during the same period, (site 1 about every 2 mins, site 2 about every 8 minutes). What I need to do is assess whether the data from one site is reasonably similar to the other. The help provided on the various stats functions is not sufficient for me to be sure that I have selected the correct one - so any hints will be welcome. Thanks, rod |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic Statistics - which function?
Hi Rod,
Two basics possibilities : 1. Graph you data for visual comparison, and trend analysis 2. Make sure the Analysis toolpack add-in is checked, and go to Tools Data Analysis for many readily available statistical tools HTH |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic Statistics - which function?
On Jan 13, 3:59*am, REM wrote:
I have two data sets each measuring windspeed at different, nearby, locations. *Meaurements were taken at varying intervals during the same period, (site 1 about every 2 mins, site 2 about every 8 minutes). *What I need to do is assess whether the data from one site is reasonably similar to the other. *The help provided on the various stats functions is not sufficient for me to be sure that I have selected the correct one - so any hints will be welcome. I'm sure some people with varying degrees of knowledge of statistics might try to help you. I just want to add a note of caution. While Excel provides many statistics functions, its documentation is not intended to teach you statistics. The world is full of examples of the misuse of statistics, on purpose or naively. GIGO. Before you apply any statistical functions to your problem, I suggest that you learn more about statistics and when to apply which functions. Alternatively, get some help from someone who has more than a rudimentary knowledge of statistics. "A word to the wise ...". |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic Statistics - which function?
On Jan 13, 11:54 am, joeu2004 wrote:
On Jan 13, 3:59 am, REM wrote: I have two data sets each measuring windspeed at different, nearby, locations. Meaurements were taken at varying intervals during the same period, (site 1 about every 2 mins, site 2 about every 8 minutes). What I need to do is assess whether the data from one site is reasonably similar to the other. The help provided on the various stats functions is not sufficient for me to be sure that I have selected the correct one - so any hints will be welcome. I'm sure some people with varying degrees of knowledge of statistics might try to help you. I just want to add a note of caution. While Excel provides many statistics functions, its documentation is not intended to teach you statistics. The world is full of examples of the misuse of statistics, on purpose or naively. GIGO. Before you apply any statistical functions to your problem, I suggest that you learn more about statistics and when to apply which functions. Alternatively, get some help from someone who has more than a rudimentary knowledge of statistics. "A word to the wise ...". Use the Correlation tool in analysis toolpak. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic IF function help | New Users to Excel | |||
any function good for statistics or math please | Excel Worksheet Functions | |||
Basic IF function help needed | New Users to Excel | |||
Custom Function basic | Excel Worksheet Functions | |||
basic sumif function help (urgent) | Excel Worksheet Functions |