Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
1answer
29 views

Best optimization package for employee scheduling problem? [closed]

I am looking to solve the optimization problem described below. Which optimization software package would be best suited for this, considering the requirements specified below? Requirements: 1) Can ...
0
votes
0answers
36 views

Countif in Excel with multiple criteria [migrated]

I have an index for law and order conditions in many countries over several years. For each country I want to find out how many countries are ahead and how many countries are behind for a given year. ...
1
vote
2answers
38 views

Arima with xreg, rebuilding the fitted values by hand

I'm using R to do some time series estimation. I'm trying to rebuild the fitted values from an Arima model by hand to use in an Excel spreadsheet using the estimated coefficients and the input data. ...
2
votes
0answers
25 views

Monte Carlo simulation of investment account

I'm trying to estimate performance of an investment account over 20 years. The question is, have I set up the Monte Carlo simulation correctly? I've used Excel. I've assumed 8% average return and 13% ...
0
votes
0answers
36 views

How to figure out if there is a relationship between two datasets (nominal and metric)?

I'm working on winderosion and the question, if there is a relation between erosive winds and high PM10-concentration (fine dust) as a evidence to eroded dust particles. I have two different ...
0
votes
0answers
12 views

How to identify contributors in groups of people

I have a set of 120,000 people. These people are assigned to 10 million groups. Each of these groups have a target variable indicating the kind of output it made (A, B, C or D). I'd like to identify ...
6
votes
4answers
187 views

Help creating a chart to show categorical data over time

The scenario: Over a course of 10 minutes 2 security guards patrol a floor and have their movement tracked. They can either be on the left or the right side of the floor, and within each side of the ...
1
vote
0answers
15 views

How to fit two or more datasets with different occurence for regression

I want to run a regression in R with different datasets. The question is whether stock performance (daily log return) is influenced by factors like interest rates (the one set by fed or ECB), size of ...
0
votes
2answers
104 views

Excel: which products are most frequently ordered together? (clustering question)

I'd like to recruit your help in coming up with an Excel-based method to analyse a set of raw ordering data where each item is on its own row. So, in the data below, order 111 contains two part ...
3
votes
1answer
72 views

Analyzing change in categorical data with age

I have data in an excel spreadsheet of around 500 participants in a taste experiment. The data includes the age of the participant, in addition to one of five locations on their tongue in which they ...
0
votes
0answers
32 views

Please help me plug values into an MA(q) model

yt = u + 0et + 0et-1 + 0et-2 01= .5 02 = .25 My series of existing data is : 1,0,2,0,1,0 So I estimate the first forecast value will be : yt+ 1 = .66 + .5(-.66) + .25 * .34 yt = 1 = .4125 I ...
0
votes
0answers
23 views

Please help me with my MA(q) spreadsheet

Okay I have given this a go but I think it is totally wrong. Can someone please make this correct for me ? To understand the MA(q) model I really need to plug some numbers into it as I', finding these ...
3
votes
2answers
143 views

How to calculate Estimated Arithmetic Mean for a lognormal distribution

I have been tasked to program functions from some Excel sheet into a asp.net app so it can be shared to my colleagues via a web interface. However, I am stuck on one thing. I have a set of variables ...
7
votes
1answer
203 views

What is the best way to Reshape/Restructure Data?

I am a research assistant for a lab (volunteer). I and a small group have been tasked with the data analysis for a set of data pulled from a large study. Unfortunately the data were gathered with an ...
1
vote
1answer
35 views

Chi Square Analysis Percentages

I've used chi-square analysis in school, but was absent for the lesson, and I never quite got the hang of it. I've been successful with it in the past, but now I'm trying to use percentage values, and ...
0
votes
0answers
31 views

Discovering Values with Forecast

So, I have numbers that I know are going to be between 1.01 and 1000. Each value corresponds to 1 second. Is this is a time-series? I've been searching all over, but I can't figure out if these ...
1
vote
0answers
44 views

