Tagged Questions

Excel is a commercial spreadsheet program created by Microsoft.

learn more… | top users | synonyms

0
votes
2answers
29 views

Plotting two graphs of unequal time length in 1 graph

Say I have the following data set. I need to plot both in one graph and when I tried to do so this is what I got. The data of A are not connected by a line so this is not what I want. How do I get ...
0
votes
0answers
19 views

How can I grab specific data points from one spreadsheet based on another spreadsheet? [closed]

I am a journalist currently trying to crunch some data for a story I'm writing about Maine's craft beer industry. I have been given two spreadsheets related to beer production from the state, and ...
0
votes
1answer
86 views

Calculate P value for the correlation coefficient

I would like to understand how people add the P value on a figure for means (Y axis) by age, volume or any other variable (x axis). How did they calculate the P value here? Please check the following ...
2
votes
1answer
49 views

How to build a function with the result of auto.arima in R?

I use: fit = auto.arima(Y, xreg=X) in R to get ARIMA(1,0,0), result as follows: ...
0
votes
0answers
24 views

Bell curve for a table

I have a table in MS-Excel which has cost, product, quartile and Person-days as attributes among others. I have to represent that data in a "nice looking" bell curve or something similar. I haven't ...
1
vote
2answers
64 views

Why is the intersect negative and what does my regression show

I am trying to get my regression right. I want to see, if subs increase how much increase in revenue is seen. The dependent variable is Revenue while the independent variable is subscribers. Least ...
0
votes
0answers
63 views

Regression shows positive linear relationship. Then why this negative equation [duplicate]

I am trying to get my regression right. I want to see, if subs increase how much increase in revenue is seen. The dependent variable is Revenue while the independent variable is subscribers. Least ...
0
votes
0answers
29 views

creating a equation for non linear multiple regression to predict a value based on the inputs given in excel

I have data with 5 columns namely Botany,Zoology,Chemistry,Physics and Rank in a excel sheet . The data here is non linear . So I want to generate a equation in the form of y=a+bx1+cx2+dx3 In ...
1
vote
0answers
40 views

Excel: Data analysis for university rankings

I have some university rankings data where I am asked to analyze whether a higher %of one variable leads to a higher ranking in a particular area. What kind of statistical analysis should I use in ...
0
votes
0answers
23 views

Excel correlate nominal and quantitative

I have the following test data: How do I correlate the "believes" with "before" to determinate if it affects the "after"? When believes is set to 1 the "after" will be (randomly) higher than when ...
0
votes
1answer
80 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 ...
1
vote
2answers
93 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
29 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
39 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
14 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
229 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
19 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
123 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
86 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
35 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
29 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
305 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 ...
8
votes
2answers
286 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
59 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
421 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
87 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
79 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
38 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
77 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
29 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
126 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
61 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
877 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
151 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
134 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
83 views
0
votes
1answer
58 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
162 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
17 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
17 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
118 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
272 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
46 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
511 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
649 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
106 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 ...