Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

2
votes
2answers
45 views

Advice needed on auction system simulation

I am trying to simulate an auction system in which a number of competitors, $N$, independently offer a discount from a reference price previously published by the buyer. The order is awarded to the ...
0
votes
0answers
21 views

ANOVA for comparing methods: how to order the data

I'm going to run a series of tests for comparing different methods and combinations per two of those methods. And I was wondering how I'd best order the output so that I can easily use it in an ANOVA. ...
5
votes
1answer
124 views

Chi-squared distribution for dice not returning expected values?

I'm trying to verify that my dice are reasonably fair and balanced. I'm not sure I'm doing it right, though, since I'm basically teaching myself stats without references. To achieve this, I've settled ...
1
vote
0answers
30 views

Graph data from an Excel Pivot in a Tree Representation

I've been looking for a while to see if there's any add-on or software which allows data from an excel pivot to be graphed dynamically in a visual tree representation. I know of the likes of graphviz ...
0
votes
0answers
41 views

How can one setup a linear support vector machine in excel?

Through the last year I have been working with support vector machines for a binary text classification task. Having used software as R and Rapidminer I have not spend much time on understanding what ...
1
vote
2answers
60 views

Data exploration tools for Excel

I have a sample of records, with string and numerical columns. My sample is currently hosted in an excel spreadsheet. I need a tool that wil produce discripte statistics for each colomn, such as max ...
1
vote
1answer
51 views

Calculating the corr. coefficient between returns of portfolios in EXCEL

I want to determine the correlation between the returns of a portfolio with returns of the market (suitable index). To find how the portfolio performs in bear resp. bull markets, I want to calculate ...
1
vote
0answers
18 views

Calculating error bars for Excel Linear Regression [duplicate]

I've ben sent a forecast of sales from a consultancy. It uses Excel's LINEST function, taking 4 factors that seem to have affected sales in the past, and used them to make a prediction. How do I go ...
3
votes
1answer
59 views

How to back-calculate change from baseline from a p-value for a paired t test

I have a result from a study in a research paper which gives a mean/SD for 2 time points (pre & post treatment), and a p-value based on a paired-samples t-test. What I want to calculate is the SD ...
0
votes
1answer
381 views

How do I interpret the results from the F-test in excel

I have a fairly simple question regarding the interpretation of the F-test in Microsoft Excel. Let't say these are the results of my F-test: http://i.imgur.com/ZLzEQih.jpg I am now wondering how to ...
1
vote
1answer
112 views

Difference between Excel's exponential chart trend line and GROWTH/LINEST function?

I have a exponential trendline that was generated by excel ("Add Trendline") on a chart. I've plugged in the equation (from the "Display Equation on Chart" option, up to 14 decimals) into a ...
5
votes
4answers
479 views

Excel, Heatmap & Data Visualization without add-ins

I am working for a big company with a restrictive internet policy and Excel-addicted colleagues. I am currently working on evolution of market correlations which implies some statistics, data ...
0
votes
0answers
11 views

copying first 3 columns from different worksheets to single files in Excel using VBA code [closed]

Im' a total noob when it comes to visual basic. I have a bunch of datasets with always the same worksheets. Now I want to make a different file for each worksheet. I found some code that does just ...
3
votes
2answers
382 views

How to get the expected counts when computing a chi-squared test?

I just have 1500 data points in excel. However, I want to do a chi squared test to prove if the data is normaly distributed. My question is: How to calculate the expected range for such a large data ...
0
votes
1answer
29 views

I need to access the 400th column in my excel document [closed]

I have to do this many times with columns 400, 500, 550, etc. This datasheet is monstrous to navigate by hand. My current solution is a little script that takes the column I want to go to mod 26 and ...
1
vote
1answer
144 views

Correlation coefficient of two variables with unequal number of data using Excel

How do I find the correlation coefficient of two variables with unequal number of data using Excel? And do I use the mean as data to calculate?
0
votes
0answers
38 views

Question on re-indexing data for graphing