Reproduce a confidence interval of linear regression in Excel [duplicate]

After a series of tests and exploratory analysis, I have design a linear model in R, the model is the following: ...
3
votes
1answer
173 views

Truncate lognormal distribution with excel

I have a dataset where I extract the mean and the standard deviation, I want to generate a new synthetic dataset which is lognormal distributed based on the original dataset paramaters. Like a ...
2
votes
1answer
85 views

T-Distribution using Excel?

I was given this sample problem: Find the t-value such that the area under the t distribution to the right of the t-value is 0.2 assuming 10 degrees of freedom. So, I went poking around in ...
0
votes
1answer
63 views

Please help me understand white noise and MA(q) [closed]

I am reading the section about moving average models in Hyndman & Athanasopoulos Forecasting: principles and practice. I am trying to understand the MA(q) model in words. What is white noise? Is ...
0
votes
0answers
33 views

Testing whether or not a result is significantly different from another?

If I have a table with results (columns being different feature subsets and rows being different machine learning algorithms) how can I test whether or not some of the results (0-1 loss) is not ...
1
vote
2answers
67 views

Excel CHISQ.TEST

In Excel, if I get a value that is less than alpha (i.e. I get a value near zero) for the CHISQ.TEST function, does this mean that the my observed data follows the expected distribution or is it the ...
2
votes
1answer
26 views

How to minimize SSE with given slope of 1?

With given data, I need a line of slope 1 with minimized SSE. Anyone know how I could do this in R or Excel or another program? If you could tell me how to do it mathematically that might help. ...
1
vote
1answer
101 views

Excel T-Test “Set X is better than Set Y by ___%”

Coming from this post, but their question wasn't fully answered. I understand how the t-test works – if I have two sets of data and want to see if one is better (or worse) than the other, I would say ...
1
vote
1answer
60 views

Significance of $R^2$

I have set up a linear regression array in Excel and now want to test the significance of my $R^2$ value at a certain level of significance. I've only been able to find tables that give the critical ...
5
votes
3answers
540 views

Regression - How do I know if my residuals are normally distributed?

Performing a regression and need to find out if my residuals are normally distributed.
0
votes
2answers
70 views

How to digitize an image graph to excel data? [duplicate]

I'm trying to compare my model results with an experiment. I want to overlap the model curve with experiment curve from a paper. What are my options for digitizing the graph from an image in the pdf ...
0
votes
0answers
67 views

ARMA Model Output & Excel

I am using my Eviews Output of an ARMA Model, taking the coefficients in other to perform my Forecasts in Excel. However, I am not being able to match the residuals of the in-sample estimations ...
-2
votes
1answer
79 views
0
votes
1answer
48 views

with Excel, generate 0 with n% probability OR generate 1 with (1-n)% probability

(first of all I simplified my question) depending on the input info below, I want to create proper excel function in output part. what I require verbally in output part under "status (0 or 1) ...
0
votes
0answers
13 views

What is the best way to analyze data from the Likert scale [duplicate]

The Likert scale is being used during a telephone survey to gather patient responses to 5 statements regarding educational material provided during his or her surgical experience. The scale ranges ...
3
votes
1answer
96 views

Validating Correlation in Excel

I have been using CORREL() function in excel for considerable amount of time; I just wanted semi-manually calculate correlation for fun, and the the value I got did not match the value I'am getting ...
11
votes
3answers
1k views

Best open source data visualization software to use with PowerPoint

