Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
0answers
11 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 ...
0
votes
0answers
17 views

Data Mining from excel [migrated]

new to the site as well as microsoft excel I need help developing a macro to make a manual process into an automated one regarding 2 workbooks. If data in column A and column C of Workbook1, named ...
6
votes
4answers
174 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
14 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
92 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
64 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
21 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
104 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
180 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
32 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
43 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
124 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
82 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
61 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
28 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
59 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
92 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
59 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
482 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
48 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
49 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
78 views
0
votes
1answer
43 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
82 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
957 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
81 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
95 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
38 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
414 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
386 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
101 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
71 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
175 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
320 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
54 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
196 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
273 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 ...
1
vote
0answers
105 views

Data analysis tool with semantic capabilities?

I am currently working with quantitative data in the form of user-provided keywords which means the same idea can be expressed differently (e.g. "teachers, teaching, university, students" are related ...
0
votes
1answer
110 views

Which test-methods are right for my data?

I'm writing my final thesis in Chinese Studies right now and planned on doing a qualitative test but as I have so much data I would like to analyse it quantitatively. I did so but am not sure about ...
0
votes
2answers
117 views

Paired t-test to support increase in student reading scores from fall to spring

I did a pre-test, post-test method and I tried to perform a t-test to show how reading scores increased from fall to spring. I’m not sure if my numbers are accurate. What throws me off is the NULL ...
3
votes
3answers
163 views

Covariance of timeseries

If I have data on a time series with the following structure Day Value, p 1 1.2 2 2.1 3 4.0 4 3.2 How do I calculate the first order ...