# 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.

396 questions
Filter by
Sorted by
Tagged with
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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)...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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. ...
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 ...
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 ...
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- ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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₀: π = π₀ ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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 ...
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. ...
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 ...
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. ...
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-...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...