Excel is a commercial spreadsheet program created by Microsoft.
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 ...