What is the best open source data visualization software? I require the following: Can import data from Microsoft Excel (importing data from Oracle databases would be good too, but this is not ...
0
votes
0answers
16 views

One-Tailed Fisher's Exact Test [duplicate]

How can I calculate p using a one-tailed fisher's exact test for a 2x3 (or 3x2) contingency table using excel? I found the formula ...
0
votes
0answers
14 views

Detecting poaching by age class proportion - suggested test for detecting decrease in given age class?

My dataset consists of observations of individuals, recording the date and the individual's age class. Age classes vary in bin size: 0-4 5-9 10-19 20-40 Example ...
1
vote
1answer
94 views

Sample-adjusted meta-analytic deviancy macro/syntax for Excel, SPSS, MPLUS

I need to compute the sample-adjusted meta-analytic deviancy (SAMD) as part of an outlier search with meta-analytic data. Because we have a very large amount of meta-analytic data, computing this ...
0
votes
2answers
107 views

How to run a multiple nonlinear regression in Excel or R? [closed]

I am very inexperienced with R and have only a limited background with Excel but have some data that I need to run a multiple non-linear regression with. What is the best way to do this? With R or ...
0
votes
0answers
40 views

How do I report my ranked ordinal data?

I passed out a survey to the community and I am unsure how to properly report the data. The question is: "Rate from 1-5: one being the most important and five being the least important. I will attend ...
9
votes
1answer
427 views

Strange way of calculating chi-squared in Excel vs R

I'm looking at an excel sheet which claims to be calculating the $\chi^2$, but I don't recognise this way of doing it, and I was wondering if I'm missing something. Here is the data it is analysing: ...
2
votes
2answers
435 views

How to apply a logarithmic trendline if X Values = 0?

OK, I know its not possible because Log(0) is undefined. But here is my Problem: I measured a Weight gain of my Test object's over Time. Test objects, made of nonwoven material, were placed in very ...
0
votes
0answers
103 views

Which statistical method should be used for finding statistical significance of any observed correlation?

My knowledge of statistical methods is so poor, so I don't know exactly what is the best statistical method to opt in my case. Ultimate goal: These parameters(A, B and C) could affect parameter D. I ...
0
votes
1answer
76 views

Several items for one construct

I am a dummy in statistics but need to accomplish some simple survey analyses. My question is: if I have several questions (items) for one construct (say, questions JS1-JS3 for job satisfaction) with ...
2
votes
1answer
206 views

Discovering a distribution and plotting a trendline in excel

My wife is a server at a restaurant and I've been tracking her tips over the last 9-10 months. The domain of her set is $[\$75,\$702]$ with a mean of \$236.7 and a standard deviation of \$106.64. ...
2
votes
0answers
365 views

How to get Bhattacharyya Distance in Excel (or Matlab, or R)

I have several histograms which I would like to compare to one reference histogram to see which one is the most similar to the reference in terms of the shape of the distribution. Kologorov-Smirnov ...
1
vote
1answer
2k views

given mean and standard deviation, find value of given percentile

I'm running a DnD campaign and made a Random NPC generator in Excel. It's pretty slick, but the random height/weight calculator is... flat. RAND(X,Y) flat. So I'd like to add some Bell Curve ...
0
votes
0answers
24 views

How to validate % answering Yes/change exists is enough to say population is seeing a new pricing model?

I have a survey on pricing. There are questions where there is an A and B choice where the proportions are not independent (mutually exclusive group). Here I can use a binomial distribution in Excel ...
3
votes
1answer
56 views

How to determine if % selecting Option A is statistically different from selecting Option B in a survey?

I ran a survey on pricing and asked respondents to choose between option A or Option B. 61% chose option A and 39% chose Option B. The sample size is 90. How do I determine if the % selection Option A ...
0
votes
0answers
219 views

Different outputs for linear regression in WEKA and Excel

I was double-checking my regression outputs in WEKA and Excel. All coefficients are the same, however I get a considerably different intercept. How come? Also, is it possible to run a t- or p-test or ...
0
votes
0answers
40 views

Standard measurements in excel

I have a set of data in MS Excel 2013 and I want to do very common calculations on it I got a bit confused with the different formulae available and am not quite sure if I chose the correct ones. ...
1
vote
0answers
290 views

(non) linear regression on graphs with multiple y per x values

I have a data set with multiple y values per x value. Using Excel the scatter plot and the regression line tools, I wish to apply regression on the data to determine if there is any connection between ...