Excel is a commercial spreadsheet program created by Microsoft.
0
votes
0answers
13 views
Add Values from Multiple Columns in Pivot Table
I have a created a pivot table from excel sheet which has many columns & many rows. Here is my requirement.
The Pivot Table has,
...
1
vote
0answers
32 views
Regression for foreign aid effectiveness
I'm trying to use a multiple regression (in Excel) to determine the effectiveness of foreign aid on GDP growth. I've forgotten everything since college...
My plan is to run a regression using ...
3
votes
3answers
119 views
Given a 95% confidence level, how do I demonstrate 95% of the intervals actually contain the population mean?
Let me say first off that I'm consistently impressed with the quality of responses on this site. You folks have done a better job of explaining difficult concepts than most instructors or textbooks ...
0
votes
0answers
6 views
How to set rownames of a data.frame? [migrated]
I came accross an issue when creating a data.frame. I can create the data.frame, and set the appropriate row.names and col.names.
Results looks like this:
...
3
votes
1answer
97 views
Identifying a minimum time on web page as proxy for successful search outcome
Given a correlation between two sequences of numbers, I need to find to what point in one sequence the correlation is strongest. Here's why:
I'm tracking large numbers of pages in a knowledge base, ...
0
votes
2answers
94 views
How find a distribution for a set of data?
Hi I have a set of data(message with different size) in excel like (over 5000 entries):
...
2
votes
2answers
49 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
26 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
170 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
41 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
2answers
134 views
How can one set up 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 such as R and Rapidminer I have not spent much time on understanding ...
1
vote
2answers
73 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
72 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
75 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
885 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
186 views
Difference between Excel's exponential chart trend line and GROWTH/LINEST function? [closed]
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
578 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
12 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 ...
4
votes
2answers
654 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
30 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
157 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
39 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
596 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
196 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 ...
1
vote
1answer
126 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
91 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
124 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
319 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
121 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
940 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
53 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
130 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
1k 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
122 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
301 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
52 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
133 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
309 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 ...
1
vote
3answers
2k 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
84 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
456 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
110 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
105 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
408 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
172 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
213 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) ...