A file contains data for 1975-2012 of housing prices across a panel of countries. However, it's indexed to 2005, so each country's housing price series converges to 100 in 2005, then they spread ...
3
votes
1answer
486 views

How to calculate cumulative Poisson probabilities without adding each one if no. of outcomes is large and hence, adding (without excel) is difficult?

One can calculate the probability of a correct score of a football match by Poisson(Number of Team1 goals, Mean average Team1 goals) x Poisson(Number of Team2 goals, Mean average Team2 goals) So for ...
0
votes
1answer
174 views

Calculating factor scores in SPSS

I have done a factor analysis on different attributes of different cigarette brands (e.g. how expensive consumers find it, etc.). Three factors were calculated out of the many attributes after ...
0
votes
0answers
92 views

Multivariate distance function in Excel

I want to do a simple nearest neighbour calculation in Excel over a multivariate space to get an idea of how my data clusters. I have a set of data points $\{X_1, X_2, \ldots X_n\}$ and a set of ...
-2
votes
1answer
82 views

How to work with dummy variables and other variables at the same time in cluster analysis [closed]

How to do cluster analysis if you have all variables in array from 1 to 5, and 1 dummy variable (0 and 1). can you explain from the beginning--Excel format, please.
1
vote
1answer
109 views

An Alternative to the tdist() Function in Excel for Google Spreadsheets?

I'm using Google Docs for a statistics class and my instructor suggested we use the "tdist()" function in Excel. http://office.microsoft.com/en-us/excel-help/tdist-HP005209312.aspx I can't find ...
3
votes
1answer
254 views

Best way to display data with outliers?

I am fairly new to data analysis and visualization, and I'm trying to figure out the best model to show some data regarding page load time (in seconds). The current view is a line graph where the ...
1
vote
1answer
113 views

Uncertainty from linear fit on additional data

Let's say I have 5 known data points with coordinates $X$ : Area under curve $Y$ : Activity The 5 points have individual error ($\Delta X_{i}$,$\Delta Y_{i}$) on both $X$ and $Y$ and I know that ...
0
votes
2answers
864 views

How to do multiple regression with limited experience and (hopefully) excel?

I am doing a study of how legal need relates to a number of predictors. Outcome Variable: Legal Need (Yes or No) Possible Predictors: Age, Gender, Race, Ethnicity, Language, Clinic, Insurance ...
1
vote
0answers
50 views

Visualizing probability of event over time, based on epoch time

I have a list of times at which an event happened. My hypothesis is that there are certain times during the week when this event might happen more frequently. How can I visualize/determine which times ...
2
votes
3answers
126 views

Calculate relative price levels in 4 markets?

I am working in Excel and want to calculate the relative price level in 4 markets. I know a good method I can use when I am only looking at 2 markets ...
0
votes
2answers
874 views

How to plot a mekko chart in Excel?

So a question you will have from here! Q: What is Mekko? A. Its like a histogram. The bar chart can show information in two axes. Normally in a bar chart the y axis shows the variation and x shows ...
2
votes
2answers
112 views

Simple extrapolation of web traffic

I have the following data for web traffic in Excel June 88,147 July 111,839 August 93,148 September 93,069 October 101,881 November 97,345 I can do a chart with a trend line and a linear ...
1
vote
2answers
268 views

Problem with Spearman correlation in case of many ties

I'm using the Spearman correlation coefficient test for multiple non-parametric ranked categories in excel. I used the built in rank function in excel to calculate the rank of each individuals but i ...
1
vote
0answers
50 views

Extracting numbers from excel table items for diagram visualization [closed]

I am newbie in Excel and I wanted to know is it possible to make Microsoft Excel to interpret following dataset: ...
5
votes
2answers
132 views

Formatting graphs and figures: why and when is it bad to include horizontal lines?

I am TAing a course where students are required to turn in their lab reports formatted like a submission to the journal Ecology. Figures and graphs in this journal do not have the horizontal lines ...
0
votes
0answers
45 views

Best way to analyse rows with two weighted variables in Excel [closed]

