Questions tagged [excel]

Microsoft Excel is a commercial spreadsheet program. Use this tag for any on-topic question that (a) involves Excel either as a critical part of the question or expected answer, & (b) is not just about how to use Excel.

Filter by
Sorted by
Tagged with
0
votes
0answers
8 views

Multiple linear regression - Mixed Independent Variables (Categorical and Continuous)

I'm working to improve my knowledge in predictive models. I would like to build a multiple Linear Regression by using Excel as a first step if possible. if not I'm open to solutions with R or Python. ...
0
votes
0answers
5 views

VBA-Execution Error 462: Remote Server Not foubd [migrated]

I am trying to fill a form from Excel. The code opens the web site requested but it did not write the value, it also shows an error of execution ( 462) ''' Sub pullDataFromWeb() Dim IE As Object Dim ...
1
vote
1answer
19 views

Excel how to distribute 2 percentage fields between 3 fields

I'm having a difficulty to figure out how to distribute 2 percentages fields in 3. Let's say we have 2 teams. I think they both have chances 50/50 means that the draw has the percent of 50, 25 for the ...
0
votes
0answers
9 views

Excel NORM.DIST() calculation for a specific value of x (CUMULATIVE = FALSE)? [duplicate]

We know that the value of PDF at a specific time (X = x) is 0 due to the nature of a distribution of a continuous variable. However, I noticed that when I plug in some test numbers in NORM.DIST() in ...
0
votes
0answers
15 views

Best Statistical Test for Median Comparison [duplicate]

I just have a very quick question on some data I have. I was asked to collect data for tumor emergence in two groups of mice. One treated with PBS and another treated with PBS plus Matrigel. The one ...
0
votes
1answer
15 views

What scoring system to use based on two variables

I have an excel file that shows the performance of several keywords in my paid search campaign. I have two variables, number of visits & conversion rate, based on which I want to score each ...
0
votes
0answers
26 views

How much more likely is country B to pass a law if country A passed it first?

I have a 9 columns, divided into three sections. Column A is list of countries. Column B has "1" if the country adopted a law, and "0" if it didn't. Column C has date that law was ...
0
votes
0answers
9 views

Compare decadal mean growth rates between age classes

I would like to compare rates and trends between different age classes, but am a bit stuck in finding the best way to do that. I have calculated decadal mean growth rates per 50-yr age class of a time ...
0
votes
0answers
54 views

How to check normal distribution for categorical data in Excel?

I am currently exploring whether the presence of psychologists on wards has an impact on the number of incidents that occurs on the ward. Independent variable would be Psychologist Presence (Yes or No)...
0
votes
1answer
27 views

How to fit the flipped exponential-function in Excel? [closed]

I would like to know whether it is possible to fit the second graph below in Excel with an exponential fit? Unfortunately the "Exponential fit"-button is greyed out and I can't choose this ...
1
vote
1answer
49 views

Calculating Probability based on Linear Regression in R or Excel

Suppose we have a monthly budget of 1,000. For every day of the month we keep track of the total (cumulative) expenses. For example, let's say we are on 15th November and we have the following vector ...
2
votes
1answer
42 views

Best solution for sports statistics [closed]

I have created a floorball sports statistics in excel. It works like this: I put in data from each match (mininal required data like who was present and who scored etc.) and then I have sheets which ...
2
votes
1answer
71 views

Smoothing algorithm for anomalies

To construct a plot, I'm looking for an algorithm which can handle inf and (very) negative values. If I have infinity values everything is a line but not infinities. Example ...
0
votes
1answer
15 views

Visually show the grouping of things based on relation

I'd like to visually show how certain IoT device's functionality is linked together through some sort of heat map or bubble graph (whichever is appropriate). I have a list of 50 devices, and each ...
0
votes
0answers
23 views

How can I predict whether the last value in my dataset is a missing value or not

I try to predict with a given dataset (as in the example below) whether the last data point is expected to be missing or available. The goal is not to interpolate the missing points but to include ...
1
vote
1answer
16 views

plotting of lines of regressionnof x on y and lines of regression of y on x in MS Excel [closed]

I have following data: x:1 3 5 7 9 y:2 4 5 8 12 I want to plot lines of regression of y on x as well as lines of regression of x on y on the same graph in MS excel. I tried bit it gives only line of ...
0
votes
0answers
21 views

How do you calculate a 4-way mixed ANOVA (4 way SPANOVA) by hand in a spreadsheet?

I would like to include an interactive 4-way mixed ANOVA (4-way SPANOVA) in a google sheets document. Does anyone know how to calculate it by hand in a spreadsheet without the use of SPSS or R?
0
votes
1answer
40 views

Higher Order Category Overlap Analysis

I am attempting to analyse the categorical overlap of a dataset to ultimately ascertain the optimal way of categorising the data to minimise the amount of used categories to describe the dataset. ...
1
vote
1answer
27 views

Why is the Treatments P-value halved after a Geisser-Greenhouse correction for sphericity

I have noticed that when Graphpad Prism does a sphericity correction using the Geisser-Greenhouse correction, it halves the P value for this source of variation (typically Treatments). For example, in ...
2
votes
1answer
75 views

Nonnormal distributions for a monte carlo simulation in Excel

My empirical (price-spread) time series data has a nonnormal distribution (see below) and it has no (partial)-autocorrelation. I am worrying about which distribution fits most to my data, but I think ...
0
votes
1answer
23 views

How to reproduce this p value result from Prism manually in Excel?

Can I get some help with reproducing this p value in Excel? The Ho is theta(CAU) = theta(AA), the Ha is theta(CAU) =(not equal) theta(AA). I tried in Excel by finding the z- score first, then 2*(1- ...
0
votes
1answer
28 views

Calculate correlation between time of day and number of created cases (call center)

I have a data set showing all incoming call during a month and the cases created by the call center agents. The cases are related to a specific call. My hypothesis is that the agents create less ...
0
votes
0answers
8 views

What is the calculation behind norm.dist function in Excel?

For example, I will enter in norm.dist(89,100,50,0) for x, mean,sd, cumulative or no. Do I use the pdf of normal distribution and integrate? Any help would be appreciated and please also explain isn't ...
0
votes
0answers
19 views

What should I use as an error bar for categorical variables with significant difference?

While a confidence interval for a differences of means is straight forward, I am lost on how to create error bars (using excel) for my categorical data. E.g. I have two patient populations and I am ...
0
votes
0answers
90 views

Does anybody has idea bout Time-series data de-trending using quadratic polynomial trend?

I understand how first order differences can be used to remove a linear trend in a time series data set. But how can we detrend a time series with a quadratic trend?
0
votes
0answers
11 views

Why does my lagged target variable have a high p value in multifactor regression?

I'm running a multifactor regression which uses the following data: The first column is my target variable, the following 5 columns are my factors. The final column is my target variable with a lag of ...
0
votes
0answers
20 views

Splitting a single large data set that contains two populations into two data sets

I have a single data set that contains two populations(This is a fact.) The means are different. It's obvious when charting the data, but not obvious to me how to split them. Is there a method or ...
0
votes
1answer
169 views

How to properly calculate the exact p-value for binomial hypothesis testing (e.g. in Excel)?

I am confused with calculation of the p-value for binomial hypothesis testing when not using the normal approximation and its Z-statistic. My hypothesis testing is for the situation when H₀: π = π₀ ...
0
votes
0answers
10 views

Forecast time-series data with initial value

Unlike continuous time-series data you see in most examples, our data is grouped based on start and end condition. Let's call it cool down curve. The start time is triggered when cool down begins and ...
0
votes
0answers
91 views

How to construct an ARMA model MA 1 in excel?

All, I understand how to construct an AR1 ARMA model in excel, which is taking the time series and lagging it by 1 period then constructing a regression model (minus the first period) of that but I ...
0
votes
0answers
13 views

To calculate change between actual and previous week

I would like to calculate the change between the weeks. Is it correct to calculate (Actual - Previous) / Previous. Still if the Previous was negative or actual became negative? Please also check my ...
1
vote
1answer
29 views

Pre and Post Survey Analysis in ANOVA Excel

I have a small end size of 6 participants. They all took the pre and post survey that had 10 questions with ranges associated with them. I did not ID the participants. I am wondering how to plug this ...
0
votes
1answer
266 views

Calculating d prime in SPSS - Signal Detection

I have conducted an experiment in which participants saw one figure (target) briefly followed by a figure (probe) and asked if they were the same (yes) or not (no). Five different figures total, and ...
0
votes
0answers
25 views

T-test. Whether to assume equal or unequal variance [duplicate]

Is it acceptable to assume unequal variance for my data to perform a t-test. If so, what is a justification for this?
0
votes
1answer
35 views

Given an outcome distribution, how to predict summed outcome of N trials

If I have a game that has a know distribution of outcomes, for example, 5% of the time the outcome is 0 10% of the time the outcome is 1 15% of the time the outcome is 5 8% of the time the outcome ...
0
votes
0answers
67 views

probabilistic Loss calculation in excel

This is a homework I received to proceed with an application, which is outside of my knowledge. Any help would be very much appreciated. This may not be the right way to ask questions here, my ...
0
votes
1answer
50 views

How do I get the sample mean and standard deviation? [duplicate]

I am trying to get the mean and standard deviation for the following sample means with the given sample frequencies for each mean. So in a histogram, the x-axis will show the mean range and sample ...
0
votes
0answers
73 views

logistic regression in XLstat Vs R

When I do logistic regression in XLstat and do the same in R with the same data (same variables, exactly the same data ) using the following (essential) code I get totally different coefficients. ...
1
vote
1answer
203 views

Extrapolating survey results for a larger data set

I have a set of survey results in Excel for a sample of "customers" which asks for their income. This is chosen from defined ranges such as "Less than 10k", "10k to 15k", "16 to 20k", etc. The sample ...
1
vote
1answer
144 views

Manual computation for Fishers exact test for tables larger than 2 x 2 [duplicate]

I am wondering how to perform a Fishers exact test on my data which contains two columns and three rows. One of the cells contains zero. ...
1
vote
1answer
54 views

Why does R t.test()'s confidence interval shift slightly w.r.t. alternative hypothesis?

So I've noticed something extremely confusing about t.test, which is that the confidence interval it provides w.r.t a two-sided alt hypothesis seems to be inconsistent with what it provides for a one-...
1
vote
1answer
163 views

How do you calculate or predict the probability of a hotel booking cancellation (Excel)? [closed]

based on past hotel booking transactions, what will be a good and simple way to calculate and predict the probability of cancellation of a hotel booking transaction using excel? I was thinking of ...
1
vote
0answers
22 views

Land Method for Lognormal Distribution

The Land Method is explain here. Anyone knows how I can look up the H*1-α* It says "Tables of these values are given by Gilbert (1987, Tables A-10 and A-12) and Land (1975). " Gilbert (1987) is not ...
0
votes
1answer
20 views

How do i analyze my data statistically [closed]

I need help regarding hypothesis testing. Not a statistics major but familiar with basic concepts (basic descriptive statistics, frequency, measures of: central tendency, location, dispersion) so ...
0
votes
1answer
68 views

ChiSquare is zero even though the values are not identical

I am running a Chisquare test using CHIDIST function in Excel. My observed and expected values are not identical however i get result 0 (zero). There are 75 observed values so I am using 74 freedom ...
0
votes
0answers
20 views

How to calculate covariance between stocks with different observation periods?

Let's say I have three stocks. Stock A and B I have daily prices from 1 Jan 2000 to 31 Dec 2018. Stock C I only have daily prices from 1 Jan 2005 to 31 Dec 2018. Is it possible to calculate the ...
0
votes
0answers
142 views

how to run a two way ANOVA in excel on summary data: counts of consumers

I have a table of counts of consumers, and I would like to run a 2-way ANOVA on them. There are two factors, year and age-group. Please see the following table of data. Although I usually have ...
20
votes
3answers
4k views

What is the name of this plot that has rows with two connected dots?

I've been reading EIA report and this plot captured my attention. I now want to be able to create the same type of plot. It shows the energy productivity evolution between two years (1990-2015) and ...
0
votes
1answer
19 views

Two formulas giving slightly different output

I am struggling to find a proper explanation why the two methods that I use for finding the difference in EXCEL are giving me two slightly different numbers. The idea behind the task is that we have ...
0
votes
0answers
13 views

What data to include in Weibull fit

I have a set of inspection data that I want to fit to a weibull distribution to understand whether further inspection would provide much value. For example, I have 2000 items of which we have ...

1
2 3 4 5
8