Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
0answers
15 views

Median of a data frame - problems coercing data to numeric [migrated]

I have the following data set in Sheet1 of an XLSX file data.xlsx: Prop1 Prop2 Prop3 Value1 Value2 Value3 A B ...
0
votes
2answers
12 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
10 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 ...
0
votes
1answer
52 views
0
votes
1answer
33 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
3 views

how to transfer/export output of rcorr(matrix) into excel table? [migrated]

I use correlation test using code "rcorr", and here it is my script: ...
0
votes
0answers
12 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
53 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 ...
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
12 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
47 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
60 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
30 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
368 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
224 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
52 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
82 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
188 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
1k 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 ...
3
votes
1answer
40 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
91 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
37 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
169 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
70 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
94 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
93 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 ...
2
votes
3answers
107 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 ...
0
votes
1answer
61 views

Two independent events affect probability of third event: find CI for third event

I know the title is vague: I couldn't think of a good one. The basic question can be worded several different ways, but here is how I think of it to make it easier for myself: Sally has only one ...
0
votes
0answers
75 views

Mixed Model t Test (Toothaker’s t-Test)

I'm trying to do a follow up test for a mixed model ANOVA, and I figured that I need do a Mixed Model t test also known as Toothaker's test. I just don't know how do it. I was wondering if anyone has ...
0
votes
1answer
69 views

Student's t-distribution

I have two functions that provide an implementation of the t-distribution. A webpage with a Javascript algorithm. The algorithm takes two input x-value and ...
0
votes
0answers
54 views

Help with panel-data in excel

I want to know if the initiation of a state Renewable Portfolio Standard affects the level of renewable energy output in that state. I don't have access to Stata right now, so I'm stuck using excel. ...
1
vote
0answers
818 views

Manually Calculating P-Value from F-Test - Does not match up

I am trying to manually calculate P-Value (right tailed) from F-Test to understand it better. Would like to learn how the value obtained from the F-Test. Have obtained the below parameters, ...
2
votes
0answers
187 views

Exponential regression: calculating p-value and F significance

I have a set of independent data and dependent data $(X,Y)$, where I would like to do an exponential regression to obtain its p-value and significant $F$ (already obtained $R^2$ and also the ...
0
votes
1answer
48 views

Finding the most relevant factors that lead to an event

I have been tasked with looking at a set of data with about 6000 records that each have 60 or so qualities associated with them (Let these be X1, X2, ... ) and determining what are the top 8 factors ...
6
votes
3answers
8k views

How to check for normal distribution using Excel for performing a t-test?

I want to know how to check a data set for normality in Excel, just to verify that the requirements for using a t-test are being met. For the right tail, is it appropriate to just calculate a mean ...
0
votes
1answer
73 views

Why am I getting this result in modeling a Pareto Type II distribution in Excel?

In Excel for a project I'm trying to model the density, distribution and survival function ($1-F(X)$) and I can't get the density to sum to one and I can't get the distribution to go to one. For the ...
0
votes
1answer
87 views

Normal distribution in Excel

How do I calculate with Excel's formula to answer the question: What is the probability for a student's point is less than 560 by using excel? I know how to answer the question - What is the ...
3
votes
1answer
86 views

Performing calculation of a product of a sequence,

I have performed a calculation that a sample of records will contain at least 1 defective record assuming replacement. There are 20,000,000 records in the population, 7,000 are defective, and I will ...
0
votes
2answers
276 views

how to forecast daily sale using Excel

I am a newbie here. well I am trying to find a method or a formula to forecast meals per day, which have ̀5 meals to upload on flights, sales, wastage and passengers are what I have to consider, the ...
4
votes
3answers
561 views

Generating random numbers from a t-distribution

How can I generate random numbers that follow a student-t distribution? From several sources I understand that this can be done using a random sample of size $n$ drawn from a normally distributed ...
0
votes
1answer
123 views

Finding correlation, triggers and patterns between two (or more datasets)

I am trying to find correlations between multiple data sets, for this example i am using two pieces of data, the closing stock price for Coca-Cola and Pepsi for the last year. I've been pointed in ...
0
votes
1answer
97 views

PCA (NIPALS method) [duplicate]

I am trying to apply PCA (NIPALS method) using Excel. The problem is my results are not exactly matching with the results of R. ...
1
vote
1answer
2k views

How to standardize data in Excel (mean = 0, SD = 1)

I have a large set of variables measured on different scales/units, and want to standardize them to the same scale, with a mean of 0 and standard deviation of 1, so that I can run a PCA on them. I ...
1
vote
1answer
82 views

Determining an optimum and distribution range for a given species abundance vs an environmental gradient data

This is a fairly complex question so I will attempt to ask it in a fairly basic manner. I have data on the abundance of 99 different species of estuarine macroinvertebrate species and the sediment ...
0
votes
1answer
235 views

Fitting discrete points on a normal distribution

I have an ordinal ranking of 16 objects. I know that the value of the first object is 0, the second value is 2, and the last object is 14. I'd like to map each of the intermediate objects to an ...
2
votes
2answers
225 views

Different histograms for same data in R and Oracle Crystal Ball

I am analysing small sample size data: >dput(dat.demand2050.unique) c(79, 56, 69, 61, 53, 73, 72, 86, 75, 68, 74.2, 80, 65.6, 60, 54) for which the ...
0
votes
0answers
64 views

How to test for variance between conditions

I have some Nanostring results that depict the fold change in expression after various conditions are applied. The people I am working with would like to know how to see what conditions give the ...
0
votes
2answers
250 views

How can I get an R-squared value of 1 (fit 100%)?

I have a set of data and plotted it in a graph (in Microsoft Excel) and then added a trendline. The equation I got is $y=833.71x^{-1.448}$ with $R^2=0.9511$. What should I do to get $R^2=1$ (100% ...
2
votes
1answer
159 views

Monte Carlo simulation of low probability events with impact

I wonder if I'm lacking the terminology to phrase this question: I would like to model, in Excel, the risk of a fairly rare event, E, happening over time, where time is divided into chunks called ...