Here's what I'm trying to do. I want to be able to keep an excel sheet of regional job listings, with weighted results. My criteria are: Skills needed for job with a scale of 0-3. 3 being most ...
5
votes
1answer
300 views

Beta distribution from mean and quantile

Suppose I'm given the mean and one quantile (e.g. the 20% quantile) of a random variable $x$, and I want to find the parameters $\alpha$ and $\beta$ of a Beta distribution that has the same mean and ...
0
votes
3answers
1k views

How to use triple exponential smoothing to forecast in Excel

I have been burdened with the task of coming up with a forecast plan for my company. I have no experience and am VERY new to the whole forecasting scene. As of right now, my company has no plans of ...
3
votes
0answers
76 views

Log-Ratio \ Compositional analysis

I am not a trained statistician but I am trying to improve on my own MBA thesis which was essentially regression analysis of the factors affecting opening cinema box-office in the UK. I am now ...
1
vote
2answers
427 views

How to test outliers, normality, homoscedasticity? [closed]

With the Data Analysis command in Excel I made a plot, which I can't post, because this is my first post ever. ...
3
votes
0answers
107 views

Forecasting a complex time series by splitting into subseries

I have finance data that I need to forecast out for 7 years. My data is generally debits and credits, and those are split into a number of sub-series which share common traits (e.g. similar ...
2
votes
1answer
97 views

How to measure smoothness of a time series in Excel?

I've found how to measure the smoothness of a time series in R from this previous CV question, and I think I understand it, but I don't have access to R, only to Excel. How would I calculate this? ...
4
votes
2answers
2k views

Performing multiple linear regressions, in Excel, that have a common x-intercept?

I was plotting some linear data sets in Excel, including linear trend-lines: I was about to perform 5 separate linear regressions, so I could get the slope and ...
2
votes
1answer
400 views

Is it possible to visualize my data set in Excel?

My data set consists of columns containing universities in the Boston area, and rows containing zip codes. For each university and zip code, there are two data points: number of students in campus ...
8
votes
1answer
1k views

How would one graph the results of subjective rank order?

I'm looking for way to visualize subjective rankings, separate from my non-parametric tests. I've asked 12 participants to rank 8 different items according to different subjective criterion (separate ...
2
votes
1answer
160 views

How to analyse raw titration data with R?

My research generates raw data from titrations that needs a substantial number of calculations before I get the numbers in a form that I can analyze. Most of these calculations are relatively simple ...
1
vote
1answer
205 views

How to decide between pearson, distance correlation or maximal information coefficient for currency data?

I have one dataset with currency exchange ratios for several years. The exchange ratios are for two Asiatic currencies and the Canadian dollar, all against American dollars. My (perhaps naïve) ...
2
votes
1answer
292 views

Standard deviation if in Excel

I have three variables some of which are occasionally 0 which is a na and not a sample. I would like to calculate the standard deviation of the remaining two items but there isn't a deviation if like ...
1
vote
3answers
2k views

Slope of a line given multiple points

I have data with a starting (y) value that sequentially increments/decrements as (x) time measured in days passes. I found this link for creating a linear regression of the data ...
1
vote
1answer
98 views

How can you summarize growth in the “production” rate per person?

I have been reading the book, Good to Great by Jim Collins. It says that you should focus on information that "cannot be ignored," and that you should focus on the right "denominator." I thought it ...
1
vote
0answers
364 views

Monte Carlo simulation exercise

The assignment is to run a simulation on excel to figure out the probabilities on obtaining a certain goal: John and Jane Doe are planning to save money to pay a house for their 6-month-old son, ...
7
votes
4answers
4k views

Quartiles in Excel

I am interested in the definition of quartile that is usually used when you're in basic statistics. I have a Stat 101 type book and it just gives an intuitive definition. "About one quarter of the ...
3
votes
2answers
380 views

What is a good software for data collection à la CDC's Epi Info?

I am a medical student working on a project which requires massive data that are collected manually through data entry operators. Although I am using traditional tool used by epidemiologists, Epi ...

1 2 3