##
21 posts tagged with excel *and* statistics.

Displaying 1 through 21 of 21. Subscribe:

## is this a good use case for a gamma distribution?

I want to generate synthetic user-session data to predict how big a peak in application usage might be shortly before a weekly deadline (for timesheet submission - it's a time and labour tracking application). I've come up with a method that looks like it works - it involves a gamma distribution for the login time. But I don't have enough (in fact, any) statistical training to know whether I'm using that distribution meaningfully. Statisticians, please reassure me. Thanks! Excel functions inside... [more inside]

## Using Excel's regression tools to determine the 95% confidence interval

MS Excel's regression tools provide 95% lower/upper confidence results but how does one properly interpret and then express those as a single ± (plus/minus) figure? [more inside]

## Find standard deviation in Excel, but first develop a labor-saving trick

Help me with statistics and Excel. Especially help me if you know any labor saving methods. I want the median, mean and standard deviation for the average price of all items sold, but my spreadsheet-full-of-data doesn't tell me the price of each sale -- just the average price per store, and the number sold at that store. Something like this: [more inside]

## What is this type of chart called and/or how do you create one in Excel?

## How to determine relationship between two dimensions of a 3 x 3 frequency matrix?

Could someone help me to analyze statistical relationship between two dimensions of a frequency matrix - preferably in Excel? [more inside]

## Weighted regression?

Excel statistics question (linear regression with weighted data points) [more inside]

## How can I find the average of multiple columns in excel without selecting each individual row that I want averaged?

How can I find the average of multiple columns in excel without selecting each individual row that I want averaged? [more inside]

## Turns out our top referrer is Zombo.com

What are best enterprise level Web Analytic / Stat programs that work with IIS and Apache sever logs? [more inside]

## How do I plot a comparison of points to the normal curve in excel?

How do I compare a scatter of points in excel to a normal curve? [more inside]

## Rates of success?

Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]

## Help me determine rate of imprement for my players!

I coach a high school soccer team. Each practice we go through a routine which involves repetitions of various skills. The number of repetitions accomplished by a player for each skill is recorded in an excel spreadsheet for ranking purposes. I want to determine the rate of improvement so the players can see their progress and who's improving most. Is there a simple excel function that would help me do this?

## Stats/Maths filter: How do I solve a sigmoidal?

I am trying to fit my data onto a sigmoidal function. The fit won't be perfect, but I am stuck with it for now.
To help with this, I have been (very generously) given a spreadsheet that creates a sigmoidal curve if the values a, b, x0 and x are known. How do I get these values? [more inside]

## linearity without the scatterplot

How do I check for linearity? [more inside]

## Adventures in Data Interoperability

How do I convert a large raster image into a table for analysis and manipulation? [more inside]

## Need advice about statistics...

Am I distorting my data, and not showing the true picture? [more inside]

## Please help me format Excel cell correctly - URGENT!

I need to enter the following information into excel, but excel wants to transform one of them into a date format. This is for a statistics class and being used to make a graph of some kind. [more inside]

## Name that Chart!

Excel help: How do I make a chart which displays my values as bars extending above

*and below*a particular line. [more inside]## complex dice probability make head esplode

I need a tool to help me analyze the probability of certain events occurring regarding a pool of X dice for a game I am creating. See my examples below.
[more inside]

## StatisticsFilter: Correlation over time?

If I'm looking at existing statistical data, how do I try to find a correlation between two variables over time? Scatterplots have confused me, because they don't seem to reflect the passage of time, but just where x and y meet. Pearson's

*r*doesn't seem to do it either w/r/t time. [more inside]## How to compare multi-row averages in JMP?

How do I compare averages in JMP (statistical software)? Help me stop using Excel. [more inside]

## Help me calculate a hidden value in my data

I've spent the past day or so trying to figure out how to calculate a hidden value in my data. It varies linearly with time, or closely enough that we can make that assumption within any given dataset. Where this goes beyond a simple linear regression is that each datapoint is known to be above or below the hidden value. The data is collected in a C# program and processed in Excel; an Excel function would be the ideal solution. [more inside]

Page:
1